IWorksheet Interface Members

	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).
	PageSetup	Returns a PageSetup object that contains all the page setup settings for the specified object.
	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

	Name	Description
	Activate	Makes the current sheet the active sheet. This is equivalent to clicking the sheet's tab.
	Delete	Deletes the object.
	Evaluate	Converts a Microsoft Excel name to an object or a value.
	FreezePanes	Freezes panes at the specified position.
	GetUsedRange	Gets the used range.
	ShowAllData	Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."
	UnfreezePanes	Unfreezes panes.

Top

	Name	Description
	Activated	Occurs when the worksheet is activated.
	BeforeDelete	Occurs before the worksheet is deleted.
	Changed	Occurs when something changes in the cells.
	Deactivated	Occurs when the worksheet is deactivated.
	SelectionChange	Occurs when the selection changes on a worksheet.

Top

Reference

IWorksheet Interface
GrapeCity.Documents.Spread Namespace