public ActionResult ExportExcel()
{
DataSet ds = BL_bulk.GetBiddingDump(Convert.ToInt32(Session["PropId"]));
XLWorkbook wb = null;
try
{
using (wb = new XLWorkbook())
{
for (int i = 0; i < ds.Tables.Count; i++)
{
wb.Worksheets.Add(ds.Tables[i], GetSheetName(i));
foreach (IXLWorksheet workSheet in wb.Worksheets)
{
foreach (IXLTable tab in workSheet.Tables)
{
workSheet.Table(tab.Name).ShowAutoFilter = false;
workSheet.Columns().AdjustToContents();
}
}
}
}
}
catch (Exception)
{
Response.Write("<script>alert('Something went wrong !!!')</script>");
}
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=Report.xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
System.Web.HttpContext.Current.ApplicationInstance.CompleteRequest();
}
if (TempData["StartDate"] != null && TempData["StartDate"].ToString().Trim() != "")
{
ViewData["StartDate"] = TempData["StartDate"];
}
else
{
ViewData["StartDate"] = "";
}
return(View("Index"));
}
