Show / Hide Table of Contents

Set sheet print settings

Print grid lines. Print headings. Print in black and white. Print cell comments at end. Print errors as blanks.

Output: PageSetupSheetSettings.xlsx

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

    worksheet.PageSetup.Sheet.PrintGridlines = true;
    worksheet.PageSetup.Sheet.PrintHeadings = true;
    worksheet.PageSetup.Sheet.BlackAndWhite = true;
    worksheet.PageSetup.Sheet.CellComments = CellComments.AtEnd;
    worksheet.PageSetup.Sheet.PrintErrors = PrintError.Blank;

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