Output Blank Page when there is Nothing to Print
Possible Usage Scenarios
If the sheet is empty, then Aspose.Cells will not print anything when you export worksheet to image. You can change this behavior by using ImageOrPrintOptions.OutputBlankPageWhenNothingToPrint property. When you will set it to true, it will print the blank page.
Output Blank Page when there is Nothing to Print
The following sample code creates the empty workbook which has an empty worksheet and renders the empty worksheet to an image after setting the ImageOrPrintOptions.OutputBlankPageWhenNothingToPrint property as true. Consequently, it generates the blank page as there is nothing to print which you can see as below.
Sample Code
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
String outDir = Utils.Get_OutputDirectory(); | |
// Create workbook | |
Workbook wb = new Workbook(); | |
// Access first worksheet - it is empty sheet | |
Worksheet ws = wb.getWorksheets().get(0); | |
// Specify image or print options | |
// Since the sheet is blank, we will set | |
// OutputBlankPageWhenNothingToPrint to true | |
// So that empty page gets printed | |
ImageOrPrintOptions opts = new ImageOrPrintOptions(); | |
opts.setImageType(ImageType.PNG); | |
opts.setOutputBlankPageWhenNothingToPrint(true); | |
// Render empty sheet to png image | |
SheetRender sr = new SheetRender(ws, opts); | |
sr.toImage(0, outDir + "OutputBlankPageWhenNothingToPrint.png"); |