Worksheet Members
In This Article
#Properties
Name | Description |
---|---|
Active |
Provides access to an object that contains options to display and print a worksheet. |
Array |
Obtains a collection of legacy array formulas in a current worksheet. |
Auto |
Provides access to an object that contains options to filter data in a worksheet. |
Cells | Provides access to the collection of all cells contained in the worksheet. |
Charts | Provides access to a collection of charts in a worksheet. |
Code |
Gets or sets the worksheet’s code name. |
Columns | Returns the collection of all columns in a worksheet. |
Comments | Retrieves a collection of simple notes (legacy comments) contained in a worksheet. |
Comparers | Provides access to default comparers used to sort cell values in ascending and descending order. |
Conditional |
Provides access to the collection of all conditional formatting rules on a worksheet. |
Custom |
Provides access to the collection of the custom in-place editors embedded into worksheet cells. |
Data |
Provides access to the collection of Worksheet |
Data |
Provides access to a collection of Data |
Default |
Gets or sets the default column width in units of measurement used in the workbook. |
Default |
Gets or sets the default column width in characters of the default font specified by the built-in Normal style. |
Default |
Gets or sets the default column width in pixels. |
Default |
Gets or sets the default height of worksheet rows. |
Defined |
Gets the collection of defined names whose scope is the current worksheet. |
Dynamic |
Obtains a collection of dynamic array formulas in a current worksheet. |
Form |
Obtains a collection of form controls contained in a worksheet. |
Has |
Checks whether the current worksheet contains data. |
Header |
Provides access to header and footer options for a worksheet. |
Horizontal |
Provides access to a collection of row page breaks in the worksheet. |
Hyperlinks | Provides access to the collection of hyperlinks contained in the worksheet. |
Id | Returns the sheet’s unique identifier. Inherited from Sheet. |
Ignored |
Provides access to ranges and error types which are ignored in those ranges. |
Index |
Gets the worksheet index within the workbook’s Worksheet |
Is |
Gets whether the worksheet is protected. |
Item[Int32, Int32] | Provides access to an individual cell by indexes of a row and column containing this cell. |
Item[String] | Provides access to a cell range by its reference string. |
Name | Gets or sets the name of the worksheet . |
Outline |
Provides access to the group settings that control the summary row and column location. |
Pictures | Provides access to a collection of pictures in a worksheet. |
Pivot |
Provides access to the collection of pivot tables in a worksheet. |
Print |
Provides access to options that control how the worksheet is printed. |
Protected |
Provides access to a collection of protected ranges in a current worksheet. |
Range | Provides access to the range of cells in the worksheet. |
Rows | Returns the collection of all rows in a worksheet. |
Selected |
Gets or sets an active cell in the worksheet. |
Selected |
Gets or sets the chart selected in a worksheet. |
Selected |
Gets or sets a comment selected in a worksheet. |
Selected |
Gets or sets a picture selected in the worksheet. |
Selected |
Gets or sets a shape selected in the worksheet. |
Selection | Gets or sets a cell range selected in the worksheet. |
Shapes | Provides access to a collection of drawing objects (shapes, pictures, and charts) in a worksheet. |
Sheet |
Returns the type of the sheet. Inherited from Sheet. |
Sparkline |
Provides access to a collection of sparkline groups in a worksheet. |
Split |
Gets the index of the leftmost column in the bottom right pane when panes are frozen. |
Split |
Gets the index of the topmost row in the bottom right pane when panes are frozen. |
Tables | Provides access to the collection of tables contained in the worksheet. |
Tag | Gets or sets the data associated with a Worksheet object. |
Threaded |
Obtains a collection of threaded comments. |
Vertical |
Provides access to a collection of column page breaks in the worksheet. |
Visibility |
Gets or sets whether the current worksheet is visible, hidden or “very hidden”. |
Visible | Gets or sets whether the current worksheet is visible or hidden. |
Workbook | Gets a workbook that contains the current worksheet. |
#Methods
Name | Description |
---|---|
Add |
Extends print range by merging with the specified range. |
Auto |
Automatically creates an outline for the specified worksheet. |
Calculate() | Forces recalculation of the current worksheet and does not look for circular references. |
Clear |
Removes cell content, formatting, hyperlinks and comments. |
Clear |
Removes cell comments and simple notes. |
Clear |
Removes cell content. |
Clear |
Removes cell formatting. |
Clear |
Removes cell hyperlinks. |
Clear |
Clears the outline for the specified worksheet. |
Clear |
Clears the print area in the current worksheet. |
Copy |
Copies data from the specified worksheet to the current worksheet and allows you to specify copy options. |
Copy |
Copies the specified worksheet into the current instance. |
Create |
Creates a new object that contains information about the comment author. |
Delete |
Deletes cells from the worksheet. |
Delete |
Deletes cells from a worksheet, shifting other cells in the same row to the left. |
Freeze |
Freezes the specified number of columns to the right of the specified cell, including the column that contains this cell. |
Freeze |
Freezes the specified number of columns on the left side of the worksheet. |
Freeze |
Freezes the specified number of rows and columns below and to the right of the specified cell, including the row and column containing this cell. |
Freeze |
Freezes the specified number of rows and columns at the top and on the left side of the worksheet. |
Freeze |
Freezes the specified number of rows below the specified cell, including the row that contains this cell. |
Freeze |
Freezes the specified number of rows at the top of the worksheet. |
Get |
Obtains the cell value for the specified cell.
Inherited from External |
Get |
Gets the worksheet range that encompasses all cells containing data and formulas. |
Get |
Gets the existing cells in the worksheet. |
Get |
Returns a worksheet range that can be printed. |
Get |
Calculates a worksheet range that can be printed with respect to the specified print area. |
Get |
Returns the permission set for a protected worksheet. |
Get |
Returns cell ranges currently selected in the worksheet. |
Get |
Returns shapes currently selected in the worksheet. |
Get |
Returns the used range on the specified worksheet. |
Insert |
Inserts new cells in the worksheet. |
Insert |
Inserts new cells in a worksheet, shifting other cells in the same column down. |
Merge |
Merges cells in the specified mode. |
Merge |
Merges the specified cells. |
Move |
Moves the worksheet to another location within the workbook’s collection of worksheets. |
Move |
Moves the current sheet after the specified sheet in a workbook. Inherited from Sheet. |
Move |
Moves the current sheet before the specified sheet in a workbook. Inherited from Sheet. |
Move |
Moves the current sheet to the first position in a workbook. Inherited from Sheet. |
Move |
Moves the current sheet to the last position in a workbook. Inherited from Sheet. |
Print() | Prints the current sheet using the default printer settings. Inherited from Sheet. |
Print |
Prints the current sheet using the specified printer settings. Use this method overload in non-Windows environments. Inherited from Sheet. |
Print |
Prints the current sheet using the specified printer settings. Inherited from Sheet. |
Protect |
Protects worksheet elements to prevent them from being changed by the user. |
Remove |
Removes subtotals for the specified cell range. |
Scroll |
Scrolls the worksheet to the top-left cell of the specified range. |
Scroll |
Scrolls the worksheet to the specified column and row. |
Scroll |
Scrolls the worksheet to the specified column. |
Scroll |
Scrolls the worksheet to the specified column. |
Scroll |
Scrolls the worksheet to the specified row. |
Scroll |
Scrolls the worksheet to the specified row. |
Search |
Performs a search in the worksheet using specified options. |
Search |
Performs a search in the worksheet using the default parameters. |
Set |
Defines the print range. |
Set |
Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells. |
Set |
Sets cell ranges selected in the worksheet. |
Set |
Sets shapes selected in the worksheet. |
Sort |
Sorts the specified range by the specified color in the specified order. |
Sort |
Sorts the specified range by the specified color in ascending order. |
Sort |
Sorts the specified range by the first column. |
Sort |
Sorts the specified range by multiple columns. |
Sort |
Sorts the specified range by the font color in a specific order. |
Sort |
Sorts the specified range by the specified font color in ascending order. |
Sort |
Sorts the specified range by the fill color in a specific order. Allows you to specify column offset. |
Sort |
Sorts the specified range by the fill color. Allows you to specify column offset. |
Sort |
Sorts the specified range by the specified column. |
Sort |
Sorts the specified range by the specified column using the specified comparer. |
Sort |
Sorts the specified range by the font color in a specific order. Allows you to specify column offset. |
Sort |
Sorts the specified range by the background color. Allows you to specify column offset. |
Sort |
Sorts the specified range by the specified column in ascending order. |
Sort |
Sorts the specified range by the first column in ascending order. |
Subtotal |
Creates subtotals for the specified range of cells. |
Unfreeze |
Unfreezes rows and columns on the worksheet. |
Un |
Unmerges the specified cells that have been merged. |
Unprotect |
Removes protection from a worksheet. |
See Also