Skip to main content

Row Members

A row 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 CellRange.
ArrayFormula Gets or sets the array formula associated with the cell or cell range. Inherited from CellRange.
ArrayFormulaInvariant Gets or sets the array formula in the invariant culture. Inherited from CellRange.
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 CellRange.
ColumnCount Gets the number of columns in the cell range. Inherited from CellRange.
ColumnWidth Gets or sets the width of columns that contain this cell range. Inherited from CellRange.
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 CellRange.
CurrentRegion Gets a range with non-empty cells surrounded by empty rows and columns. Inherited from CellRange.
Dependents Gets a list of ranges (cells) whose formulas refer to the current range or cell, directly or indirectly (at any level). Inherited from CellRange.
DirectDependents Gets a list of ranges (cells) whose formulas use the current range or cell. Inherited from CellRange.
DirectPrecedents Gets a list of ranges (cells) that are directly referred to in the formulas in the current cell or range. Inherited from CellRange.
DynamicArrayFormula Gets or sets the dynamic array formula associated with the cell or cell range. Inherited from CellRange.
DynamicArrayFormulaInvariant Gets or sets the dynamic array formula in the invariant culture. Inherited from CellRange.
ExistingCells Gets the existing cells in the current cell range. Inherited from CellRange.
Fill Provides access to cell background. Inherited from Formatting.
FillColor Gets or sets the cell background color. Inherited from CellRange.
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 CellRange.
FormulaInvariant Gets or sets the range formula in the invariant culture. Inherited from CellRange.
GroupLevel Gets the grouping level of the affected row.
HasArrayFormula Determines whether the current cell or cell range intersects a range filled with a legacy array formula. Inherited from CellRange.
HasData Checks whether the current cell range contains data. Inherited from CellRange.
HasDynamicArrayFormula Determines whether the current cell or cell range intersects a range filled with a dynamic array formula. Inherited from CellRange.
HasFormula Determines whether all cells in the range contain a formula. Inherited from CellRange.
HasRichText Gets a value indicating whether a cell contains rich formatted text. Inherited from CellRange.
Heading Gets the heading of the individual row on a worksheet.
Height Gets or sets the row height.
Index Gets the zero-based index of the row within the worksheet’s RowCollection.
IsFiltered Gets a value indicting whether the current row belongs to a table or cell range to which filtering is applied.
IsMerged Determines whether the range is created by merging cells. Inherited from CellRange.
Item[Int32, Int32] Gets an individual cell by row and column offsets from the top left cell of the current range. Inherited from CellRange.
Item[Int32] Provides access to an individual cell located at the intersection of the current row and the specified column.
Item[String] Provides access to an individual cell located at the intersection of the current row and the specified column.
LeftColumnIndex Gets the index of the column that includes the left edge of the cell range. Inherited from CellRange.
Name Gets or sets the name of the cell range. Inherited from CellRange.
NumberFormat Specifies a number format for a numeric cell value in the invariant culture. Inherited from Formatting.
NumberFormatLocal Specifies a number format for a numeric cell value based on the current (local) culture. Inherited from Formatting.
Precedents Gets a list of ranges (cells) that are used by a formula in the current cell or range. Inherited from CellRange.
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 CellRange.
RowCount Gets the number of rows in the cell range. Inherited from CellRange.
RowHeight Gets or sets the height of rows that contain this cell range. Inherited from CellRange.
Style Gets or sets the style applied to the current range of cells. Inherited from CellRange.
TopRowIndex Gets the index of the row that includes the top edge of the cell range. Inherited from CellRange.
Value Gets or sets a cell value. Inherited from CellRange.
Visible Gets or sets whether the row is visible or hidden.
Worksheet Gets the worksheet that contains the cell range. Inherited from CellRange.

Methods

