Page breaks

The following example shows you how to insert manual horizontal and vertical page breaks into a worksheet.

C# example

using System;
using Independentsoft.Office.Spreadsheet;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            Worksheet sheet = new Worksheet();
            sheet.Name = "Report";

            for (int r = 1; r <= 30; r++)
            {
                sheet["A" + r] = new Cell("Row " + r);
                sheet["B" + r] = new Cell(r * 10);
            }

            // Insert horizontal page break after row 10
            Break hBreak1 = new Break();
            hBreak1.ID = 10;
            hBreak1.IsManual = true;
            sheet.HorizontalPageBreaks.Add(hBreak1);

            // Insert horizontal page break after row 20
            Break hBreak2 = new Break();
            hBreak2.ID = 20;
            hBreak2.IsManual = true;
            sheet.HorizontalPageBreaks.Add(hBreak2);

            // Insert vertical page break after column B (column index 2)
            Break vBreak = new Break();
            vBreak.ID = 2;
            vBreak.IsManual = true;
            sheet.VerticalPageBreaks.Add(vBreak);

            Workbook book = new Workbook();
            book.Sheets.Add(sheet);
            book.Save("c:\\test\\output.xlsx", true);
        }
    }
}

VB example

Imports System
Imports Independentsoft.Office.Spreadsheet

Module Module1
    Sub Main(ByVal args As String())

        Dim sheet As New Worksheet()
        sheet.Name = "Report"

        For r As Integer = 1 To 30
            sheet("A" & r) = New Cell("Row " & r)
            sheet("B" & r) = New Cell(r * 10)
        Next

        Dim hBreak1 As New Break()
        hBreak1.ID = 10
        hBreak1.IsManual = True
        sheet.HorizontalPageBreaks.Add(hBreak1)

        Dim hBreak2 As New Break()
        hBreak2.ID = 20
        hBreak2.IsManual = True
        sheet.HorizontalPageBreaks.Add(hBreak2)

        Dim vBreak As New Break()
        vBreak.ID = 2
        vBreak.IsManual = True
        sheet.VerticalPageBreaks.Add(vBreak)

        Dim book As New Workbook()
        book.Sheets.Add(sheet)
        book.Save("c:\test\output.xlsx", True)

    End Sub
End Module

IndependentsoftProfessional software libraries for developers

Spreadsheet .NET > Tutorial > Page breaks

Need help? Ask our developers: