Spread.Services Documentation
IWorksheet Interface Properties

GrapeCity.Documents.Spread Namespace : IWorksheet Interface

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

Public Properties
 NameDescription
 Property Gets the active cell.  
 PropertyReturns an IAutoFilter object if filtering is on. Returns nothing if filtering is off (read-only).  
 PropertyGets 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).  
 PropertyReturns 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.  
 PropertyReturns the IRange object that represents all the columns on the specified worksheet (read-only).  
 PropertyReturns the IComments collection that represents all the comments for the specified worksheet (read-only).  
 Property Gets whether the worksheet is in filter mode (read-only).  
 Property Gets the frozen column.  
 Property Gets the frozen row.  
 Property Provides access to the collection of Hyperlinks contained in the worksheet.  
 Property Gets or sets the index number of the object within the collection of similar objects (read-only).  
 Property Gets or sets the name of the object (read or write).  
 PropertyReturns the INames collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix). This is a read-only Names object.  
 PropertyReturns an IOutline object that represents the outline for the specified worksheet (read-only).  
 Property Returns a PageSetup object that contains all the page setup settings for the specified object.  
 PropertyReturns 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).  
 Property Gets or sets the protection status of the worksheet.  
 PropertyReturns the IProtectionSettings object that represents the protection options of the worksheet.  
 PropertyReturns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyReturns the IRange object that represents all the rows on the specified worksheet. This is read-only Range object.  
 Property Gets the selection range.  
 PropertyReturns a Shapes object that represents all the shapes on the worksheet or chart sheet (read-only).  
 Property Represents the worksheet view option.  
 Property Returns the sorted values in the current worksheet (read-only).  
 Property Gets or sets the standard (default) height of all the rows in the worksheet in points (read-only).  
 Property Gets or sets the standard (default) width of all the columns in the worksheet (read or write).  
 Property Gets or sets the primary color of the tab.  
 PropertyReturns a collection of ITable objects in the worksheet. This is a read-only ListObjects collection.  
 PropertyReturns the IRange object that represents the used range on the specified worksheet (read-only).  
 PropertyDetermines whether the object is visible (read or write Visibility).  
 Property Returns the workbook  
Top
See Also

Reference

IWorksheet Interface
GrapeCity.Documents.Spread Namespace