Split a worksheet into pages Leave feedback
On this page
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.
To render a worksheet based on the inserted page breaks, call the SpreadsheetOptions.forRenderingByPageBreaks static method and pass the returned SpreadsheetOptions instance to the ViewOptions.setSpreadsheetOptions method 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:
import com.groupdocs.viewer.Viewer;
import com.groupdocs.viewer.options.PdfViewOptions;
// ...
try (Viewer viewer = new Viewer("products.xlsx")) {
// Convert the spreadsheet to PDF.
PdfViewOptions viewOptions = new PdfViewOptions("output.pdf");
// Split using page breaks.
viewOptions.setSpreadsheetOptions(SpreadsheetOptions.forRenderingByPageBreaks());
viewer.view(viewOptions);
}
The image below illustrates the result.
The following code snippet splits a worksheet into two pages and renders them to PDF:
import com.groupdocs.viewer.Viewer;
import com.groupdocs.viewer.options.PdfViewOptions;
// ...
try (Viewer viewer = new Viewer("two-pages.xlsx")) {
// Specify number of rows for every page.
int countRowsPerPage = 15;
// Convert the spreadsheet to PDF.
PdfViewOptions viewOptions = PdfViewOptions("output.pdf");
// Split by number of rows.
viewOptions.setSpreadsheetOptions(SpreadsheetOptions.forSplitSheetIntoPages(countRowsPerPage));
viewer.view(viewOptions);
}
The image below demonstrates the output PDF file.
The following code snippet splits a worksheet into four pages and renders them to PDF:
import com.groupdocs.viewer.Viewer;
import com.groupdocs.viewer.options.PdfViewOptions;
// ...
try (Viewer viewer = new Viewer("four-pages.xlsx")) {
// Specify number of rows and columns for every page.
int countRowsPerPage = 15;
int countColumnsPerPage = 7;
// Convert the spreadsheet to PDF.
PdfViewOptions viewOptions = PdfViewOptions("output.pdf");
// Split by number of rows and columns.
viewOptions.setSpreadsheetOptions(SpreadsheetOptions.forSplitSheetIntoPages(countRowsPerPage, countColumnsPerPage));
viewer.view(viewOptions);
}
The image below demonstrates the output PDF file.
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.
GroupDocs.Viewer also supports this option. Call the SpreadsheetOptions.forRenderingPrintArea static method and assign the pass SpreadsheetOptions instance to the ViewOptions.setSpreadsheetOptions method 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:
import com.groupdocs.viewer.Viewer;
import com.groupdocs.viewer.options.PdfViewOptions;
// ...
try (Viewer viewer = new Viewer("invoice.xlsx")) {
// Convert the spreadsheet to PDF.
PdfViewOptions viewOptions = PdfViewOptions("output.pdf");
// Render the print area only.
viewOptions.setSpreadsheetOptions(SpreadsheetOptions.forRenderingPrintArea());
viewer.view(viewOptions);
}
The image below illustrates the result.
If you want to display all worksheet data on one page, call the SpreadsheetOptions.forOnePagePerSheet static method and pass the returned SpreadsheetOptions instance to the ViewOptions.setSpreadsheetOptions method for a target view.
The following example converts each worksheet to one page in the PDF file:
import com.groupdocs.viewer.Viewer;
import com.groupdocs.viewer.options.PdfViewOptions;
// ...
try (Viewer viewer = new Viewer("Products.xlsx")) {
// Convert the spreadsheet to PDF.
PdfViewOptions viewOptions = PdfViewOptions("output.pdf");
// Render each worksheet to one page.
viewOptions.setSpreadsheetOptions(SpreadsheetOptions.forOnePagePerSheet());
viewer.view(viewOptions);
}
The image below illustrates the result. The output PDF file contains one page that displays all worksheet data.
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.
