/
excelscript.printorder.yml
39 lines (35 loc) · 1.23 KB
/
excelscript.printorder.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
### YamlMime:TSEnum
name: ExcelScript.PrintOrder
uid: 'ExcelScript!ExcelScript.PrintOrder:enum'
package: ExcelScript!
fullName: ExcelScript.PrintOrder
summary: ''
remarks: |-
#### Examples
```TypeScript
/**
* 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);
});
}
```
isPreview: false
isDeprecated: false
fields:
- name: downThenOver
uid: 'ExcelScript!ExcelScript.PrintOrder.downThenOver:member'
package: ExcelScript!
summary: Process down the rows before processing across pages or page fields to the right.
- name: overThenDown
uid: 'ExcelScript!ExcelScript.PrintOrder.overThenDown:member'
package: ExcelScript!
summary: Process across pages or page fields to the right before moving down the rows.