HorizontalPageBreak Class

GemBox.Spreadsheet Help

Specifies a horizontal position where the new page begins when the worksheet is printed.

Inheritance Hierarchy

System Object
GemBox.Spreadsheet PageBreak
GemBox.Spreadsheet HorizontalPageBreak

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

Syntax

public sealed class HorizontalPageBreak : PageBreak

public sealed class HorizontalPageBreak : PageBreak

Public NotInheritable Class HorizontalPageBreak _
	Inherits PageBreak

Public NotInheritable Class HorizontalPageBreak _
	Inherits PageBreak

Examples

Following code demonstrates how to add PageBreaks to ExcelWorksheet.

Copy to Clipboard Print

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

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