Skip to main content
Row

Cell Methods

A single cell in a worksheet.
Name Description
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.
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.
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 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>.
GetHtmlContent() Gets cell content as a string in HTML format.
GetHtmlContent(HtmlCellContentExportOptions) Gets cell content as a string in HTML format. Allows you to specify export options.
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.
GetRtfContent() Gets cell content as a string in RTF format.
GetRtfContent(RtfCellContentExportOptions) Gets cell content as a string in RTF format. Allows you to specify export options.
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