Limit the Number of Pages Generated - Excel to PDF Conversion
Contents
[
Hide
]
Sometimes, you want to print a range of pages to an output PDF file. Aspose.Cells for Python via .NET has the ability to set a limit on how many pages are generated when converting an Excel spreadsheet to the PDF file format.
Limiting the Number of Pages Generated
The following example shows how to render a range of pages (3 and 4) in a Microsoft Excel file to PDF.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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(".") | |
# Open an Excel file | |
wb = Workbook(dataDir + "TestBook.xlsx") | |
# Instantiate the PdfSaveOption | |
options = PdfSaveOptions() | |
# Print only Page 3 and Page 4 in the output PDF | |
# Starting page index (0-based index) | |
options.page_index = 3 | |
# Number of pages to be printed | |
options.page_count = 2 | |
# Save the PDF file | |
wb.save(dataDir + "outPDF1.out.pdf", options) |
If the spreadsheet contains formulas, it is best to call Workbook.calculate_formula method just before rendering it to PDF. Doing ensures that formula dependent values are recalculated, and the correct values are rendered in the output file.