This project has moved. For the latest updates, please go here.

Sheet Tab

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");

Last edited Sep 24, 2010 at 5:32 AM by MDeLeon, version 4