NativeExcel for .Net Developer's Reference

IWorksheetProperties

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