SpreadsheetGear 2012
IWorksheet Interface Members
Properties  Methods 

The following tables list the members exposed by IWorksheet.

Public Properties
 NameDescription
 PropertyAutoFilterReturns an instance of IAutoFilter which represents the autofilter options associated with this worksheet, or null if this worksheet is not in autofilter mode.  
 PropertyAutoFilterModeGets or sets the property which specifies whether this worksheet is in autofilter mode.  
 PropertyCellsReturns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyDisplayAutomaticPageBreaksGets or sets the property which specifies whether automatic page breaks should be displayed.  
 PropertyHPageBreaksReturns a reference to the horizontal page break collection for the worksheet.  
 PropertyHyperlinksReturns a reference to the hyperlink collection for the worksheet.  
 PropertyIndexReturns the zero based index of this sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyNameGets or sets the name of the sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyNamesReturns the collection of worksheet specific defined names associated with this worksheet.  
 PropertyOutlineReturns an instance of IOutline which provides access to outline options.  
 PropertyPageSetupReturns an instance of IPageSetup which provides access to page setup options.  
 PropertyProtectContentsGets or sets the property which specifies whether the contents of a worksheet are protected.  
 PropertyRangeReturns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyShapesReturns the collection of shapes associated with this worksheet.  
 PropertyStandardWidthGets or sets the default column width for this worksheet in units equal to the width of a character in the default font.  
 PropertyTabReturns a reference to the sheet tab of this sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyTransitionExpEvalGets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation.  
 PropertyTransitionFormEntryGets or sets the property which specifies whether or not a worksheet should use transitional formula entry.  
 PropertyTypeReturns the SheetType of this sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyUsedRangeReturns an IRange representing the portion of the worksheet which is in use.  
 PropertyVisibleGets or sets the property which indicates whether or not a worksheet is visible. (Inherited from SpreadsheetGear.ISheet)
 PropertyVPageBreaksReturns a reference to the vertical page break collection for the worksheet.  
 PropertyWindowInfoReturns an instance of IWorksheetWindowInfo which represents worksheet specific window options.  
 PropertyWorkbookReturns the workbook which contains the current sheet. (Inherited from SpreadsheetGear.ISheet)
 PropertyWorkbookSetReturns the parent IWorkbookSet of this sheet. (Inherited from SpreadsheetGear.ISheet)
Top
Public Methods
 NameDescription
 MethodCopyAfterCreates a new sheet after the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodCopyBeforeCreates a new sheet before the specified sheet and copies the contents of this sheet to the newly created sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodDeleteDeletes this sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateRangeEvaluates the specified formula and returns the resulting IRange. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateRangesEvaluates the specified formula and returns the resulting array of ranges. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateValueEvaluates the specified formula and returns the result as a System.Double, System.String, System.Boolean or ValueError. (Inherited from SpreadsheetGear.ISheet)
 MethodEvaluateValuesEvaluates the specified formula and returns the result as an array of objects, where each object is a System.Double, System.String, System.Boolean or ValueError. (Inherited from SpreadsheetGear.ISheet)
 MethodMoveAfterMoves this sheet to come after the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodMoveBeforeMoves this sheet to come before the specified sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodProtectEnables protection for this worksheet with the specified password.  
 MethodSaveAsSaves this worksheet using the specified filename and FileFormat, and updates the FullName property.  
 MethodSaveToMemorySaves this worksheet to a newly created memory buffer in the specified FileFormat.  
 MethodSaveToStreamSaves this worksheet to a stream in the specified FileFormat.  
 MethodSelectSelects the sheet. (Inherited from SpreadsheetGear.ISheet)
 MethodUnprotectDisables protection for the worksheet with the specified password.  
Top
See Also

Reference

IWorksheet Interface
SpreadsheetGear Namespace

Send Feedback