Render One PDF Page Per Excel Worksheet - Excel to PDF Conversion

When working with large Microsoft Excel files (for example a workbook that has many sheets, each with 50 columns and 300 or more rows of data), you might want the PDF output to show one page per worksheet, regardless of the size of the worksheet. This would mean that each page is likely to have a radically different page size. This can be achieved by using Aspose.Cells for Python via .NET API.

Please see the following sample code that converts an Excel file with multiple worksheets to PDF.

from aspose.cells import PdfSaveOptions, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Initialize a new Workbook
#  Open an Excel file
workbook = Workbook(dataDir + "input.xlsx")
#  Implement one page per worksheet option
pdfSaveOptions = PdfSaveOptions()
pdfSaveOptions.one_page_per_sheet = True
#  Save the PDF file
workbook.save(dataDir + "OutputFile.out.pdf", pdfSaveOptions)

If the PdfSaveOptions.one_page_per_sheet option is set to true, all the sheet content will be rendered to one PDF page.

If your spreadsheet contains formulas, it is best to call Workbook.calculate_formula method just before rendering the spreadsheet to PDF. This ensures that the formula dependent values are recalculated, and the correct values are rendered in the PDF.