Edit

Share via

Excel.Interfaces.WorkbookRangeAreasData interface

  • Reference
Package:
excel

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

Properties

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

Returns the RangeAreasCollection object. Each RangeAreas in the collection represent one or more rectangle ranges in one worksheet.
ranges

Returns ranges that comprise this object in a RangeCollection object.

Property Details

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?: string[];

Property Value

string[]

Remarks

[ API set: ExcelApi 1.12 ]

areas

Returns the RangeAreasCollection object. Each RangeAreas in the collection represent one or more rectangle ranges in one worksheet.

areas?: Excel.Interfaces.RangeAreasData[];

Property Value

Excel.Interfaces.RangeAreasData[]

Remarks

[ API set: ExcelApi 1.12 ]

ranges

Returns ranges that comprise this object in a RangeCollection object.

ranges?: Excel.Interfaces.RangeData[];

Property Value

Excel.Interfaces.RangeData[]

Remarks

[ API set: ExcelApi 1.12 ]