for_rendering_by_page_breaks method

for_rendering_by_page_breaks

Initializes a SpreadsheetOptions instance configured to split worksheets into pages by page breaks.

For details, see the documentation.

def for_rendering_by_page_breaks(cls):
    ...

Returns: New SpreadsheetOptions instance for splitting to pages by page breaks. The behavior is similar to printing in Excel.

Example

from groupdocs.viewer import Viewer
from groupdocs.viewer.options import PdfViewOptions, SpreadsheetOptions

def split_by_page_breaks():
    # Load spreadsheet
    with Viewer("products.xlsx") as viewer:
        # Convert the spreadsheet to PDF.
        view_options = PdfViewOptions("split_by_page_breaks/by_page_breaks.pdf")
        # Split using page breaks.
        view_options.spreadsheet_options = SpreadsheetOptions.for_rendering_by_page_breaks()
        viewer.view(view_options)

if __name__ == "__main__":
    split_by_page_breaks()

See Also