Skip to content

Latest commit

 

History

History
36 lines (27 loc) · 1.14 KB

Pages-Tab.md

File metadata and controls

36 lines (27 loc) · 1.14 KB

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