Output Blank Page when there is Nothing to Print with Node.js via C++

Possible Usage Scenarios

If the sheet is empty, then Aspose.Cells will not print anything when you export the worksheet to an image. You can change this behavior by using ImageOrPrintOptions.getOutputBlankPageWhenNothingToPrint() property. When you set it to true, it will print a blank page.

Output Blank Page when there is Nothing to Print

The following sample code creates an empty workbook that has an empty worksheet and renders the empty worksheet to an image after setting the ImageOrPrintOptions.getOutputBlankPageWhenNothingToPrint() property to true. Consequently, it generates a blank page because there is nothing to print, which you can see in the image below.

Sample Code

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

// Output directory
const outputDir = path.join(__dirname, "output");

// Create workbook
const wb = new AsposeCells.Workbook();

// Access first worksheet - it is an empty sheet
const ws = wb.getWorksheets().get(0);

// Specify image or print options
// Since the sheet is blank, we will set OutputBlankPageWhenNothingToPrint to true
// So that the empty page gets printed
const opts = new AsposeCells.ImageOrPrintOptions();
opts.setImageType(AsposeCells.ImageType.Png);
opts.setOutputBlankPageWhenNothingToPrint(true);

// Render empty sheet to PNG image
const sr = new AsposeCells.SheetRender(ws, opts);
sr.toImage(0, path.join(outputDir, "OutputBlankPageWhenNothingToPrint.png"));