officefileapi-devexpress-dot-spreadsheet-374fed05.md
A collection of page breaks in a worksheet.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public interface PageBreaksCollection :
ISimpleCollection<int>,
IEnumerable<int>,
IEnumerable,
ICollection
Public Interface PageBreaksCollection
Inherits ISimpleCollection(Of Integer),
IEnumerable(Of Integer),
IEnumerable,
ICollection
The following members return PageBreaksCollection objects:
Page breaks in the worksheet are contained in two PageBreaksCollection collections and can be accessed using the Worksheet.VerticalPageBreaks and Worksheet.HorizontalPageBreaks properties.
The following picture shows three horizontal page breaks with the values 3, 5 and 9 and two vertical page breaks with the values 2 and 5.
To insert page break at the required row or column, use the PageBreaksCollection.Add method. To remove page breaks, use the PageBreaksCollection.Clear method.
See Also