SpreadsheetGear 2012
IWorksheet Interface Properties

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

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
See Also

Reference

IWorksheet Interface
SpreadsheetGear Namespace

Send Feedback