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+
Row

Cell Members

A single cell in a worksheet.

Properties

Name Description
Alignment

Provides access to cell alignment.

(Inherited from Formatting)
Areas

Provides access to the ranges that comprise a complex (union) range.

(Inherited from Range)
ArrayFormula

Gets or sets the array formula associated with the cell or cell range.

(Inherited from Range)
ArrayFormulaInvariant

Gets or sets the array formula in the invariant culture.

(Inherited from Range)
Borders

Provides access to cell borders.

(Inherited from Formatting)
BottomRowIndex

Gets the index of the row that includes the bottom edge of the cell range.

(Inherited from Range)
ColumnCount

Gets the number of columns in the cell range.

(Inherited from Range)
ColumnIndex

Gets the index of the column that contains the current cell.

ColumnWidth

Gets or sets the width of columns that comprise the cell range in units of measurement used in the workbook.

(Inherited from Range)
ColumnWidthInCharacters

Gets or sets the width of columns that contain the cell range in characters of the default font specified by the built-in Normal style.

(Inherited from Range)
CurrentRegion

Gets a range with non-empty cells surrounded by empty rows and columns.

(Inherited from Range)
Dependents

Gets a list of ranges (cells) whose formulas refer to the current range or cell, directly or indirectly (at any level).

(Inherited from Range)
DirectDependents

Gets a list of ranges (cells) whose formulas use the current range or cell.

(Inherited from Range)
DirectPrecedents

Gets a list of ranges (cells) that are directly referred to in the formulas in the current cell or range.

(Inherited from Range)
DisplayText

Gets the string that specifies the formatted cell value as it is displayed.

ExistingCells

Gets the existing cells in the current cell range.

(Inherited from Range)
Fill

Provides access to cell background.

(Inherited from Formatting)
FillColor

Gets or sets the cell background color.

(Inherited from Range)
Flags

Provides access to flags that control which cell format attributes are specified by the applied cell style and which ones are specified by direct cell formatting.

(Inherited from Formatting)
Font

Provides access to the cell font.

(Inherited from Formatting)
Formula

Gets or sets the formula contained in the cell or cell range.

(Inherited from Range)
FormulaInvariant

Gets or sets the range formula in the invariant culture.

(Inherited from Range)
HasArrayFormula

Determines whether the current cell or cell range intersects a range filled with an array formula.

(Inherited from Range)
HasFormula

Determines whether all cells in the range contain a formula.

(Inherited from Range)
HasQuotePrefix

Indicates whether or not the cell value is prefixed with a single quote.

HasRichText

Gets a value indicating whether a cell contains rich formatted text.

(Inherited from Range)
IsDisplayedAsDateTime

Indicates whether a numeric value contained in the cell is displayed as a date and time value.

IsMerged

Determines whether the range is created by merging cells.

(Inherited from Range)
IsTopLeftCellInArrayFormulaRange

Indicates whether the current cell is the top left cell in the array formula range.

Item[Int32, Int32]

Gets an individual cell by row and column offsets from the top left cell of the current range.

(Inherited from Range)
Item[Int32]

Gets an individual cell by its index in the range of cells.

(Inherited from Range)
LeftColumnIndex

Gets the index of the column that includes the left edge of the cell range.

(Inherited from Range)
Name

Gets or sets the name of the cell range.

(Inherited from Range)
NumberFormat

Gets or sets a number format that specifies how a numeric value is displayed in a cell.

(Inherited from Formatting)
ParsedExpression

Gets or sets the expression tree from which the formula entered in the cell is built.

Precedents

Gets a list of ranges (cells) that are used by a formula in the current cell or range.

(Inherited from Range)
Protection

Provides access to options which are in effect when the worksheet is protected.

(Inherited from Formatting)
RightColumnIndex

Gets the index of the column that includes the right edge of the cell range.

(Inherited from Range)
RowCount

Gets the number of rows in the cell range.

(Inherited from Range)
RowHeight

Gets or sets the height of rows that contain the cell range.

(Inherited from Range)
RowIndex

Gets the index of the row that contains the current cell.

Style

Gets or sets the style applied to the current range of cells.

(Inherited from Range)
Tag

Gets or sets custom data associated with the current cell.

TopRowIndex

Gets the index of the row that includes the top edge of the cell range.

(Inherited from Range)
Value

Gets or sets a cell value.

