IWorksheet Interface Members

The following tables list the members exposed by IWorksheet.

Public Properties

	Name	Description
	AutoFilter	Returns an instance of IAutoFilter which represents the autofilter options associated with this worksheet, or null if this worksheet is not in autofilter mode.
	AutoFilterMode	Gets or sets the property which specifies whether this worksheet is in autofilter mode.
	Cells	Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.
	Comments	Returns the collection of cell comments associated with this worksheet.
	DisplayAutomaticPageBreaks	Gets or sets the property which specifies whether automatic page breaks should be displayed.
	EnableSelection	Gets or sets what can be selected on the worksheet when it is protected.
	Factory	Returns the IFactory which created this object or its parent. (Inherited from SpreadsheetGear.IFactoryChild)
	HPageBreaks	Returns a reference to the horizontal (row) page break collection for the worksheet.
	Hyperlinks	Returns a reference to the hyperlink collection for the worksheet.
	Index	Returns the zero based index of this sheet. (Inherited from SpreadsheetGear.ISheet)
	IsDisposed	Returns `true` if this sheet has been disposed. (Inherited from SpreadsheetGear.ISheet)
	Name	Gets or sets the name of the sheet. (Inherited from SpreadsheetGear.ISheet)
	Names	Returns the collection of worksheet specific defined names associated with this worksheet.
	Outline	Returns an instance of IOutline which provides access to outline options.
	PageSetup	Returns an instance of IPageSetup which provides access to page setup options.
	ProtectContents	Gets or sets the property which specifies whether the contents of a worksheet are protected.
	ProtectDrawingObjects	Gets or sets the property which specifies whether the droawing objects on a worksheet are protected.
	Protection	Gets the fine-grained protection attributes for a worksheet.
	ProtectionMode	Gets or sets the value which specifies whether API access is allowed while the worksheet is protected.
	ProtectScenarios	Gets or sets the property which specifies whether worksheet scenarios are protected.
	Range	Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.
	Shapes	Returns the collection of shapes associated with this worksheet.
	StandardWidth	Gets or sets the default column width for this worksheet in units equal to the width of a character in the default font.
	Tab	Returns a reference to the sheet tab of this sheet. (Inherited from SpreadsheetGear.ISheet)
	TransitionExpEval	Gets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation.
	TransitionFormEntry	Gets or sets the property which specifies whether or not a worksheet should use transitional formula entry.
	Type	Returns the SheetType of this sheet. (Inherited from SpreadsheetGear.ISheet)
	UsedRange	Returns an IRange representing the portion of the worksheet which is in use.
	Visible	Gets or sets the property which indicates whether or not a worksheet is visible. (Inherited from SpreadsheetGear.ISheet)
	VPageBreaks	Returns a reference to the vertical (column) page break collection for the worksheet.
	WindowInfo	Returns an instance of IWorksheetWindowInfo which represents worksheet specific window options for the currently active view.
	WindowInfos	Returns a reference to the IWorksheetWindowInfo collection for the worksheet.
	Workbook	Returns the workbook which contains the current sheet. (Inherited from SpreadsheetGear.ISheet)
	WorkbookSet	Returns the parent IWorkbookSet of this sheet. (Inherited from SpreadsheetGear.ISheet)

Top

Public Methods

	Name	Description
	CopyAfter	Creates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
	CopyBefore	Creates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
	Delete	Deletes this sheet. (Inherited from SpreadsheetGear.ISheet)
	EvaluateRange	Evaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet)
	EvaluateRanges	Evaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet)
	EvaluateValue	Evaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean, ValueError or null if the formula is invalid or the formula evaluates to a reference to an empty cell. (Inherited from SpreadsheetGear.ISheet)
	EvaluateValues	Evaluates the specified comma separated list of expressions and returns the result(s) as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError. null is returned if any of the expressions is invalid or if any of the expressions evaluates to a reference to an empty cell. (Inherited from SpreadsheetGear.ISheet)
	MoveAfter	Moves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet)
	MoveBefore	Moves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet)
	Protect	Enables protection for this worksheet with the optional password, protect* and allow* options.
	SaveAs	Saves this worksheet using the specified filename and FileFormat, and updates the FullName property.
	SaveToMemory	Saves this worksheet to a newly created memory buffer in the specified FileFormat.
	SaveToStream	Saves this worksheet to a stream in the specified FileFormat.
	Select	Selects the sheet. (Inherited from SpreadsheetGear.ISheet)
	Unprotect	Disables protection for the worksheet with the specified password.

Top

Reference

IWorksheet Interface
SpreadsheetGear Namespace