IXlSheet.ColumnPageBreaks Property

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

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll

Declaration

IXlPageBreaks ColumnPageBreaks { get; }

Property Value

Type Description
IXlPageBreaks

An object exposing the IXlPageBreaks interface.

Remarks

Use the ColumnPageBreaks property to get access to a collection of vertical (column) page breaks in a worksheet. To insert a page break after the specified column, 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 column 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

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

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ColumnPageBreaks property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also