(Inherited from Range)
Worksheet

Gets the worksheet that contains the cell range.

(Inherited from Range)

Methods

Name Description
BeginUpdate()

Locks the Formatting object by preventing visual updates until the EndUpdate method is called.

(Inherited from Formatting)
BeginUpdateFormatting()

Starts modifying the cell range formatting.

(Inherited from Range)
Calculate()

Forces recalculation of the current cell range.

(Inherited from Range)
CopyFrom(Range)

Copies the specified range of cells into the current range.

(Inherited from Range)
CopyFrom(Range, PasteSpecial)

Copies the source range of cells and pastes the specified part of the copied data into the current cell range.

(Inherited from Range)
CopyFrom(Range, PasteSpecial, Boolean)

Copies the source range of cells and pastes the specified part of the copied data into the current cell range.

(Inherited from Range)
EndUpdate()

Unlocks the Formatting object after a call to the BeginUpdate method and causes an immediate visual update.

(Inherited from Formatting)
EndUpdateFormatting(Formatting)

Finalizes the modification of the cell range formatting after calling the Range.BeginUpdateFormatting method.

(Inherited from Range)
Equals(Object)

Determines whether or not the specified object is equal to the current Formatting instance.

(Inherited from Formatting)
Exclude(Range)

Excludes the specified cell or cell range from the current range.

(Inherited from Range)
GetArrayFormulaRange()

Gets the entire range filled with an array formula, if the cell belongs to that range.

GetDataSource()

Creates the data source from the current cell range.

(Inherited from Range)
GetDataSource(RangeDataSourceOptions)

Creates the data source from the current cell range using the specified options.

(Inherited from Range)
GetDefinedName()

Returns a defined name associated with the current range.

(Inherited from Range)
GetDefinedName(DefinedNameScope)

Returns a defined name declared in the specified scope and associated with the current cell range.

(Inherited from Range)
GetEnumerator() Returns an enumerator that iterates through the collection.
(Inherited from IEnumerable<T>)
GetMergedRanges()

Returns merged ranges intersecting the current cell range.

(Inherited from Range)
GetMinimumCover()

Returns the cell range that covers the current range and does not contain the intersecting ranges.

(Inherited from Range)
GetRangeWithAbsoluteReference()

Returns the copy of the source range with its reference replaced by the absolute reference.

(Inherited from Range)
GetRangeWithRelativeReference()

Returns the copy of the source range with its reference replaced by the relative reference.

(Inherited from Range)
GetReferenceA1()

Gets the relative cell or cell range reference in the A1 reference style.

(Inherited from Range)
GetReferenceA1(ReferenceElement)

Gets the cell or cell range reference in the A1 reference style.

(Inherited from Range)
GetReferenceR1C1(Cell)

Gets the relative cell or cell range reference in the R1C1 reference style.

(Inherited from Range)
GetReferenceR1C1(ReferenceElement, Cell)

Gets the cell or cell range reference in the R1C1 reference style.

(Inherited from Range)
GetRichText()

Gets the rich text string contained in a cell.

(Inherited from Range)
Intersect(Range)

Returns the cell range that is the intersection of the current and specified ranges.

(Inherited from Range)
IsIntersecting(Range)

Indicates whether the current range intersects with the specified range.

(Inherited from Range)
MoveTo(Range)

Moves a range to a specified location.

(Inherited from Range)
Offset(Int32, Int32)

Returns the cell range that is offset by the specified number of rows and columns from the current range.

(Inherited from Range)
Search(String)

Performs a search in the cell range using the default parameters.

(Inherited from Range)
Search(String, SearchOptions)

Performs a search in the cell range using specified options.

(Inherited from Range)
SetInsideBorders(Color, BorderLineStyle)

Sets all inside borders of the cell range.

(Inherited from Range)
SetRichText(RichTextString)

Assigns the rich formatted text to a cell.

(Inherited from Range)
SetValue(Object)

Converts the specified object to the cell value.

(Inherited from Range)
SetValueFromText(String)

Parses the supplied string and creates a cell value to assign it to the cells in the current range.

(Inherited from Range)
SetValueFromText(String, Boolean)

Parses the supplied string and creates a cell value to assign it to the cells in the current range.

(Inherited from Range)
Union(Range)

Creates a complex range that is the union of multiple ranges.

(Inherited from Range)
See Also