protected string GenerateExcelFile(List <int> channels, List <int> products) { string filename = string.Format("Canon-Export-{0}-{1}-{2}.xls", deExportStartDate.Date.ToString("dd.MM.yyyy"), deExportFinishDate.Date.ToString("dd.MM.yyyy"), SessionManager.LoggedUser.UserId); string fullname = Path.Combine(Server.MapPath(ConfigSettings.UploadDirectory), filename); //Save records to Excel file using (MemXlsWriter xlsWriter = new MemXlsWriter(fullname, false)) { xlsWriter.CultureToSaveDecimals = "en-GB";//SessionManager.CurrentLanguage; xlsWriter.XlsWriteHeaderManySheets(); DateTime finish = deExportFinishDate.Date.Date; for (DateTime i = deExportStartDate.Date.Date; i <= finish; i = i.AddDays(1)) { DataTable dayResults = this.GenerateExcelData(channels, products, i); dayResults = this.ModifyExcelResults(dayResults); if (dayResults == null) { continue; } xlsWriter.XlsWriteDataTable(dayResults, 1, " ", i.ToString("dd.MM.yyyy")); } xlsWriter.XlsWriteFooterManySheets(); } return(filename); }
protected string GenerateExcelFile(List<int> channels, List<int> products) { string filename = string.Format("Canon-Export-{0}-{1}-{2}.xls", deExportStartDate.Date.ToString("dd.MM.yyyy"), deExportFinishDate.Date.ToString("dd.MM.yyyy"), SessionManager.LoggedUser.UserId); string fullname = Path.Combine(Server.MapPath(ConfigSettings.UploadDirectory), filename); //Save records to Excel file using (MemXlsWriter xlsWriter = new MemXlsWriter(fullname, false)) { xlsWriter.CultureToSaveDecimals = "en-GB";//SessionManager.CurrentLanguage; xlsWriter.XlsWriteHeaderManySheets(); DateTime finish = deExportFinishDate.Date.Date; for (DateTime i = deExportStartDate.Date.Date; i <= finish; i=i.AddDays(1)) { DataTable dayResults = this.GenerateExcelData(channels, products, i); dayResults = this.ModifyExcelResults(dayResults); if (dayResults == null) continue; xlsWriter.XlsWriteDataTable(dayResults, 1, " ", i.ToString("dd.MM.yyyy")); } xlsWriter.XlsWriteFooterManySheets(); } return filename; }