Generic base class for page break collections.
System Object GemBox.Spreadsheet PageBreakCollection GemBox.Spreadsheet PageBreakCollection T GemBox.Spreadsheet HorizontalPageBreakCollection GemBox.Spreadsheet VerticalPageBreakCollectionNamespace: GemBox.SpreadsheetAssembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 37.3.30.1035
public abstract class PageBreakCollection<T> : PageBreakCollection,
IEnumerable<T>, IEnumerable
where T : PageBreak
Public MustInherit Class PageBreakCollection(Of T As PageBreak) _
Inherits PageBreakCollection _
Implements IEnumerable(Of T), IEnumerable
- T
- Type of the items in the collection, either HorizontalPageBreak or VerticalPageBreak.
Following code demonstrates how to add PageBreaks to ExcelWorksheet.
int columnsPerPage = 6, rowsPerPage = 30;
int usedColumnsCount = ws.CalculateMaxUsedColumns();
for (int i = columnsPerPage; i < usedColumnsCount; i += columnsPerPage)
ws.VerticalPageBreaks.Add(i);
for (int i = rowsPerPage; i < ws.Rows.Count; i += rowsPerPage)
ws.HorizontalPageBreaks.Add(i);int columnsPerPage = 6, rowsPerPage = 30;
int usedColumnsCount = ws.CalculateMaxUsedColumns();
for (int i = columnsPerPage; i < usedColumnsCount; i += columnsPerPage)
ws.VerticalPageBreaks.Add(i);
for (int i = rowsPerPage; i < ws.Rows.Count; i += rowsPerPage)
ws.HorizontalPageBreaks.Add(i);Dim columnsPerPage = 6, rowsPerPage = 30
Dim usedColumnsCount = ws.CalculateMaxUsedColumns()
For i As Integer = columnsPerPage To usedColumnsCount - 1 Step columnsPerPage
ws.VerticalPageBreaks.Add(i)
Next
For i As Integer = rowsPerPage To ws.Rows.Count - 1 Step rowsPerPage
ws.HorizontalPageBreaks.Add(i)
NextDim columnsPerPage = 6, rowsPerPage = 30
Dim usedColumnsCount = ws.CalculateMaxUsedColumns()
For i As Integer = columnsPerPage To usedColumnsCount - 1 Step columnsPerPage
ws.VerticalPageBreaks.Add(i)
Next
For i As Integer = rowsPerPage To ws.Rows.Count - 1 Step rowsPerPage
ws.HorizontalPageBreaks.Add(i)
Next