Excel.Interfaces.WorkbookLoadOptions interface

Workbook is the top level object which contains related workbook objects such as worksheets, tables, and ranges. To learn more about the workbook object model, read Work with workbooks using the Excel JavaScript API.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

application

Represents the Excel application instance that contains this workbook.

bindings

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

tables

Represents a collection of tables associated with the workbook.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

application

Represents the Excel application instance that contains this workbook.

application?: Excel.Interfaces.ApplicationLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

bindings

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

bindings?: Excel.Interfaces.BindingCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

tables

Represents a collection of tables associated with the workbook.

tables?: Excel.Interfaces.TableCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]