ExcelScript.PrintOrder enum

Remarks

Used by

• ExcelScript.PageLayout: getPrintOrder, setPrintOrder

Examples

/**
 * This script sets the print order for every worksheet in the workbook.
 * The order of printed content will go over (e.g., left-to-right) 
 * then down (i.e., top-to-bottom).
 */
function main(workbook: ExcelScript.Workbook) {
 // Access every worksheet in the workbook.
 workbook.getWorksheets().forEach(worksheet => {
 // Get the page layout for each sheet.
 const layout: ExcelScript.PageLayout = worksheet.getPageLayout();

 // Set the print order to over-then-down.
 layout.setPrintOrder(ExcelScript.PrintOrder.overThenDown);
 });
}

Fields