HorizontalPageBreakCollection Class

Collection of horizontal page breaks (HorizontalPageBreak).

Inheritance Hierarchy

SystemObject
  GemBox.SpreadsheetPageBreakCollection
    GemBox.SpreadsheetPageBreakCollectionHorizontalPageBreak
      GemBox.SpreadsheetHorizontalPageBreakCollection

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

Syntax

Copy

public sealed class HorizontalPageBreakCollection : PageBreakCollection<HorizontalPageBreak>

Public NotInheritable Class HorizontalPageBreakCollection
	Inherits PageBreakCollection(Of HorizontalPageBreak)

The HorizontalPageBreakCollection type exposes the following members.

Properties

	Name	Description
	Count	Gets the number of page breaks contained in the collection. (Inherited from PageBreakCollection.)
	Item	Gets or sets the horizontal page break at the specified index.

Top

Methods

	Name	Description
	Add(Int32)	Ads a new horizontal page break above the specified row.
	Add(Int32, Int32, Int32)	Ads a new horizontal page break above the specified row and within specified columns.
	Clear	Removes all page breaks. (Inherited from PageBreakCollection.)
	GetEnumerator	Returns an enumerator for the collection. (Inherited from PageBreakCollectionT.)
	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