Excel.Interfaces.WorkbookRangeAreasLoadOptions interface

Represents a collection of one or more rectangular ranges in multiple worksheets.

Remarks

[ API set: ExcelApi 1.12 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

addresses

Returns an array of addresses in A1-style. Address values contain the worksheet name for each rectangular block of cells (e.g., "Sheet1!A1:B4, Sheet1!D1:D4"). Read-only.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

addresses

Returns an array of addresses in A1-style. Address values contain the worksheet name for each rectangular block of cells (e.g., "Sheet1!A1:B4, Sheet1!D1:D4"). Read-only.

addresses?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]