ExcelWorksheet Properties |
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