varworkbook=newXLWorkbook();varws=workbook.Worksheets.Add("Sheet Tab");// Adding print areasws.PageSetup.PrintAreas.Add("A1:B2");ws.PageSetup.PrintAreas.Add("D3:D5");// Adding rows to repeat at topws.PageSetup.SetRowsToRepeatAtTop(1,2);// Adding columns to repeat at leftws.PageSetup.SetColumnsToRepeatAtLeft(1,2);// Show gridlinesws.PageSetup.ShowGridlines=true;// Print in black and whitews.PageSetup.BlackAndWhite=true;// Print in draft qualityws.PageSetup.DraftQuality=true;// Show row and column headingsws.PageSetup.ShowRowAndColumnHeadings=true;// Set the page print order to over, then downws.PageSetup.PageOrder=XLPageOrderValues.OverThenDown;// Place comments at the end of the sheetws.PageSetup.ShowComments=XLShowCommentsValues.AtEnd;// Print errors as #N/Aws.PageSetup.PrintErrorValue=XLPrintErrorValues.NA;workbook.SaveAs("SheetTab.xlsx");