Excel.Interfaces.WorksheetLoadOptions interface
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
Properties
| $all | Specifying |
| 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. |
| standard |
Returns the standard (default) height of all the rows in the worksheet, in points. |
| standard |
Specifies the standard (default) width of all the columns in the worksheet. One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used. |
| tab |
The tab color of the worksheet. When retrieving the tab color, if the worksheet is invisible, the value will be |
| 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
Remarks
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
name
The display name of the worksheet.
name?: boolean;Property Value
boolean
Remarks
position
The zero-based position of the worksheet within the workbook.
position?: boolean;Property Value
boolean
Remarks
protection
Returns the sheet protection object for a worksheet.
protection?: Excel.Interfaces.WorksheetProtectionLoadOptions;Property Value
Remarks
standardHeight
Returns the standard (default) height of all the rows in the worksheet, in points.
standardHeight?: boolean;Property Value
boolean
Remarks
standardWidth
Specifies the standard (default) width of all the columns in the worksheet. One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used.
standardWidth?: boolean;Property Value
boolean
Remarks
tabColor
The tab color of the worksheet. When retrieving the tab color, if the worksheet is invisible, the value will be null. If the worksheet is visible but the tab color is set to auto, an empty string will be returned. Otherwise, the property will be set to a color, in the form #RRGGBB (e.g., "FFA500"). When setting the color, use an empty-string to set an "auto" color, or a real color otherwise.
tabColor?: boolean;Property Value
boolean
Remarks
tables
Collection of tables that are part of the worksheet.
tables?: Excel.Interfaces.TableCollectionLoadOptions;Property Value
Remarks
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. ]
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for