Customize PDF Page Content and Pagination

DsExcel enables users to manage pagination while exporting to a PDF file.

The pagination settings are used to control how the data lying in the worksheets breaks across the pages in the PDF file. The PrintManager class contains the methods that help users in handling custom pagination requirements and preferences.

The custom pagination process works in four basic steps as described below.

• Step 1 - Create an instance of the PrintManager class.

• Step 2 - Get the default pagination information of the workbook using the paginate() method.

• Step 3 - Adjust pagination using different methods of the PrintManager class.

• Step 4 - Save the PDF file by using either the savePageInfosToPDF() method or the saveWorkbooksToPDF() method.

DsExcel provides flexible pagination options for controlling how worksheet content is exported to PDF, including page breaks, page settings, headers, footers, selected ranges, and multi-sheet output.

For more information, refer to the following topics:

• Get Worksheet Pagination

• Render Excel Range Inside PDF

• Export Multiple Sheets To One Page

• Export Multiple Workbooks to Single PDF

• Keep Rows Together Over Page Breaks

• Export Selected Pages and Remove Blank Pages

• Customize Page Content, Headers, and Footers