Edit

Share via

Excel.Interfaces.WorkbookData interface

  • Reference
Package:
excel

An interface describing the data returned by calling workbook.toJSON().

Properties

bindings

Represents a collection of bindings that are part of the workbook.
names

Represents a collection of workbook-scoped named items (named ranges and constants).
pivotTables

Represents a collection of PivotTables associated with the workbook.
settings

Represents a collection of settings 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

Excel.Interfaces.BindingData[]

Remarks

[ API set: ExcelApi 1.1 ]

names

Represents a collection of workbook-scoped named items (named ranges and constants).

names?: Excel.Interfaces.NamedItemData[];

Property Value

Excel.Interfaces.NamedItemData[]

Remarks

[ API set: ExcelApi 1.1 ]

pivotTables

Represents a collection of PivotTables associated with the workbook.

pivotTables?: Excel.Interfaces.PivotTableData[];

Property Value

Excel.Interfaces.PivotTableData[]

Remarks

[ API set: ExcelApi 1.3 ]

settings

Represents a collection of settings associated with the workbook.

settings?: Excel.Interfaces.SettingData[];

Property Value

Excel.Interfaces.SettingData[]

Remarks

[ API set: ExcelApi 1.4 ]

tables

Represents a collection of tables associated with the workbook.

tables?: Excel.Interfaces.TableData[];

Property Value

Excel.Interfaces.TableData[]

Remarks

[ API set: ExcelApi 1.1 ]

worksheets

Represents a collection of worksheets associated with the workbook.

worksheets?: Excel.Interfaces.WorksheetData[];

Property Value

Excel.Interfaces.WorksheetData[]

Remarks

[ API set: ExcelApi 1.1 ]