Save Each Worksheet to a Different PDF File

Save Each Worksheet to a Different PDF File

If you need to save each worksheet in your template Excel file to generate different PDF files, you can achieve this easily. You may try to set one sheet index to PdfSaveOptions.sheet_set option at a time to render to PDF.

from aspose.cells import PdfSaveOptions, Workbook
from aspose.cells.rendering import SheetSet
# 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(".")
# Get the Excel file path
filePath = dataDir + "input.xlsx"
# Instantiage a new workbook and open the Excel, File from its location
workbook = Workbook(filePath)
# Get the count of the worksheets in the workbook
sheetCount = len(workbook.worksheets)
# Define PdfSaveOptions
pdfSaveOptions = PdfSaveOptions()
# Take Pdfs of each sheet
for j in range(sheetCount):
ws = workbook.worksheets[j]
# set worksheet to output
sheetSet = SheetSet([ws.index])
pdfSaveOptions.sheet_set = sheetSet
workbook.save(dataDir + "worksheet-" + ws.name + ".out.pdf", pdfSaveOptions)