SpreadsheetGear 2017
IWorksheet Interface Members
Properties  Methods 

SpreadsheetGear Namespace : IWorksheet Interface

The following tables list the members exposed by IWorksheet.

Public Properties
 NameDescription
 PropertyReturns an instance of IAutoFilter which represents the autofilter options associated with this worksheet, or null if this worksheet is not in autofilter mode.  
 PropertyGets or sets the property which specifies whether this worksheet is in autofilter mode.  
 PropertyReturns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyGets or sets the property which specifies whether automatic page breaks should be displayed.  
 PropertyReturns a reference to the horizontal (row) page break collection for the worksheet.  
 PropertyReturns a reference to the hyperlink collection for the worksheet.  
 PropertyReturns the zero based index of this sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyReturns true if this sheet has been disposed. (Inherited from SpreadsheetGear.ISheet)
 PropertyGets or sets the name of the sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyReturns the collection of worksheet specific defined names associated with this worksheet.  
 PropertyReturns an instance of IOutline which provides access to outline options.  
 PropertyReturns an instance of IPageSetup which provides access to page setup options.  
 PropertyGets or sets the property which specifies whether the contents of a worksheet are protected.  
 PropertyReturns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyReturns the collection of shapes associated with this worksheet.  
 PropertyGets or sets the default column width for this worksheet in units equal to the width of a character in the default font.  
 PropertyReturns a reference to the sheet tab of this sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyGets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation.  
 PropertyGets or sets the property which specifies whether or not a worksheet should use transitional formula entry.  
 PropertyReturns the SheetType of this sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyReturns an IRange representing the portion of the worksheet which is in use.  
 PropertyGets or sets the property which indicates whether or not a worksheet is visible. (Inherited from SpreadsheetGear.ISheet)
 PropertyReturns a reference to the vertical (column) page break collection for the worksheet.  
 PropertyReturns an instance of IWorksheetWindowInfo which represents worksheet specific window options for the currently active view.  
 PropertyReturns a reference to the IWorksheetWindowInfo collection for the worksheet.  
 PropertyReturns the workbook which contains the current sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyReturns the parent IWorkbookSet of this sheet. (Inherited from SpreadsheetGear.ISheet)
Top
Public Methods
 NameDescription
 MethodCreates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodCreates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodDeletes this sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluates 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)
 MethodEvaluates 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)
 MethodMoves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodMoves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodEnables protection for this worksheet with the specified password.  
 MethodSaves this worksheet using the specified filename and FileFormat, and updates the FullName property.  
 MethodSaves this worksheet to a newly created memory buffer in the specified FileFormat.  
 MethodSaves this worksheet to a stream in the specified FileFormat.  
 MethodSelects the sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodDisables protection for the worksheet with the specified password.  
Top
See Also

Reference

IWorksheet Interface
SpreadsheetGear Namespace