public ActionResult ExcelExport() { ParameterEntities newParam = new ParameterEntities(); List <ParameterEntities> FileData = new List <ParameterEntities>(); FileData = paramSvc.GetListParameter(null, null); try { DataTable Dt = new DataTable(); Dt.Columns.Add("CODE", typeof(string)); Dt.Columns.Add("category", typeof(string)); foreach (var data in FileData) { DataRow row = Dt.NewRow(); row[0] = data.CODE; row[1] = data.DESCRIPTION; Dt.Rows.Add(row); } var memoryStream = new MemoryStream(); using (var excelPackage = new ExcelPackage(memoryStream)) { var worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1"); worksheet.Cells["A1"].LoadFromDataTable(Dt, true, TableStyles.None); worksheet.Cells["A1:AN1"].Style.Font.Bold = true; worksheet.DefaultRowHeight = 18; worksheet.Column(2).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; worksheet.Column(6).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; worksheet.Column(7).Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; worksheet.DefaultColWidth = 20; worksheet.Column(2).AutoFit(); Session["DownloadExcel_FileManager"] = excelPackage.GetAsByteArray(); return(Json("", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { throw; } }