PageBreakCollection(T) Class

PageBreakCollectionT Class

Generic base class for page break collections.

Inheritance Hierarchy

SystemObject
  GemBox.SpreadsheetPageBreakCollection
    GemBox.SpreadsheetPageBreakCollectionT
      GemBox.SpreadsheetHorizontalPageBreakCollection
      GemBox.SpreadsheetVerticalPageBreakCollection

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1070

Syntax

Copy

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

Type Parameters

T: Type of the items in the collection, either HorizontalPageBreak or VerticalPageBreak.

The PageBreakCollectionT type exposes the following members.

Properties

	Name	Description
	Count	Gets the number of page breaks contained in the collection. (Inherited from PageBreakCollection.)

Top

Methods

	Name	Description
	Clear	Removes all page breaks. (Inherited from PageBreakCollection.)
	GetEnumerator	Returns an enumerator for the collection.
	RemoveAt	Removes the page break at the specified index. (Inherited from PageBreakCollection.)

Top

Examples

Following code demonstrates how to add PageBreaks to ExcelWorksheet.

Copy

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)
Next

Reference

GemBox.Spreadsheet Namespace