Excel.Interfaces.WorksheetLoadOptions interface

Package:

excel

An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc. To learn more about the worksheet object model, read Work with worksheets 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).
charts	Returns a collection of charts that are part of the worksheet.
id	Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved.
name	The display name of the worksheet.
position	The zero-based position of the worksheet within the workbook.
protection	Returns the sheet protection object for a worksheet.
tables	Collection of tables that are part of the worksheet.
visibility	The visibility of the worksheet.

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

charts

Returns a collection of charts that are part of the worksheet.

charts?: Excel.Interfaces.ChartCollectionLoadOptions;

Property Value

Excel.Interfaces.ChartCollectionLoadOptions

Remarks

[ API set: ExcelApi 1.1 ]

id

Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

name

The display name of the worksheet.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

position

The zero-based position of the worksheet within the workbook.

position?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

protection

Returns the sheet protection object for a worksheet.

protection?: Excel.Interfaces.WorksheetProtectionLoadOptions;

Property Value

Excel.Interfaces.WorksheetProtectionLoadOptions

Remarks

[ API set: ExcelApi 1.2 ]

tables

Collection of tables that are part of the worksheet.

tables?: Excel.Interfaces.TableCollectionLoadOptions;

Property Value

Excel.Interfaces.TableCollectionLoadOptions

Remarks

[ API set: ExcelApi 1.1 ]

visibility

The visibility of the worksheet.

visibility?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 for reading visibility; 1.2 for setting it. ]