2017-04-11 22:15:36 +00:00
|
|
|
### Workbook-Level Attributes
|
|
|
|
|
2017-06-01 21:22:11 +00:00
|
|
|
`wb.Workbook` stores workbook-level attributes.
|
2017-04-11 22:15:36 +00:00
|
|
|
|
|
|
|
#### Defined Names
|
|
|
|
|
|
|
|
`wb.Workbook.Names` is an array of defined name objects which have the keys:
|
|
|
|
|
2017-04-30 20:37:53 +00:00
|
|
|
<details>
|
2017-09-24 23:40:09 +00:00
|
|
|
<summary><b>Defined Name Properties</b> (click to show)</summary>
|
2017-04-30 20:37:53 +00:00
|
|
|
|
2017-04-11 22:15:36 +00:00
|
|
|
| Key | Description |
|
|
|
|
|:----------|:-----------------------------------------------------------------|
|
|
|
|
| `Sheet` | Name scope. Sheet Index (0 = first sheet) or `null` (Workbook) |
|
|
|
|
| `Name` | Case-sensitive name. Standard rules apply ** |
|
2017-09-24 23:40:09 +00:00
|
|
|
| `Ref` | A1-style Reference (`"Sheet1!$A$1:$D$20"`) |
|
2017-04-11 22:15:36 +00:00
|
|
|
| `Comment` | Comment (only applicable for XLS/XLSX/XLSB) |
|
2017-06-01 21:22:11 +00:00
|
|
|
|
2017-04-30 20:37:53 +00:00
|
|
|
</details>
|
2017-04-11 22:15:36 +00:00
|
|
|
|
|
|
|
Excel allows two sheet-scoped defined names to share the same name. However, a
|
|
|
|
sheet-scoped name cannot collide with a workbook-scope name. Workbook writers
|
|
|
|
may not enforce this constraint.
|
|
|
|
|
2017-12-30 05:40:35 +00:00
|
|
|
#### Workbook Views
|
|
|
|
|
|
|
|
`wb.Workbook.Views` is an array of workbook view objects which have the keys:
|
|
|
|
|
|
|
|
| Key | Description |
|
|
|
|
|:----------------|:----------------------------------------------------|
|
|
|
|
| `RTL` | If true, display right-to-left |
|
|
|
|
|
2017-06-01 21:22:11 +00:00
|
|
|
#### Miscellaneous Workbook Properties
|
|
|
|
|
|
|
|
`wb.Workbook.WBProps` holds other workbook properties:
|
|
|
|
|
2017-06-03 07:19:09 +00:00
|
|
|
| Key | Description |
|
|
|
|
|:----------------|:----------------------------------------------------|
|
2017-11-20 01:51:14 +00:00
|
|
|
| `CodeName` | [VBA Project Workbook Code Name](#vba-and-macros) |
|
2017-06-03 07:19:09 +00:00
|
|
|
| `date1904` | epoch: 0/false for 1900 system, 1/true for 1904 |
|
|
|
|
| `filterPrivacy` | Warn or strip personally identifying info on save |
|
2017-06-01 21:22:11 +00:00
|
|
|
|