public FileResult ExportRpt(DateTime?fromDTP, DateTime?toDTP)
{
String userId = User.Identity.GetUserId();
DataTable dt = dService.GetReportData(fromDTP, toDTP, userId);
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(dt);
using (MemoryStream st = new MemoryStream())
{
wb.SaveAs(st);
return(File(st.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Chargeback_Report.xlsx"));
}
}
}
