Repeat Excel Rows & Columns

VB C#

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set repeating rows for row(2-4)
workSheet.SetRepeatingRows(1, 3);

// Set repeating columns for column(C-D)
workSheet.SetRepeatingColumns(2, 3);

// Set column break after column(H). Hence, the first page will only contain column(A-G)
workSheet.SetColumnBreak(7);

workBook.SaveAs("repeatingRows.xlsx");

Imports IronXL

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Set repeating rows for row(2-4)
workSheet.SetRepeatingRows(1, 3)

' Set repeating columns for column(C-D)
workSheet.SetRepeatingColumns(2, 3)

' Set column break after column(H). Hence, the first page will only contain column(A-G)
workSheet.SetColumnBreak(7)

workBook.SaveAs("repeatingRows.xlsx")

Install-Package IronXL.Excel

Repeat Excel Rows & Columns

When Excel spreadsheets span several pages, the data is easier and quicker to read when we print the column or row titles at the right or top of every page(repeating). These are called Repeating Rows and Columns or Header Rows and Columns in Excel. IronXL can utilize this useful aspect of spreadsheet with just a few lines of code.

`SetRepeatingRows(startRow, endRow)`

This method is used to set repeating rows. For example, workSheet.SetRepeatingRows(3, 4) will set repeating on row(4-5).

`SetRepeatingColumns(startColumn, endColumn)`

This method is used to set repeating columns. For example, workSheet.SetRepeatingColumns(0, 2) will set repeating on column(A-C).

These two methods use zero-based indexing as parameters, such that column(0) is "A" and row(1) is 2. Please also note that if these methods are used in combination like the code example above.

The content that span multiple pages along the right side of the first page will have repeating column rule applied only. Figure 1 shows the phenomenon: