How a sheet is laid out on printed pages: paper, orientation, scale, margins, what is printed
besides the cells, the headers and footers, the print area and the rows and columns repeated on
every page.
Remarks
Shaped after Office Scripts' PageLayout, reached the same way (IWorksheet.getPageLayout).
The manual page breaks are here too, with the rest of what decides the pages. Office Scripts has
them on the worksheet, and so does IWorksheet: IWorksheet.getHorizontalPageBreaks and the
others are the same breaks.
Setters return the layout rather than void, so calls can be chained.
SheetXL does not print; these settings are kept with the sheet and written to the file.
How a sheet is laid out on printed pages: paper, orientation, scale, margins, what is printed besides the cells, the headers and footers, the print area and the rows and columns repeated on every page.
Remarks
Shaped after Office Scripts'
PageLayout, reached the same way (IWorksheet.getPageLayout). The manual page breaks are here too, with the rest of what decides the pages. Office Scripts has them on the worksheet, and so does IWorksheet: IWorksheet.getHorizontalPageBreaks and the others are the same breaks.Setters return the layout rather than
void, so calls can be chained.SheetXL does not print; these settings are kept with the sheet and written to the file.
See
Interface
IPageLayout