The properties of the IWorksheet interface are listed below. For a complete list of IWorksheet interface members, see the IWorksheet Members topic.
Public Instance Properties
 Cells | Returns an IRange interface that represents all the cells on the worksheet (not just the cells that are currently in use). Read-only. |
| DisplayAutomaticPageBreaks | Returns or sets the value which specifies whether automatic page breaks should be displayed. |
| DisplayGridlines | Gets or sets a value that indicates whether or not the grid lines are displayed. |
| DisplayRightToLeft | Gets or sets the value that indicates whether the worksheet is displayed from right to left instead of from left to right. |
| DisplayZeros | Gets or sets the value which specifies whether zero values are displayed for the specified worksheet |
| EnableSelection | Gets or sets the value which specifies what can be selected on the sheet. |
| FreezePanes | Gets or sets the value which specifies whether or not window panes are frozen for the specified worksheet. |
| HPageBreaks | Returns an IPageBreaks interface that represents the horizontal page breaks on the worksheet. |
| Hyperlinks | Returns an IHyperlinks interface that represents the hyperlinks for the specified worksheet. |
| Index | Returns the index number of the worksheet within the IWorksheets collection. Read-only. |
| Name | Gets or sets the name of the Worksheet. |
| Names | Returns an INames collection that represents all the defined names in the specified worksheet. |
| Next | Returns an IWorksheet interface that represents the next worksheet. |
| Outline | Returns an IOutline interface that represents the outline for the specified worksheet. |
| PageSetup | Returns an IPageSetup interface which contains all the page setup settings for the specified worksheet. |
| Previous | Returns an IWorksheet interface that represents the previous worksheet. |
| Protection | Returns an IProtection interface that represents the various types of protection options available for a worksheet. |
| Range | Returns an IRange interface that represents all the cells on the worksheet (not just the cells that are currently in use). Read-only. |
| ScrollColumn | Gets or sets the first visible column. |
| ScrollRow | Gets or sets the first visible row. |
| Selected | Gets or sets a value that indicates whether or not the worksheet is selected. |
| Selection | Returns the selected range in the specified worksheet. |
| Shapes | Returns a IShapes interface that represents all the shapes on the worksheet. |
| Split | Gets or sets the value which specifies whether or not the window is splitted. |
| SplitColumn | Returns or sets the column number where the worksheet is split into panes (the number of colums to the left of the split line). |
| SplitRow | Returns or sets the row number where the worksheet is split into panes (the number of rows above the split). |
| StandardHeight | Gets or sets the standard (default) height of all the rows in the worksheet, in points. |
| StandardWidth | Gets or sets the standard (default) width of all the columns in the worksheet. |
| UsedRange | Returns an IRange interface that represents the used range on the specified worksheet. |
| View | Returns or sets the view showing in the window. |
| Visible | Gets or sets a value that determines whether the worksheet is visible. |
| VPageBreaks | Returns an IPageBreaks interface that represents the vertical page breaks on the worksheet. |
| Zoom | Gets or sets the display size of the worksheet, as a percentage (100 equals normal size, 200 equals double size, and so on). |
See Also
IWorksheet Interface | NativeExcel Namespace | Item