| Name | Description |
|---|---|
| ActiveView |
Provides access to an object that contains options to display and print a worksheet. |
| ArrayFormulas |
Obtains a collection of array formulas in a current worksheet. |
| AutoFilter |
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. |
| CodeName |
Gets or sets a worksheet code name. |
| Columns |
Provides access to the collection of all columns contained in the worksheet. |
| Comments |
Provides access to the collection of all cell comments contained in the worksheet. |
| Comparers |
Provides access to default comparers used to sort cell values in ascending and descending order. |
| ConditionalFormattings |
Provides access to the collection of all conditional formatting rules on a worksheet. |
| CustomCellInplaceEditors |
Provides access to the collection of the custom in-place editors embedded into worksheet cells. |
| DataBindings |
Provides access to the collection of WorksheetDataBinding objects. |
| DataValidations |
Provides access to a collection of DataValidation objects for the worksheet. |
| DefaultColumnWidth |
Gets or sets the default column width in units of measurement used in the workbook. |
| DefaultColumnWidthInCharacters |
Gets or sets the default column width in characters of the default font specified by the built-in Normal style. |
| DefaultColumnWidthInPixels |
Gets or sets the default column width in pixels. |
| DefaultRowHeight |
Gets or sets the default height of worksheet rows. |
| DefinedNames |
Gets the collection of defined names whose scope is the current worksheet. |
| HeaderFooterOptions |
Provides access to options which determine the worksheet header and footer characteristics. |
| HorizontalPageBreaks |
Provides access to a collection of row page breaks in the worksheet. |
| Hyperlinks |
Provides access to the collection of hyperlinks contained in the worksheet. |
| IgnoredErrors |
Provides access to ranges and error types which are ignored in those ranges. |
| Index |
Gets the worksheet index within the workbook's WorksheetCollection collection. |
| IsProtected |
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 . |
| OutlineOptions |
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. |
| PivotTables |
Provides access to the collection of pivot tables in a worksheet. |
| PrintOptions |
Provides access to options that control how the worksheet is printed. |
| ProtectedRanges |
Provides access to a collection of protected ranges in a current worksheet. |
| Range |
Provides access to the range of cells in the worksheet. |
| Rows |
Provides access to the collection of all rows contained in the worksheet. |
| SelectedCell | |
| SelectedChart |
Gets or sets the chart selected in a worksheet. |
| SelectedComment |
Gets or sets a comment selected in a worksheet. |
| SelectedPicture | |
| SelectedShape | |
| 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. |
| SheetType |
Returns the type of the sheet. (Inherited from Sheet)
|
| SparklineGroups |
Provides access to a collection of sparkline groups in a worksheet. |
| SplitLeftPosition |
Gets the index of the leftmost column in the bottom right pane when panes are frozen. |
| SplitTopPosition |
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. |
| VerticalPageBreaks |
Provides access to a collection of column page breaks in the worksheet. |
| VisibilityType |
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 |
| Name | Description |
|---|---|
| AddPrintRange(Range) |
Extends print range by merging with the specified range. |
| AutoOutline() |
Automatically creates an outline for the specified worksheet. |
| Calculate() |
Forces recalculation of the current worksheet. |
| Clear(Range) |
Removes cell content, formatting, hyperlinks and comments. |
| ClearComments(Range) |
Removes cell comments. |
| ClearContents(Range) |
Removes cell content. |
| ClearFormats(Range) |
Removes cell formatting. |
| ClearHyperlinks(Range) |
Removes cell hyperlinks. |
| ClearOutline() |
Clears the outline for the specified worksheet. |
| ClearPrintRange() |
Clears the print area in the current worksheet. |
| CopyFrom(Worksheet) |
Copies the specified worksheet into the current instance. |
| DeleteCells(Range) |
Deletes cells from a worksheet, shifting other cells in the same row to the left. |
| DeleteCells(Range, DeleteMode) | |
| FreezeColumns(Int32) |
Freezes the specified number of columns on the left side of the worksheet. |
| FreezeColumns(Int32, Range) |
Freezes the specified number of columns to the right of the specified cell, including the column that contains this cell. |
| FreezePanes(Int32, Int32) |
Freezes the specified number of rows and columns at the top and on the left side of the worksheet. |
| FreezePanes(Int32, Int32, Range) |
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. |
| FreezeRows(Int32) |
Freezes the specified number of rows at the top of the worksheet. |
| FreezeRows(Int32, Range) |
Freezes the specified number of rows below the specified cell, including the row that contains this cell. |
| GetCellValue(Int32, Int32) |
Obtains the cell value for the specified cell. (Inherited from ExternalWorksheet)
|
| GetDataRange() |
Gets the worksheet range that encompasses all cells containing data and formulas. |
| GetExistingCells() |
Gets the existing cells in the worksheet. |
| GetPrintableRange() |
Returns a worksheet range that can be printed. |
| GetPrintableRange(Boolean) |
Calculates a worksheet range that can be printed with respect to the specified print area. |
| GetProtectionPermissions() |
Returns the permission set for a protected worksheet. |
| GetSelectedRanges() |
Returns cell ranges currently selected in the worksheet. |
| GetSelectedShapes() | |
| GetUsedRange() |
Returns the used range on the specified worksheet. |
| InsertCells(Range) |
Inserts new cells in a worksheet, shifting other cells in the same column down. |
| InsertCells(Range, InsertCellsMode) | |
| MergeCells(Range) |
Merges the specified cells. |
| MergeCells(Range, MergeCellsMode) |
Merges cells in the specified mode. |
| Move(Int32) |
Moves the worksheet to another location within the workbook's collection of worksheets. |
| MoveAfter(String) |
Moves the current sheet after the specified sheet in a workbook. (Inherited from Sheet)
|
| MoveBefore(String) |
Moves the current sheet before the specified sheet in a workbook. (Inherited from Sheet)
|
| MoveToBeginning() |
Moves the current sheet to the first position in a workbook. (Inherited from Sheet)
|
| MoveToEnd() |
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(PrinterSettings) |
Prints the current sheet using the specified printer settings. (Inherited from Sheet)
|
| Protect(String, WorksheetProtectionPermissions) |
Protects worksheet elements to prevent them from being changed by the user. |
| RemoveSubtotal(Range) |
Removes subtotals for the specified cell range. |
| ScrollTo(Int32, Int32) |
Scrolls the worksheet to the specified column and row. |
| ScrollTo(Range) |
Scrolls the worksheet to the top-left cell of the specified range. |
| ScrollToColumn(Int32) |
Scrolls the worksheet to the specified column. |
| ScrollToColumn(String) |
Scrolls the worksheet to the specified column. |
| ScrollToRow(Int32) |
Scrolls the worksheet to the specified row. |
| ScrollToRow(String) |
Scrolls the worksheet to the specified row. |
| Search(String) |
Performs a search in the worksheet using the default parameters. |
| Search(String, SearchOptions) |
Performs a search in the worksheet using specified options. |
| SetPrintRange(Range) |
Defines the print range. |
| SetSelectedRanges(IList<Range>) |
Sets cell ranges selected in the worksheet. |
| SetSelectedRanges(IList<Range>, Boolean) |
Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells. |
| SetSelectedShapes(IList<Shape>) | |
| Sort(Range) |
Sorts the specified range by the first column in ascending order. |
| Sort(Range, Boolean) |
Sorts the specified range by the first column. |
| Sort(Range, IEnumerable<SortField>) |
Sorts the specified range by multiple columns. |
| Sort(Range, Int32) |
Sorts the specified range by the specified column in ascending order. |
| Sort(Range, Int32, Boolean) |
Sorts the specified range by the specified column. |
| Sort(Range, Int32, IComparer<CellValue>) |
Sorts the specified range by the specified column using the specified comparer. |
| Subtotal(Range, Int32, List<Int32>, Int32, String) |
Creates subtotals for the specified range of cells. |
| UnMergeCells(Range) |
Unmerges the specified cells that have been merged. |
| UnfreezePanes() |
Unfreezes rows and columns on the worksheet. |
| Unprotect(String) |
Removes protection from a worksheet. |