Skip to main content

IXlSheet.RowPageBreaks Property

Provides access to the collection of row page breaks in a worksheet.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

IXlPageBreaks RowPageBreaks { get; }

Property Value

Type Description
IXlPageBreaks

An object exposing the IXlPageBreaks interface.

Remarks

Use the RowPageBreaks property to get access to a collection of horizontal (row) page breaks in a worksheet. To insert a page break after the specified row, use the IXlPageBreaks.Add method. To remove the required page break from the collection, use the IXlPageBreaks.Remove or IXlPageBreaks.RemoveAt method. To clear all row page breaks, use the IXlPageBreaks.Clear method.

For more information on how to add page breaks to a worksheet, refer to the How to: Insert Page Breaks in a Worksheet document.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

// Insert a page break after the column "B".
sheet.ColumnPageBreaks.Add(2);
// Insert a page break after the tenth row.
sheet.RowPageBreaks.Add(10);
See Also