Excel |
The ExcelWorksheet type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | Charts | Gets the charts collection of this worksheet. |
| Comments | Gets the comments collection of this worksheet. |
| HorizontalPageBreaks | Gets the collection of horizontal page breaks of this worksheet. |
| Hyperlinks | Gets the collection of hyperlinks of this worksheet |
| ItemString | Gets range referenced by the range name or range reference string in A1 notation. |
| ItemInt32, Int32 | Gets the specified cell in the worksheet. |
| ItemInt32, Int32, Int32, Int32 | Gets cells range specified the higher left and lower right coordinates. |
| Name | Gets or sets the worksheet name. |
| NamedRanges | Gets the named ranges collection of this worksheet (Worksheet scope named ranges). |
| PageSetup | Gets the worksheet page setup options (paper size, page orientation, etc.). |
| Pictures | Gets the pictures collection of this worksheet. |
| SheetIndex | Gets the index of this worksheet in the workbook sheets collection. |
| ShowGridLines | Gets or sets a flag indicating if the worksheet grid lines are visible or not. Default value is true. |
| UsedRange | Gets the used range on the specified worksheet. |
| UsedRangeCells | Gets the cells in the used range of the worksheet. |
| UsedRangeColumns | Gets an arrat of Range objects representing all the columns in the used range of the worksheet. |
| UsedRangeRows | Gets a an array of Range objects representing all the rows in the used range of the worksheet. |
| VerticalPageBreaks | Gets the collection of vertical page breaks of this worksheet. |
| Workbook | Gets the parent workbook of this worksheet. |
| WorksheetSecurity | Gets an object used to manage the worksheet security options like password protection. |
See Also