public FileResult Export()
{
DataTable dt = ExportToExcel.ExportGeneric <List <InvoiceModel> >(listInvoice);
for (int i = 0; i < dt.Columns.Count; i++)
{
if ((dt.Columns[i].ColumnName.ToString().Contains("DATE") ||
(dt.Columns[i].ColumnName.ToString().Contains("Date"))))
{
var name = dt.Columns[i].ColumnName;
if (!(dt.Columns[i].ColumnName.ToString().Contains("FORMAT")))
{
dt.Columns.Remove(dt.Columns[i].ColumnName.ToString());
}
}
}
var fileName = "cod" + ".xlsx"; //declaration.xlsx";
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
using (MemoryStream stream = new MemoryStream())
{
try
{
wb.SaveAs(stream);
return(File(stream.ToArray(),
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName));
}
catch (Exception ex)
{
throw;
}
}
}
}
