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

Page Tab Example 1

PageTab1.jpg

            var workbook = new XLWorkbook();
            var ws1 = workbook.Worksheets.Add("Page Setup - Page1");
            ws1.PageSetup.PageOrientation = XLPageOrientation.Landscape;
            ws1.PageSetup.AdjustTo(80);
            ws1.PageSetup.PaperSize = XLPaperSize.LegalPaper;
            ws1.PageSetup.VerticalDpi = 600;
            ws1.PageSetup.HorizontalDpi = 600;

For more information on the paper size enumeration please see the Paper Size Lookup Table

Page Tab Example 2

PageTab2.jpg

            var ws2 = workbook.Worksheets.Add("Page Setup - Page2");
            ws2.PageSetup.PageOrientation = XLPageOrientation.Portrait;
            ws2.PageSetup.FitToPages(2, 2); // Alternatively you can use 
                                            // ws2.PageSetup.PagesTall = #
                                            // and/or ws2.PageSetup.PagesWide = #

            ws2.PageSetup.PaperSize = XLPaperSize.LetterPaper;
            ws2.PageSetup.VerticalDpi = 600;
            ws2.PageSetup.HorizontalDpi = 600;
            ws2.PageSetup.FirstPageNumber = 5;

            workbook.SaveAs("PageTab.xlsx");

For more information on the paper size enumeration please see the Paper Size Lookup Table

Last edited Sep 24, 2010 at 9:54 PM by MDeLeon, version 4