Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+

Row Methods

A row in a worksheet.
Name Description
AutoFit() Adjusts the row height to accommodate cell content.
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, 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.
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) Copies the specified range of cells into the current range. Inherited from Range.
Delete() Deletes a row from a worksheet.
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.
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.
Insert() Inserts a new row into the worksheet.
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, SearchOptions) Performs a search in the cell range using specified options. Inherited from Range.
Search(String) Performs a search in the cell range using the default parameters. 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, Boolean) Parses the supplied string and creates a cell value to assign it to the cells in the current range. 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.
Union(Range) Creates a complex range that is the union of multiple ranges. Inherited from Range.
See Also