The following tables list the members exposed by IWorksheet.
Public Properties
| Name | Description | |
|---|---|---|
 | Cells | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods. |
| DisplayAutomaticPageBreaks | Gets or sets the property which specifies whether automatic page breaks should be displayed. |
| HPageBreaks | Returns a reference to the horizontal page break collection for the worksheet. |
| Hyperlinks | Returns a reference to the hyperlink collection for the worksheet. |
| Names | Returns the collection of worksheet specific defined names associated with this worksheet. |
| Outline | Returns an instance of IOutline which provides access to outline options. |
| PageSetup | Returns an instance of IPageSetup which provides access to page setup options. |
| ProtectContents | Gets or sets the property which specifies whether the contents of a worksheet are protected. |
| Range | Returns an instance of IRange which provides access to cell values, formulas, formatting and other cell properties and methods. |
| Shapes | Returns the collection of shapes associated with this worksheet. |
| StandardWidth | Gets or sets the default column width for this worksheet in units equal to the width of a character in the default font. |
| TransitionExpEval | Gets or sets the property which specifies whether or not a worksheet should use transitional formula evaluation. |
| TransitionFormEntry | Gets or sets the property which specifies whether or not a worksheet should use transitional formula entry. |
| UsedRange | Returns an IRange representing the portion of the worksheet which is in use. |
| VPageBreaks | Returns a reference to the vertical page break collection for the worksheet. |
| WindowInfo | Returns an instance of IWorksheetWindowInfo which represents worksheet specific window options. |
Public Methods
| Name | Description | |
|---|---|---|
 | Protect | Enables protection for this worksheet with the specified password. |
| SaveAs | Saves this worksheet using the specified filename and FileFormat, and updates the FullName property. |
| SaveToMemory | Saves this worksheet to a newly created memory buffer in the specified FileFormat. |
| SaveToStream | Saves this worksheet to a stream in the specified FileFormat. |
| Unprotect | Disables protection for the worksheet with the specified password. |