public void TestMethod_ConvertXlsxDocumentToPDF_Force_Portrait() { using (IExcelToPdfService service = new ExcelToPdfService(_logger)) { SaveWorkbookToPdfRequest model = new SaveWorkbookToPdfRequest() { DestinationFilePath = Path.Combine(Directory.GetCurrentDirectory(), "VecompSoftwareTest.xlsx.pdf"), SourceFilePath = Path.Combine(Directory.GetCurrentDirectory(), @"TestFiles\VecompSoftwareTest.xlsx"), ForcePortrait = true, }; Assert.IsTrue(service.SaveTo(model)); } }
public bool Convert(string source, string destination, ConversionMode conversionMode = ConversionMode.Default) { using (_service = new ExcelToPdfService(_logger)) { SaveWorkbookToPdfRequest model = new SaveWorkbookToPdfRequest() { DestinationFilePath = destination, ForcePortrait = ForcePortrait, FitToPagesTall = FitToPagesTall, FitToPagesWide = FitToPagesWide, SourceFilePath = source }; return(_service.SaveTo(model)); } }
private void ForcePortrait(dynamic sheet, SaveWorkbookToPdfRequest model) { if (model.FitToPagesTall.HasValue || model.FitToPagesWide.HasValue) { sheet.PageSetup.Zoom = false; if (model.FitToPagesTall.HasValue) { sheet.PageSetup.FitToPagesTall = model.FitToPagesTall.Value; } if (model.FitToPagesWide.HasValue) { sheet.PageSetup.FitToPagesWide = model.FitToPagesWide.Value; } } sheet.PageSetup.Orientation = WorkbookOrientation.Portrait; }
private void SetSheetsPaging(SaveWorkbookToPdfRequest model) { if (_excelWorkbook.Sheets == null) { return; } foreach (dynamic sheet in _excelWorkbook.Sheets) { if (model.ForcePortrait) { ForcePortrait(sheet, model); } sheet.PageSetup.PaperSize = WorkbookPaperSize.A4; } }
public bool SaveTo(SaveWorkbookToPdfRequest model) { try { return(RetryingPolicyAction <bool>(() => { _logger.WriteInfo(new LogMessage(string.Concat("SaveTo -> process item ", model.SourceFilePath, ". Workbook type: ", Path.GetExtension(model.SourceFilePath))), LogCategories); OpenWorkbook(model.SourceFilePath); SetSheetsPaging(model); _excelWorkbook.ExportAsFixedFormat(WorkbookExportFormat.PDF, model.DestinationFilePath); _logger.WriteInfo(new LogMessage("SaveTo -> item saved to pdf correctly"), LogCategories); return true; }, "EXCEL", _logger, LogCategories)); } catch (Exception ex) { _logger.WriteError(new LogMessage(string.Concat("SaveTo -> error on convert item ", model.SourceFilePath, " to pdf")), ex, LogCategories); throw; } }