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