SpreadsheetGear 2023
IWorksheet Interface Properties

SpreadsheetGear Namespace : IWorksheet Interface

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

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.  
 PropertyReturns the collection of cell comments associated with this worksheet.  
 PropertyGets or sets the property which specifies whether automatic page breaks should be displayed.  
 PropertyGets or sets what can be selected on the worksheet when it is protected.  
 PropertyReturns the IFactory which created this object or its parent. (Inherited from SpreadsheetGear.IFactoryChild)
 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.  
 PropertyGets or sets the property which specifies whether the droawing objects on a worksheet are protected.  
 PropertyGets the fine-grained protection attributes for a worksheet.  
 PropertyGets or sets the value which specifies whether API access is allowed while the worksheet is protected.  
 PropertyGets or sets the property which specifies whether worksheet scenarios 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
See Also

Reference

IWorksheet Interface
SpreadsheetGear Namespace