Skip to content

Sheet Tab

Francois Botha edited this page Feb 26, 2018 · 2 revisions

SheetTab.jpg

var workbook = new XLWorkbook();
var ws = workbook.Worksheets.Add("Sheet Tab");

// Adding print areas
ws.PageSetup.PrintAreas.Add("A1:B2");
ws.PageSetup.PrintAreas.Add("D3:D5");

// Adding rows to repeat at top
ws.PageSetup.SetRowsToRepeatAtTop(1,2);

// Adding columns to repeat at left
ws.PageSetup.SetColumnsToRepeatAtLeft(1, 2);

// Show gridlines
ws.PageSetup.ShowGridlines = true;

// Print in black and white
ws.PageSetup.BlackAndWhite = true;

// Print in draft quality
ws.PageSetup.DraftQuality = true;

// Show row and column headings
ws.PageSetup.ShowRowAndColumnHeadings = true;

// Set the page print order to over, then down
ws.PageSetup.PageOrder = XLPageOrderValues.OverThenDown;

// Place comments at the end of the sheet
ws.PageSetup.ShowComments = XLShowCommentsValues.AtEnd;

// Print errors as #N/A
ws.PageSetup.PrintErrorValue = XLPrintErrorValues.NA;

workbook.SaveAs("SheetTab.xlsx");

FAQ

Examples

Real world scenarios

Time Savers

Performance and Memory

Misc

Inserting Data/Tables

Styles

Ranges

Rows

Columns

Page Setup (Print Options)

AutoFilters

Comments

Dev docs

Clone this wiki locally