The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Worksheet Methods

Name Description
AddPrintRange(CellRange)

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(CellRange)

Removes cell content, formatting, hyperlinks and comments.

ClearComments(CellRange)

Removes cell comments.

ClearContents(CellRange)

Removes cell content.

ClearFormats(CellRange)

Removes cell formatting.

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(CellRange)

Deletes cells from a worksheet, shifting other cells in the same row to the left.

DeleteCells(CellRange, DeleteMode)

Deletes cells from the worksheet.

FreezeColumns(Int32)

Freezes the specified number of columns on the left side of the worksheet.

FreezeColumns(Int32, CellRange)

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, CellRange)

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, CellRange)

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()

Returns shapes currently selected in the worksheet.

GetUsedRange()

Returns the used range on the specified worksheet.

InsertCells(CellRange)

Inserts new cells in a worksheet, shifting other cells in the same column down.

InsertCells(CellRange, InsertCellsMode)

Inserts new cells in the worksheet.

MergeCells(CellRange)

Merges the specified cells.

MergeCells(CellRange, 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(CellRange)

Removes subtotals for the specified cell range.

ScrollTo(CellRange)

Scrolls the worksheet to the top-left cell of the specified range.

ScrollTo(Int32, Int32)

Scrolls the worksheet to the specified column and row.

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(CellRange)

Defines the print range.

SetSelectedRanges(IList<CellRange>)

Sets cell ranges selected in the worksheet.

SetSelectedRanges(IList<CellRange>, Boolean)

Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells.

SetSelectedShapes(IList<Shape>)

Sets shapes selected in the worksheet.

Sort(CellRange)

Sorts the specified range by the first column in ascending order.

Sort(CellRange, Boolean)

Sorts the specified range by the first column.

Sort(CellRange, IEnumerable<SortField>)

Sorts the specified range by multiple columns.

Sort(CellRange, Int32)

Sorts the specified range by the specified column in ascending order.

Sort(CellRange, Int32, Boolean)

Sorts the specified range by the specified column.

Sort(CellRange, Int32, IComparer<CellValue>)

Sorts the specified range by the specified column using the specified comparer.

Subtotal(CellRange, Int32, List<Int32>, Int32, String)

Creates subtotals for the specified range of cells.

UnMergeCells(CellRange)

Unmerges the specified cells that have been merged.

UnfreezePanes()

Unfreezes rows and columns on the worksheet.

Unprotect(String)

Removes protection from a worksheet.

See Also