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.

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

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

Remarks

[ API set: ExcelApi 1.1 ]

pivotTables

Represents a collection of PivotTables associated with the workbook.

pivotTables?: Excel.Interfaces.PivotTableData[];

Property Value

Remarks

[ API set: ExcelApi 1.3 ]

settings

Represents a collection of settings associated with the workbook.

settings?: Excel.Interfaces.SettingData[];

Property Value

Remarks

[ API set: ExcelApi 1.4 ]

tables

Represents a collection of tables associated with the workbook.

tables?: Excel.Interfaces.TableData[];

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

worksheets

Represents a collection of worksheets associated with the workbook.

worksheets?: Excel.Interfaces.WorksheetData[];

Property Value

Remarks

[ API set: ExcelApi 1.1 ]