Excel.Interfaces.WorkbookRangeAreasLoadOptions interface

Package:

excel

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

Remarks

[ API set: ExcelApi 1.12 ]

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).
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 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

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 ]