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; } } } }