public ActionResult ExportToExcel(string datepicker, string datepicker1) { using (new ExcelPackage()) { var startDate = DateTime.Parse(datepicker).AddHours(7); var endDate = DateTime.Parse(datepicker1).AddHours(7); var dataSet = CheckRecords.GetListofRecordsForExcelReport(startDate, endDate); string path = "C:\\checks\\templateChecks.xlsx"; FileInfo Files = new FileInfo(path); ExcelPackage excel = new ExcelPackage(Files); var worksheet = excel.Workbook.Worksheets["Sheet1"]; for (int i = 0; i < dataSet.Count; i++) { } excel.SaveAs(new FileInfo(@"c:\checks\templateChecks1.xlsx")); } return View("Report"); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)