This project has moved and is read-only. For the latest updates, please go here.

Sheet Tab


            var workbook = new XLWorkbook();
            var ws = workbook.Worksheets.Add("Sheet Tab");
            // Adding print areas

            // Adding rows to repeat at top

            // 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;

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