var workbook = new XLWorkbook(); var worksheet_1 = workbook.Worksheets.Add("Summary Report"); CreateLayout(worksheet_1, dt_Clone, dtS, strHeaderList, strReportHeader, additionalReportHeader); FillData(ds, worksheet_1, dt_Clone); worksheet_ProjectionSummary.PageSetup.PageOrientation = XLPageOrientation.Landscape; string folder_path = Server.MapPath("~\\Reports\\"); string fileName = "SummaryReport_" + Session["Id"].ToString() + ".xlsx"; string fName = folder_path + fileName; string[] fileEntries = Directory.GetFiles(folder_path); foreach (string FName in fileEntries) { if (FName.Contains("SummaryReport")) { System.IO.File.Delete(FName); } } workbook.SaveAs(fName);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)