Avoid Blank Page in Output PDF when there is Nothing to Print

Possible Usage Scenarios

When the Excel file is empty and the user saves it to PDF using Aspose.Cells, it renders a blank page in output PDF. Sometimes, this default behavior is undesirable. Aspose.Cells provides the PdfSaveOptions.OutputBlankPageWhenNothingToPrint property to deal with this issue. If you will set it as false, then CellsException will occur whenever there is nothing to print in the output PDF.

Avoid Blank Page in Output PDF when there is Nothing to Print

The following sample code creates an empty workbook and then saves it as output PDF after setting the PdfSaveOptions.OutputBlankPageWhenNothingToPrint property as false. Since there is nothing to print in the output PDF, the CellsException occurs as shown below.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
//Create empty workbook.
Workbook wb = new Workbook();
//Create Pdf save options.
PdfSaveOptions opts = new PdfSaveOptions();
//Default value of OutputBlankPageWhenNothingToPrint is true.
//Setting false means - Do not output blank page when there is nothing to print.
opts.setOutputBlankPageWhenNothingToPrint(false);
//Save workbook to Pdf format, it will throw exception because workbook has nothing to print.
ByteArrayOutputStream baos = new ByteArrayOutputStream();
try
{
wb.save(baos, opts);
}
catch(Exception ex)
{
System.out.println("Exception Message: " + ex.getMessage());
}

Exception

 Exception in thread "main" com.aspose.cells.CellsException: There is nothing to output/print.

	at com.aspose.cells.zcab.a(Unknown Source)

	at com.aspose.cells.zcab.a(Unknown Source)

	at com.aspose.cells.zcab.a(Unknown Source)

	at com.aspose.cells.Workbook.a(Unknown Source)

	at com.aspose.cells.Workbook.save(Unknown Source)