| Name | Description | |
|---|---|---|
 | MinCellSize | Minimum size of cell width/height. |
Worksheet Class Members
In This Topic
The following tables list the members exposed by Worksheet.
Public Fields
Public Properties
| Name | Description | |
|---|---|---|
 | CellComments | Gets a comment collection. |
| DefaultRowAutoHeight | Gets or sets the auto height for default row. |
| Document | Gets the dspreadsheet document that contains this worksheet. |
| Drawings | Gets a drawing collection. |
| Format | Gets the format of worksheet. |
| Hyperlinks | Gets a collection of sheet hyperlinks. |
| MergedCells | Gets the merged cells. |
| Name | Gets the name of worksheet. |
| View | Gets the view properties of worksheet. |
Public Methods
| Name | Description | |
|---|---|---|
 | ContainsCellsHyperlinks | Determines whether this worksheet contains hyperlinks in specified cells set. |
| CreateCopy | Creates a worksheet that contains a copy of specified cells on this worksheet. |
| FindCell | Overloaded. Searches a cell at specified reference. |
| FindColumn | Returns column by column index. |
| FindRow | Returns row by row index. |
| GetAdjacentVisibleColumn | Returns the index of adjacent visible column. |
| GetAdjacentVisibleRow | Returns the index of adjacent visible row. |
| GetCellBorders | Returns the cell borders. |
| GetCellComment | Returns the comment that is associated with specified cell. |
| GetCellComments | Return the comments, which are associated with specified cells. |
| GetCellFillColor | Overloaded. Returns the fill color of cell. |
| GetCellFontProperties | Returns the font properties of cell. |
| GetCellHyperlink | Returns the cell hyperlink that is associated with cell. |
| GetCellHyperlinkIndex | Returns the index of cell hyperlink that is associated with cell. |
| GetCellLocation | Returns location, in worksheet space, of specified cell. |
| GetCellRect | Returns a rectangle, in worksheet space, that represents the specified cell. |
| GetCellReference | Returns the cell reference by location at this worksheet. |
| GetCellReferencesWithContent | Returns the cell references that contains content in specified cell references. |
| GetCellsHyperlinks | Returns the cell hyperlinks, which are intersected with specified cell set. |
| GetCellSize | Returns size, in worksheet space, of specified cell. |
| GetCellsRect | Returns a rectangle, in worksheet space, that represents the specified cells. |
| GetCellsRectSize | Returns the size of specified cells in worksheet table. |
| GetCellsStyleIndexes | Returns the styles indexes that uses in specified cell references. |
| GetCellStyle | Overloaded. Returns the cell style. |
| GetCellStyleIndex | Overloaded. Returns the style index of cell. |
| GetCellTextAndFontProperties | Returns the text and font properties of cell. |
| GetCellTextProperties | Returns the text properties of cell. |
| GetColumnActualWidth | Returns the actual width of specified column. |
| GetColumnIndex | Returns the column index by location at X axis. |
| GetColumnIsHidden | Returns a value indicating whether column is hidden. |
| GetColumnIsVisible | Returns a value indicating whether column is visible (is not hidden and width is greater than 0). |
| GetColumns | Returns a list of sheet columns. |
| GetColumnStyleIndex | Returns the style index of specified column. |
| GetColumnsWidth | Returns the sum of cell widths. |
| GetColumnWidth | Returns the width of specified column. |
| GetHyperlink | Returns the cell hyperlink or runtime hyperlink that is associated with cell. |
| GetIsSingleCell | Returns a value indicating whether the cell references are represented by single cell or merged cell. |
| GetMergedCell | Returns the merged cells, which have top-left cell equal to the topLeftCell. |
| GetMergedCells | Overloaded. Returns the merged cells, which contain specified cell. |
| GetNextVisibleColumn | Returns the index of next visible column. |
| GetNextVisibleRow | Returns the index of next visible row. |
| GetPrevVisibleColumn | Returns the index of previous visible column. |
| GetPrevVisibleRow | Returns the index of previous visible row. |
| GetRowActualHeight | Returns actual height of specified row. |
| GetRowAutoHeight | Returns the AutoHeight flag for specified row. |
| GetRowDefaultHeight | Returns the default height of the row. |
| GetRowHeight | Returns height of specified row. |
| GetRowIndex | Returns the row index by location at Y axis. |
| GetRowIsHidden | Returns a value indicating whether row is hidden. |
| GetRowIsVisible | Returns a value indicating whether row is visible (is not hidden and height is greater than 0). |
| GetRows | Returns a list of sheet rows. |
| GetRowsHeight | Returns the sum of cell heights. |
| GetRowStyleIndex | Returns the style index of row. |
| GetSize | Returns size of this worksheet. |
| GetVisibleCellOnLeft | Returns the visible cell on the left from specified cell. |
| GetVisibleCellOnRight | Returns the visible cell on the right from specified cell. |
| HasContent | Determines whether worksheet has content in specified cells. |
| SelectCells | Overloaded. Selects the cells. |
See Also