Name Description
AutoFit() Adjusts the row height to accommodate cell content.
BeginUpdate() Locks the Formatting object. Prevents visual updates until the EndUpdate method calls. Inherited from Formatting.
BeginUpdateFormatting() Starts modifying the cell range formatting. Inherited from CellRange.
Calculate() Forces recalculation of the current cell range. Inherited from CellRange.
Contains(CellRange) Determines whether the current cell range contains the specified range. Inherited from CellRange.
CopyFrom(CellRange, PasteSpecial, Boolean) Copies the source range of cells and pastes the specified part of the copied data into the current cell range. Inherited from CellRange.
CopyFrom(CellRange, PasteSpecial) Copies the source range of cells and pastes the specified part of the copied data into the current cell range. Inherited from CellRange.
CopyFrom(CellRange) Copies the specified range of cells into the current range. Inherited from CellRange.
Delete() Deletes a row from a worksheet.
EndUpdate() Unlocks the Formatting object after you call BeginUpdate. It also causes an immediate visual update. Inherited from Formatting.
EndUpdateFormatting(Formatting) Finalizes the modification of the cell range formatting after calling the CellRange.BeginUpdateFormatting method. Inherited from CellRange.
Equals(Object) Determines whether or not the specified object is equal to the current Formatting instance. Inherited from Formatting.
Exclude(CellRange) Excludes the specified cell or cell range from the current range. Inherited from CellRange.
GetDataSource() Creates the data source from the current cell range. Inherited from CellRange.
GetDataSource(RangeDataSourceOptions) Creates the data source from the current cell range using the specified options. Inherited from CellRange.
GetDefinedName() Returns a defined name associated with the current range. Inherited from CellRange.
GetDefinedName(DefinedNameScope) Returns a defined name declared in the specified scope and associated with the current cell range. Inherited from CellRange.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
GetMergedRanges() Returns merged ranges intersecting the current cell range. Inherited from CellRange.
GetMinimumCover() Returns the cell range that covers the current range and does not contain the intersecting ranges. Inherited from CellRange.
GetRangeWithAbsoluteReference() Returns the copy of the source range with its reference replaced by the absolute reference. Inherited from CellRange.
GetRangeWithRelativeReference() Returns the copy of the source range with its reference replaced by the relative reference. Inherited from CellRange.
GetReferenceA1() Gets the relative cell or cell range reference in the A1 reference style. Inherited from CellRange.
GetReferenceA1(ReferenceElement) Gets the cell or cell range reference in the A1 reference style. Inherited from CellRange.
GetReferenceR1C1(Cell) Gets the relative cell or cell range reference in the R1C1 reference style. Inherited from CellRange.
GetReferenceR1C1(ReferenceElement, Cell) Gets the cell or cell range reference in the R1C1 reference style. Inherited from CellRange.
GetRichText() Gets the rich text string contained in a cell. Inherited from CellRange.
Insert() Inserts a new row into the worksheet.
Intersect(CellRange) Returns the cell range that is the intersection of the current and specified ranges. Inherited from CellRange.
IsIntersecting(CellRange) Determines whether the current range intersects with the specified range. Inherited from CellRange.
MoveTo(CellRange) Moves a range to a specified location. Inherited from CellRange.
Offset(Int32, Int32) Returns a cell range that is a given number of rows and columns from the current range. Inherited from CellRange.
Resize(Int32, Int32) Resizes the current cell range. Inherited from CellRange.
Search(String, SearchOptions) Performs a search in the cell range using specified options. Inherited from CellRange.
Search(String) Performs a search in the cell range using the default parameters. Inherited from CellRange.
SetInsideBorders(Color, BorderLineStyle) Sets all inside borders of the cell range. Inherited from CellRange.
SetRichText(RichTextString) Assigns the rich formatted text to a cell. Inherited from CellRange.
SetValue(Object) Converts the specified object to the cell value. Inherited from CellRange.
SetValueFromText(String, Boolean) Parses the supplied string and creates a cell value to assign it to the cells in the current range. Inherited from CellRange.
SetValueFromText(String) Parses the supplied string and creates a cell value to assign it to the cells in the current range. Inherited from CellRange.
Union(CellRange) Creates a complex range that is the union of multiple ranges. Inherited from CellRange.
See Also