Edit

Excel.Interfaces.WorkbookData interface

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

Remarks

Used by

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