# Split a worksheet into pages Split worksheets into pages when rendering spreadsheets to HTML, PDF, and image formats using GroupDocs.Viewer Python API. GroupDocs.Viewer can split a worksheet into pages in five ways, each covered below: ![Five SpreadsheetOptions factory methods: for_one_page_per_sheet puts the whole worksheet on one page, for_rendering_by_page_breaks splits it at Excel's page breaks, for_rendering_print_area renders only the print area, for_rendering_print_area_and_page_breaks splits the print area at the page breaks, and for_split_sheet_into_pages takes a fixed number of rows and columns per page](https://docs.groupdocs.com/viewer/python-net/images/rendering-basics/render-spreadsheets/split-worksheet-into-pages.svg) ## Split a worksheet by page breaks GroupDocs.Viewer uses page breaks to split a worksheet into separate pages. Microsoft Excel adds automatic page breaks based on paper size and page settings, but you can also insert manual horizontal and vertical page breaks. Switch to **Page Break Preview** in Microsoft Excel to see where page breaks appear on a worksheet. In the image below, the vertical page break is inserted after the column **E**, and the horizontal page break is located under the row **30**. ![Preview page breaks in Microsoft Excel](https://docs.groupdocs.com/viewer/python-net/images/rendering-basics/render-spreadsheets/excel-page-break-preview.png) To render a worksheet based on the inserted page breaks, call the [SpreadsheetOptions.for_rendering_by_page_breaks](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/spreadsheetoptions/#methods) static method and assign the returned `SpreadsheetOptions` instance to the [ViewOptions.spreadsheet_options](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/baseviewoptions/#properties) property of your view (depending on the output file format). The following example converts a worksheet to PDF and uses the page breaks to split this worksheet into pages: {{< tabs "example1">}} {{< tab "Python" >}} ```python 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. viewOptions = PdfViewOptions("split_by_page_breaks/by_page_breaks.pdf") # Split using page breaks. viewOptions.spreadsheet_options = SpreadsheetOptions.for_rendering_by_page_breaks() viewer.view(viewOptions) if __name__ == "__main__": split_by_page_breaks() ``` {{< /tab >}} {{< tab "products.xlsx" >}} {{< tab-text >}} `products.xlsx` is the sample file used in this example. Click [here](https://docs.groupdocs.com/viewer/python-net/_sample_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/products.xlsx) to download it. {{< /tab-text >}} {{< /tab >}} {{< tab "by_page_breaks.pdf" >}} ```text Binary file (PDF, 75 KB) ``` [Download full output](https://docs.groupdocs.com/viewer/python-net/_output_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/split_by_page_breaks/by_page_breaks.pdf) {{< /tab >}} {{< /tabs >}} ## Split a worksheet into pages by rows The following code snippet splits a worksheet into two pages and renders them to PDF: {{< tabs "example2">}} {{< tab "Python" >}} ```python from groupdocs.viewer import Viewer from groupdocs.viewer.options import PdfViewOptions, SpreadsheetOptions def split_by_rows(): # Load spreadsheet with Viewer("two-pages.xlsx") as viewer: # Specify number of rows for every page. rows_per_page = 15 # Convert the spreadsheet to PDF. viewOptions = PdfViewOptions("split_by_rows/by_rows.pdf") # Split by number of rows. viewOptions.spreadsheet_options = SpreadsheetOptions.for_split_sheet_into_pages(rows_per_page) viewer.view(viewOptions) if __name__ == "__main__": split_by_rows() ``` {{< /tab >}} {{< tab "two-pages.xlsx" >}} {{< tab-text >}} `two-pages.xlsx` is the sample file used in this example. Click [here](https://docs.groupdocs.com/viewer/python-net/_sample_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/two-pages.xlsx) to download it. {{< /tab-text >}} {{< /tab >}} {{< tab "by_rows.pdf" >}} ```text Binary file (PDF, 41 KB) ``` [Download full output](https://docs.groupdocs.com/viewer/python-net/_output_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/split_by_rows/by_rows.pdf) {{< /tab >}} {{< /tabs >}} ## Split a worksheet into pages by rows and columns The following code snippet splits a worksheet into four pages and renders them to PDF: {{< tabs "example3">}} {{< tab "Python" >}} ```python from groupdocs.viewer import Viewer from groupdocs.viewer.options import PdfViewOptions, SpreadsheetOptions def split_by_rows_and_columns(): # Load spreadsheet with Viewer("four-pages.xlsx") as viewer: # Specify number of rows and columns for every page. rows_per_page = 15 column_per_page = 7 # Convert the spreadsheet to PDF. viewOptions = PdfViewOptions("split_by_rows_and_columns/by_rows_and_columns.pdf") # Split by number of rows and columns. viewOptions.spreadsheet_options = SpreadsheetOptions.for_split_sheet_into_pages(rows_per_page, column_per_page) viewer.view(viewOptions) if __name__ == "__main__": split_by_rows_and_columns() ``` {{< /tab >}} {{< tab "four-pages.xlsx" >}} {{< tab-text >}} `four-pages.xlsx` is the sample file used in this example. Click [here](https://docs.groupdocs.com/viewer/python-net/_sample_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/four-pages.xlsx) to download it. {{< /tab-text >}} {{< /tab >}} {{< tab "by_rows_and_columns.pdf" >}} ```text Binary file (PDF, 53 KB) ``` [Download full output](https://docs.groupdocs.com/viewer/python-net/_output_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/split_by_rows_and_columns/by_rows_and_columns.pdf) {{< /tab >}} {{< /tabs >}} ## Render a print area In Microsoft Excel, you can designate one or more cell ranges in a worksheet as the only region to print (a _print area_). A worksheet can contain multiple print areas. Each print area prints on its own page. ![Specify a print area in Microsoft Excel](https://docs.groupdocs.com/viewer/python-net/images/rendering-basics/render-spreadsheets/excel-set-print-area.png) GroupDocs.Viewer also supports this option. Call the [SpreadsheetOptions.for_rendering_print_area](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/spreadsheetoptions/#methods) static method and assign the returned `SpreadsheetOptions` instance to the [ViewOptions.spreadsheet_options](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/baseviewoptions/#properties) property to display only the worksheet's print area in the output HTML, PDF, or image file. The following example renders the print area displayed in the image above to PDF: {{< tabs "example4">}} {{< tab "Python" >}} ```python from groupdocs.viewer import Viewer from groupdocs.viewer.options import PdfViewOptions, SpreadsheetOptions def render_print_area(): # Load spreadsheet with Viewer("invoice.xlsx") as viewer: # Convert the spreadsheet to PDF. viewOptions = PdfViewOptions("render_print_area/print_area.pdf") # Render the print area only. viewOptions.spreadsheet_options = SpreadsheetOptions.for_rendering_print_area() viewer.view(viewOptions) if __name__ == "__main__": render_print_area() ``` {{< /tab >}} {{< tab "invoice.xlsx" >}} {{< tab-text >}} `invoice.xlsx` is the sample file used in this example. Click [here](https://docs.groupdocs.com/viewer/python-net/_sample_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/invoice.xlsx) to download it. {{< /tab-text >}} {{< /tab >}} {{< tab "print_area.pdf" >}} ```text Binary file (PDF, 54 KB) ``` [Download full output](https://docs.groupdocs.com/viewer/python-net/_output_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/render_print_area/print_area.pdf) {{< /tab >}} {{< /tabs >}} ## Render a worksheet on one page If you want to display all worksheet data on one page, call the [SpreadsheetOptions.for_one_page_per_sheet](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/spreadsheetoptions/#methods) static method and assign the returned `SpreadsheetOptions` instance to the [ViewOptions.spreadsheet_options](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/baseviewoptions/#properties) property for a target view. The following example converts each worksheet to one page in the PDF file: {{< tabs "example5">}} {{< tab "Python" >}} ```python from groupdocs.viewer import Viewer from groupdocs.viewer.options import PdfViewOptions, SpreadsheetOptions def render_one_page_per_sheet(): # Load spreadsheet with Viewer("products.xlsx") as viewer: # Convert the spreadsheet to PDF. viewOptions = PdfViewOptions("render_one_page_per_sheet/one_page_per_sheet.pdf") # Render each worksheet to one page. viewOptions.spreadsheet_options = SpreadsheetOptions.for_one_page_per_sheet() viewer.view(viewOptions) if __name__ == "__main__": render_one_page_per_sheet() ``` {{< /tab >}} {{< tab "products.xlsx" >}} {{< tab-text >}} `products.xlsx` is the sample file used in this example. Click [here](https://docs.groupdocs.com/viewer/python-net/_sample_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/products.xlsx) to download it. {{< /tab-text >}} {{< /tab >}} {{< tab "one_page_per_sheet.pdf" >}} ```text Binary file (PDF, 73 KB) ``` [Download full output](https://docs.groupdocs.com/viewer/python-net/_output_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/render_one_page_per_sheet/one_page_per_sheet.pdf) {{< /tab >}} {{< /tabs >}} The output PDF file contains one page that displays all worksheet data. ## Render worksheet by page breaks and print area GroupDocs.Viewer uses page breaks to split a worksheet into separate pages. Microsoft Excel adds automatic page breaks based on paper size and page settings, but you can also insert manual horizontal and vertical page breaks. Switch to **Page Break Preview** in Microsoft Excel to see where page breaks appear on a worksheet. Also, you can designate one or more cell ranges in a worksheet as the only region to print (a _print area_). A worksheet can contain multiple print areas. Each print area prints on its own page. When printing, Microsoft Excel splits a worksheet into pages using both page breaks and print areas. In the following image the red line shows the print area, and the blue line shows page breaks: ![Specify page breaks and a print area in Microsoft Excel](https://docs.groupdocs.com/viewer/python-net/images/rendering-basics/render-spreadsheets/page-breake-vs-print-area.png) GroupDocs.Viewer also supports this option. Call the [SpreadsheetOptions.for_rendering_print_area_and_page_breaks](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/spreadsheetoptions/#methods) static method and assign the returned `SpreadsheetOptions` instance to the [ViewOptions.spreadsheet_options](https://reference.groupdocs.com/viewer/python-net/groupdocs.viewer.options/baseviewoptions/#properties) property to display only the worksheet's print area in the output HTML, PDF, or image file. The following example renders the Microsoft Excel spreadsheet using page breaks and print areas displayed in the image above to PDF: {{< tabs "example6">}} {{< tab "Python" >}} ```python from groupdocs.viewer import Viewer from groupdocs.viewer.options import PdfViewOptions, SpreadsheetOptions def render_print_area_and_page_breaks(): # Load spreadsheet with Viewer("products.xlsx") as viewer: # Render the spreadsheet to PDF. viewOptions = PdfViewOptions("render_print_area_and_page_breaks/print_area_and_page_breaks.pdf") viewOptions.spreadsheet_options = SpreadsheetOptions.for_rendering_print_area_and_page_breaks() viewer.view(viewOptions) if __name__ == "__main__": render_print_area_and_page_breaks() ``` {{< /tab >}} {{< tab "products.xlsx" >}} {{< tab-text >}} `products.xlsx` is the sample file used in this example. Click [here](https://docs.groupdocs.com/viewer/python-net/_sample_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/products.xlsx) to download it. {{< /tab-text >}} {{< /tab >}} {{< tab "print_area_and_page_breaks.pdf" >}} ```text Binary file (PDF, 59 KB) ``` [Download full output](https://docs.groupdocs.com/viewer/python-net/_output_files/rendering-basics/render-spreadsheets/split-worksheet-into-pages/render_print_area_and_page_breaks/print_area_and_page_breaks.pdf) {{< /tab >}} {{< /tabs >}}