SpreadsheetGear The Performance Spreadsheet Component Company 
IWorksheet Interface Members
See Also  Properties  Methods 
SpreadsheetGear Namespace : IWorksheet Interface


The following tables list the members exposed by IWorksheet.

Public Properties

 NameDescription
 PropertyCells Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyDisplayAutomaticPageBreaks Gets or sets the property which specifies whether automatic page breaks should be displayed.  
 PropertyHPageBreaks Returns a reference to the horizontal page break collection for the worksheet.  
 PropertyHyperlinks Returns a reference to the hyperlink collection for the worksheet.  
 PropertyNames Returns the collection of worksheet specific defined names associated with this worksheet.  
 PropertyOutline Returns an instance of IOutline which provides access to outline options.  
 PropertyPageSetup Returns an instance of IPageSetup which provides access to page setup uptions.  
 PropertyProtectContents Gets or sets the property which specifies whether the contents of a worksheet are protected.  
 PropertyRange Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods.  
 PropertyShapes Returns the collection of shapes associated with this worksheet.  
 PropertyStandardWidth Gets or sets the default column width for this worksheet in units equal to the width of a character in the default font.  
 PropertyTransitionExpEval Gets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation.  
 PropertyUsedRange Returns an IRange representing the portion of the worksheet which is in use.  
 PropertyVPageBreaks Returns a reference to the vertical page break collection for the worksheet.  
 PropertyWindowInfo Returns an instance of IWorksheetWindowInfo which represents worksheet specific window options.  
Top

Public Methods

 NameDescription
 MethodProtect Enables protection for this worksheet with the specified password.  
 MethodUnprotect Disables protection for the worksheet with the specified password.  
Top

See Also