Click or drag to resize
ExcelCell Class
Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
Inheritance Hierarchy

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1033
Syntax
public sealed class ExcelCell : AbstractRange

The ExcelCell type exposes the following members.

Properties
  NameDescription
Public propertyBoolValue
Gets the boolean value of this cell or of merged range if this cell is merged.
Public propertyColumn
Gets column of the cell.
Public propertyCode exampleComment
Gets or sets cell comment.
(Overrides AbstractRangeComment.)
Public propertyDateTimeValue
Gets the DateTime value of this cell or of merged range if this cell is merged.
Public propertyDoubleValue
Gets the double value of this cell or of merged range if this cell is merged.
Public propertyCode exampleFormula
Gets or sets cell formula string.
(Overrides AbstractRangeFormula.)
Public propertyHyperlink
Gets or sets cell hyperlink.
(Overrides AbstractRangeHyperlink.)
Public propertyIntValue
Gets the integer value of this cell or of merged range if this cell is merged.
Public propertyIsStyleDefault Obsolete.
Returns if all cells in AbstractRange have default cell style; otherwise, .
(Inherited from AbstractRange.)
Public propertyMergedRange
Returns associated merged range if the cell is merged; otherwise, .
Public propertyName
Gets the name of AbstractRange instance.
(Inherited from AbstractRange.)
Public propertyRow
Gets row of the cell.
Public propertyStringValue
Gets the string value of this cell or of merged range if this cell is merged.
Public propertyCode exampleStyle
Gets or sets the cell formatting of one or more cells.
(Inherited from AbstractRange.)
Public propertyValue
Gets or sets value of this cell or of merged range if this cell is merged.
(Overrides AbstractRangeValue.)
Public propertyValueType
Gets the cell value type.
Public propertyWorksheet
Gets the parent worksheet.
Top
Methods
  NameDescription
Public methodCalculate
Calculates formula for this excel cell.
(Overrides AbstractRangeCalculate.)
Public methodClear
Clears the range (content, formatting, comment, hyperlink or all).
(Inherited from AbstractRange.)
Public methodStatic memberConvertExcelNumberToDateTime
Converts Excel floating-point number to DateTime structure.
Public methodEquals
Determines whether the specified Object is equal to this ExcelCell instance.
(Overrides ObjectEquals(Object).)
Public methodGetCharacters(Int32)
Returns a FormattedCharacterRange object that represents a range of characters within the cell text. The range starts at a specified character position. Not supported in ODS and XLS.
(Inherited from AbstractRange.)
Public methodGetCharacters(Int32, Int32)
Returns a FormattedCharacterRange object that represents a range of characters within the cell text. The range starts at a specified character position and has a specified length. Not supported in ODS and XLS.
(Inherited from AbstractRange.)
Public methodGetFormattedValue
Converts cell value of this ExcelCell instance to string representation using number format that is specified on this ExcelCell instance.
Public methodGetHashCode
Returns a hash code for this ExcelCell instance.
(Overrides ObjectGetHashCode.)
Public methodReplaceText(String, String)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
(Inherited from AbstractRange.)
Public methodReplaceText(String, String, Boolean)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
(Inherited from AbstractRange.)
Public methodReplaceText(String, String, Boolean, Boolean)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
(Inherited from AbstractRange.)
Public methodSetBorders Obsolete.
Sets borders on one or more excel cells, taking cell position into account.
(Inherited from AbstractRange.)
Public methodSetValue(Boolean)
Sets the boolean value to this cell or to merged range if this cell is merged.
Public methodSetValue(DateTime)
Sets the DateTime value to this cell or to merged range if this cell is merged.
Public methodSetValue(Double)
Sets the double value to this cell or to merged range if this cell is merged.
Public methodSetValue(Int32)
Sets the integer value to this cell or to merged range if this cell is merged.
Public methodSetValue(String)
Sets the string value to this cell or to merged range if this cell is merged.
Public methodSetValue(String, HtmlLoadOptions)
Loads the specified HTML text as the value of this ExcelCell.
Public methodToString
Returns a String that represents this AbstractRange instance.
(Inherited from AbstractRange.)
Top
Operators
  NameDescription
Public operatorStatic memberEquality
Determines whether first and second ExcelCells are equal.
Public operatorStatic memberInequality
Determines whether first and second ExcelCells are not equal.
Top
Remarks

Merged range is created by using CellRange.Merged property. See the property documentation for more information on merging.

See Also