Show / Hide Table of Contents

Set print titles

Repeat the first row and first column on every page.

Output: PrintTitles.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];

    worksheet.PageSetup.Sheet.PrintTitlesRowsToRepeat = "$1:$1";
    worksheet.PageSetup.Sheet.PrintTitlesColumnsToRepeat = "$A:$A";

    workbook.SaveAs("PrintTitles.xlsx");
}
Back to top Generated by DocFX