public FileDto ExportToExcelMarketingFactor(ExportMarketingFactorListDto exportMarketingListDto) { return(CreateExcelPackage( exportMarketingListDto.schemeName + ".xlsx", excelPackage => { var sheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); var headerCells = sheet.Cells[1, 1]; var headerFont = headerCells.Style.Font; headerFont.Size = 16; headerFont.Bold = true; headerFont.Italic = true; headerCells.Value = "View Detail Unit"; sheet.DefaultColWidth = 25; AddHeaders( sheet, 3, L("UnitCode"), L("UnitNo"), L("Price/m2") ); AddObjects( sheet, 4, exportMarketingListDto.unit, _ => _.unitCode, _ => _.unitNo, _ => _.priceM2 ); } )); }
public FileDto ExportToExcelMarketingFactor(ExportMarketingFactorListDto param) { var fileExcel = _marketingFactorExporter.ExportToExcelMarketingFactor(param); var filePath = Path.Combine(AppFolders.TempFileDownloadFolder, fileExcel.FileToken); if (!System.IO.File.Exists(filePath)) { throw new UserFriendlyException(L("RequestedFileDoesNotExists")); } var pathExport = ConfigurationManager.AppSettings["marketingFactorExportPath"].ToString(); //retrieve data excel from temporary download folder var fileBytes = System.IO.File.ReadAllBytes(filePath); //write excel file to share folder / local folder File.WriteAllBytes(pathExport + fileExcel.FileName, fileBytes); return(fileExcel); }