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