IWorksheet Interface Properties

Spread.Services Documentation
IWorksheet Interface Properties
Collapse All Expand All Members Options: Show All Members Options: Filtered
Include Inherited Members

GrapeCity.Documents.Spread Namespace : IWorksheet Interface

For a list of all members of this type, see IWorksheet members.

Public Properties

| Name | Description
--- | --- | ---
| ActiveCell | Gets the active cell.
| AutoFilter | Returns an IAutoFilter object if filtering is on. Returns nothing if filtering is off (read-only).
| AutoFilterMode | Gets or sets whether the AutoFilter drop-down arrows are currently displayed on the sheet. This property is independent of the AutoFilterMode property (read or write).
| Cells | Returns the IRange object that represents all the cells on the worksheet (not just the cells that are currently in use). This object is read-only.
| Columns | Returns the IRange object that represents all the columns on the specified worksheet (read-only).
| Comments | Returns the IComments collection that represents all the comments for the specified worksheet (read-only).
| FilterMode | Gets whether the worksheet is in filter mode (read-only).
| FreezeColumn | Gets the frozen column.
| FreezeRow | Gets the frozen row.
| Hyperlinks | Provides access to the collection of Hyperlinks contained in the worksheet.
| Index | Gets or sets the index number of the object within the collection of similar objects (read-only).
| Name | Gets or sets the name of the object (read or write).
| Names | Returns the INames collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). This is a read-only Names object.
| Outline | Returns an IOutline object that represents the outline for the specified worksheet (read-only).
| PivotTables | Returns an object that represents either a single PivotTable report (a IPivotTables object) or a collection of all the PivotTable reports (IPivotTables object) on a worksheet (read-only).
| Protection | Gets or sets the protection status of the worksheet.
| ProtectionSettings | Returns the IProtectionSettings object that represents the protection options of the worksheet.
| Range | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.
| Rows | Returns the IRange object that represents all the rows on the specified worksheet. This is read-only Range object.
| Selection | Gets the selection range.
| Shapes | Returns a Shapes object that represents all the shapes on the worksheet or chart sheet (read-only).
| SheetView | Represents the worksheet view option.
| Sort | Returns the sorted values in the current worksheet (read-only).
| StandardHeight | Gets or sets the standard (default) height of all the rows in the worksheet in points (read-only).
| StandardWidth | Gets or sets the standard (default) width of all the columns in the worksheet (read or write).
| TabColor | Gets or sets the primary color of the tab.
| Tables | Returns a collection of ITable objects in the worksheet. This is a read-only ListObjects collection.
| UsedRange | Returns the IRange object that represents the used range on the specified worksheet (read-only).
| Visible | Determines whether the object is visible (read or write Visibility).
| Workbook | Returns the workbook

Top
See Also

#### Reference

IWorksheet Interface
GrapeCity.Documents.Spread Namespace

Copyright © GrapeCity, inc. All rights reserved.

Send Feedback