using IronXL;
WorkBook workbook = WorkBook.Load("test.xlsx");
WorkSheet worksheet = workbook.DefaultWorkSheet;
// SetRepeatingRows is how we can set repeating rows for the print title of the worksheet.
// The Int parameters are the start and end zero-based row numbers.
// To remove repeating rows you can use worksheet.RemoveRepeatingRows();
worksheet.SetRepeatingRows(1, 2);
// SetRepeatingColumns is how we can set repeating columns.
// The Int parameters are the start and end zero-based colum numbers (0 is "A");
// To remove repeating columns you can use worksheet.RemoveRepeatingColumns();
worksheet.SetRepeatingColumns(2,3);
workbook.SaveAs("RepeatingRows.xlsx");
Imports IronXL
Private workbook As WorkBook = WorkBook.Load("test.xlsx")
Private worksheet As WorkSheet = workbook.DefaultWorkSheet
' SetRepeatingRows is how we can set repeating rows for the print title of the worksheet.
' The Int parameters are the start and end zero-based row numbers.
' To remove repeating rows you can use worksheet.RemoveRepeatingRows();
worksheet.SetRepeatingRows(1, 2)
' SetRepeatingColumns is how we can set repeating columns.
' The Int parameters are the start and end zero-based colum numbers (0 is "A");
' To remove repeating columns you can use worksheet.RemoveRepeatingColumns();
worksheet.SetRepeatingColumns(2,3)
workbook.SaveAs("RepeatingRows.xlsx")