Save Specified Worksheets to PDF with Node.js via C++

By default, Aspose.Cells saves all visible worksheets in a workbook to a PDF file. With the PdfSaveOptions.getSheetSet() option, you can save specified worksheets to a PDF file, e.g., you can save the active worksheet to PDF, save all worksheets (both visible and hidden) to PDF, or save custom multiple worksheets to PDF.

Save Active Worksheet to PDF

If you only want to export the active sheet to PDF, you can achieve this by passing SheetSet.getActive() to the PdfSaveOptions.setSheetSet() method.

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

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sheetset-example.xlsx");

// Open the template Excel file
const workbook = new AsposeCells.Workbook(filePath);

// Set active sheet to output
const pdfSaveOptions = new AsposeCells.PdfSaveOptions();
pdfSaveOptions.setSheetSet(AsposeCells.SheetSet.getActive());

// Save the PDF file with PdfSaveOptions
workbook.save("output.pdf", pdfSaveOptions);

Save All Worksheets to PDF

SheetSet.getVisible() returns visible sheets in a workbook, and SheetSet.getAll() returns all sheets, including both visible and hidden/invisible sheets. If you want to export all sheets to PDF, simply pass SheetSet.getAll() to the PdfSaveOptions.setSheetSet() method.

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

const AsposeCells = require("aspose.cells.node");
const path = require("path");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sheetset-example.xlsx");

// Open the template Excel file
const workbook = new AsposeCells.Workbook(filePath);

// Set all sheets to output
const pdfSaveOptions = new AsposeCells.PdfSaveOptions();
pdfSaveOptions.setSheetSet(AsposeCells.SheetSet.getAll());

// Save the PDF file with PdfSaveOptions
workbook.save("output.pdf", pdfSaveOptions);

Save Specified Worksheets to PDF

If you want to export specific/custom multiple sheets to PDF, you can achieve this by passing multiple sheet indices to the PdfSaveOptions.setSheetSet() method.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sheetset-example.xlsx");

// Open the template Excel file
const workbook = new AsposeCells.Workbook(filePath);

// Set custom multiple sheets (Sheet1, Sheet3) to output
const sheetSet = new AsposeCells.SheetSet([0, 2]);
const pdfSaveOptions = new AsposeCells.PdfSaveOptions();
pdfSaveOptions.setSheetSet(sheetSet);

// Save the PDF file with PdfSaveOptions
workbook.save("output.pdf", pdfSaveOptions);

Reorder Worksheets to PDF

If you want to reorder sheets (e.g., in reverse order) for PDF output without modifying the source file, you can achieve this by passing reordered sheet indices to the PdfSaveOptions.setSheetSet() method.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "sheetset-example.xlsx");

// Open the template Excel file
const wb = new AsposeCells.Workbook(filePath);

// Reorder sheets (Sheet1, Sheet2, Sheet3, Sheet4) to (Sheet4, Sheet3, Sheet2, Sheet1)
const sheetSet = new AsposeCells.SheetSet([3, 2, 1, 0]);
const pdfSaveOptions = new AsposeCells.PdfSaveOptions();
pdfSaveOptions.setSheetSet(sheetSet);

// Save the PDF file with PdfSaveOptions
wb.save("output.pdf", pdfSaveOptions);

If your spreadsheet contains formulas, it is best to call Workbook.calculateFormula() just before rendering the spreadsheet to PDF format. Doing so will ensure that the formula‑dependent values are recalculated, and the correct values are rendered in the PDF.