NativeExcel2 for .Net Developer's Reference

IWorksheet Members

IWorksheet overview

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.
IsProtected
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).

Public Instance Methods

Activate Makes the specified sheet the active sheet. Equivalent to clicking the sheet's tab.
Delete Deletes the worksheet from the workbook.
Move Moves the sheet to another location in the workbook.
ProtectOverloaded. Protects a worksheet so that it cannot be modified.
ResetAllPageBreaks Resets all page breaks on the worksheet.
SaveAsOverloaded. Saves worksheet content in a file or a Stream.
SaveAsHTMLOverloaded. Saves worksheet in HTML format.
SelectOverloaded. Selects the worksheet.
UnprotectOverloaded. Removes protection from a sheet. This method has no effect if the sheet isn't protected.

See Also

IWorksheet Interface | NativeExcel Namespace | Item