Aspose::Cells::PaginatedSaveOptions::SetPrintingPageType method

PaginatedSaveOptions::SetPrintingPageType method

Indicates which pages will not be printed.

void Aspose::Cells::PaginatedSaveOptions::SetPrintingPageType(PrintingPageType value)

Remarks

If content in the sheet is sparse, there will be some pages are totally blank in the output pdf file. If you don’t want these blank pages, you can use this option to omit them.

Examples

Aspose::Cells::Startup();
//The following code omits blank pages or pages which only contains some style content like cell background, borders.
Workbook wb(u"Book1.xlsx");

PdfSaveOptions pdfSaveOptions;

//ignore blank pages
if (pdfSaveOptions.GetPrintingPageType() != PrintingPageType::IgnoreBlank)
{
    pdfSaveOptions.SetPrintingPageType(PrintingPageType::IgnoreBlank);
}

wb.Save(u"output_ignore_blank_page.pdf", pdfSaveOptions);


//ignore blank pages and pages which only contains some style content like cell background
if (pdfSaveOptions.GetPrintingPageType() != PrintingPageType::IgnoreStyle)
{
    pdfSaveOptions.SetPrintingPageType(PrintingPageType::IgnoreStyle);
}

wb.Save(u"output_ignore_blank_and_style_page.pdf", pdfSaveOptions);
Aspose::Cells::Cleanup();

See Also

Aspose::Cells::PaginatedSaveOptions::GetPrintingPageType method Aspose::Cells::PaginatedSaveOptions::GetGridlineType method