EasyXLS

Page breaks

Concept

EasyXLS™ library allows you to insert page breaks on rows or columns for a sheet of an Excel file. The page breaks separate the pages when the document is printed.

Concept in action

The below example shows how to export an Excel file with page breaks placed on different rows of the sheet.

Source code sample

C#.NET
VB.NET
C++.NET
J#.NET
Java
PHP
ASP
C++
VB6
VBS
Coldfusion

The screen shot provides an example of an Excel report that has a visible page break at row 21. The page break preview layout is selected.

Excelpage break per rows, Excel page break per columns

Page breaks on rows

EasyXLS allows setting the page breaks on rows using ExcelTable.easy_insertPageBreakAtRow method.

Page breaks on columns

EasyXLS allows setting the page breaks per columns using ExcelTable.easy_insertPageBreakAtColumn method.

Page break preview

In order to visualize the printable area and the pagination, the view must be set on "Page Break Preview" mode using ExcelWorksheet.setPageBreakPreview method.


Available for: Professional, Excel Writer, Excel Reader
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Writer
.NET version to create and export Excel files
.NET Excel Reader
.NET version to read and import Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Writer
Java version to create and export Excel files
Java Excel Reader
Java version to read and import Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT