Click or drag to resize

ExcelCell Methods

The ExcelCell type exposes the following members.

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
See Also