Excel.Interfaces.WorkbookData interface
An interface describing the data returned by calling workbook.toJSON().
Properties
| bindings | Represents a collection of bindings that are part of the workbook. |
| custom |
Represents the collection of custom XML parts contained by this workbook. |
| name | Gets the workbook name. |
| names | Represents a collection of workbook-scoped named items (named ranges and constants). |
| pivot |
Represents a collection of PivotTables associated with the workbook. |
| properties | Gets the workbook properties. |
| protection | Returns the protection object for a workbook. |
| read |
Returns |
| settings | Represents a collection of settings associated with the workbook. |
| styles | Represents a collection of styles associated with the workbook. |
| tables | Represents a collection of tables associated with the workbook. |
| worksheets | Represents a collection of worksheets associated with the workbook. |
Property Details
bindings
Represents a collection of bindings that are part of the workbook.
bindings?: Excel.Interfaces.BindingData[];Property Value
Remarks
customXmlParts
Represents the collection of custom XML parts contained by this workbook.
customXmlParts?: Excel.Interfaces.CustomXmlPartData[];Property Value
Remarks
name
names
Represents a collection of workbook-scoped named items (named ranges and constants).
names?: Excel.Interfaces.NamedItemData[];Property Value
Remarks
pivotTables
Represents a collection of PivotTables associated with the workbook.
pivotTables?: Excel.Interfaces.PivotTableData[];Property Value
Remarks
properties
Gets the workbook properties.
properties?: Excel.Interfaces.DocumentPropertiesData;Property Value
Remarks
protection
Returns the protection object for a workbook.
protection?: Excel.Interfaces.WorkbookProtectionData;Property Value
Remarks
readOnly
Returns true if the workbook is open in read-only mode.
readOnly?: boolean;Property Value
boolean
Remarks
settings
Represents a collection of settings associated with the workbook.
settings?: Excel.Interfaces.SettingData[];Property Value
Remarks
styles
Represents a collection of styles associated with the workbook.
styles?: Excel.Interfaces.StyleData[];Property Value
Remarks
tables
Represents a collection of tables associated with the workbook.
tables?: Excel.Interfaces.TableData[];Property Value
Remarks
worksheets
Represents a collection of worksheets associated with the workbook.
worksheets?: Excel.Interfaces.WorksheetData[];