Save Specified Worksheets to PDF

By default, Aspose.Cells for Python via .NET save all visible worksheets in a workbook to pdf file. With PdfSaveOptions.sheet_set option, you can save specified worksheets to pdf file. e.g. you can save active worksheet to pdf, save all worksheets(both visible and hidden worksheets) to pdf, save custom multiple worksheets to pdf.

Save Active Worksheet to PDF

If you want to only export active sheet to pdf, you can achieve this by passing SheetSet.active to PdfSaveOptions.sheet_set option.

The sheet Sheet2 is the acitve sheet of the source file sheetset-example.xlsx.

Save All Worksheets to PDF

SheetSet.visible indicates visible sheets in a workbook, and SheetSet.all indicates all sheets including both visible sheets and hidden/invisible sheets in a workbook. If you want to export all sheets to pdf, you can just pass SheetSet.all to PdfSaveOptions.sheet_set option.

The source file sheetset-example.xlsx contains all four sheets with hidden sheet Sheet3.

Save Specified Worksheets to PDF

If you want to export desired/custom multiple sheets to pdf, you can achieve this by passing multiple sheet indices to PdfSaveOptions.sheet_set option.