for_split_sheet_into_pages method Leave feedback
On this page
Initializes a SpreadsheetOptions instance for rendering a sheet into pages.
For details, see the documentation at https://docs.groupdocs.com/viewer/net/split-worksheet-into-pages/#split-a-worksheet-into-pages-by-rows.
def for_split_sheet_into_pages(cls, count_rows_per_page):
...
| Parameter | Type | Description |
|---|---|---|
| count_rows_per_page | int |
Count of rows to include into each page. |
Returns: SpreadsheetOptions: New instance of the SpreadsheetOptions class for rendering sheet into pages.
| Raises | Description |
|---|---|
ValueError |
When count_rows_per_page is equal to or less than zero. |
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:
rows_per_page = 15
view_options = PdfViewOptions("split_by_rows/by_rows.pdf")
view_options.spreadsheet_options = SpreadsheetOptions.for_split_sheet_into_pages(rows_per_page)
viewer.view(view_options)
if __name__ == "__main__":
split_by_rows()
Initializes a SpreadsheetOptions instance for rendering a sheet into pages.
For details, see the documentation at https://docs.groupdocs.com/viewer/net/split-worksheet-into-pages/#split-a-worksheet-into-pages-by-rows-and-columns.
def for_split_sheet_into_pages(cls, count_rows_per_page, count_columns_per_page):
...
| Parameter | Type | Description |
|---|---|---|
| count_rows_per_page | int |
Count of rows to include into each page. |
| count_columns_per_page | int |
Count of columns to include into each page. |
Returns: SpreadsheetOptions: New instance of the SpreadsheetOptions class for rendering a sheet into pages.
| Raises | Description |
|---|---|
ValueError |
When count_columns_per_page is equal to or less than zero. |
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:
rows_per_page = 15
columns_per_page = 7
# Convert the spreadsheet to PDF.
view_options = PdfViewOptions("split_by_rows_and_columns/by_rows_and_columns.pdf")
# Split by number of rows and columns.
view_options.spreadsheet_options = SpreadsheetOptions.for_split_sheet_into_pages(
rows_per_page, columns_per_page
)
viewer.view(view_options)
if __name__ == "__main__":
split_by_rows_and_columns()
- class
SpreadsheetOptions
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
