Cell Methods

The Cell type exposes the following members.

Methods
  NameDescription
Public methodCalculate(CalculationOptions)
Calcaulate the formula of the cell.
Public methodCalculate(Boolean, ICustomFunction)
Calcaulate the formula of the cell.
Public methodCode exampleCharacters
Returns a Characters object that represents a range of characters within the cell text.
Public methodCopy
Copies data from a source cell.
Public methodEquals(Object)
Checks whether this object refers to the same cell with another.
(Overrides ObjectEquals(Object).)
Public methodEquals(Cell)
Checks whether this object refers to the same cell with another cell object.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetArrayRange
Gets the array range if the cell's formula is an array formula.
Public methodGetCharacters
Returns all Characters objects that represents a range of characters within the cell text.
Public methodGetCharacters(Boolean)
Returns all Characters objects that represents a range of characters within the cell text.
Public methodGetConditionalFormattingResult
Get the result of the conditional formatting.
Public methodGetDependents
Get all cells which refer to the specific cell.
Public methodGetDisplayStyle
Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
Public methodGetDisplayStyle(Boolean)
Gets the display style of the cell. If the cell is conditional formatted, the display style is not same as the cell.GetStyle().
Public methodGetFormatConditions
Gets format conditions which applies to this cell.
Public methodGetFormula
Get the formula of this cell.
Public methodGetHashCode
Serves as a hash function for a particular type.
(Overrides ObjectGetHashCode.)
Public methodGetHeightOfValue
Gets the height of the value in unit of pixels.
Public methodGetHtmlString
Gets the html string which contains data and some formats in this cell.
Public methodGetLeafs
Get all cells which will be updated when this cell is modified. This method can only work after calling Workbook.CalculateFormula.
Public methodGetMergedRange
Returns a Range object which represents a merged range.
Public methodCode exampleGetPrecedents
Gets all cells or ranges which this cell's formula depends on.
Public methodGetStringValue
Gets the string value by specific formatted strategy.
Public methodGetStyle
Gets the cell style.
Public methodGetStyle(Boolean)
If checkBorders is true, check whether other cells' borders will effect the style of this cell.
Public methodGetTable
Gets the table which contains this cell.
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodGetValidation
Gets the validation applied to this cell.
Public methodGetValidationValue
Gets the value of validation which applied to this cell.
Public methodGetWidthOfValue
Gets the width of the value in unit of pixels.
Public methodIsRichText
Indicates whether the cell string value is a rich text.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodPutValue(Boolean)
Puts an boolean value into the cell.
Public methodPutValue(DateTime)
Puts a DateTime value into the cell.
Public methodPutValue(Double)
Puts a double value into the cell.
Public methodPutValue(Int32)
Puts an integer value into the cell.
Public methodPutValue(Object)
Puts an object value into the cell.
Public methodPutValue(String)
Puts a string value into the cell.
Public methodPutValue(String, Boolean)
Puts a string value into the cell and converts the value to other data type if appropriate.
Public methodPutValue(String, Boolean, Boolean)
Puts a value into the cell, if appropriate the value will be converted to other data type and cell's number format will be reset.
Public methodRemoveArrayFormula
Remove array formula.
Public methodCode exampleSetAddInFormula Obsolete.
Sets an Add-In formula to the cell.
Public methodSetArrayFormula(String, Int32, Int32)
Sets an array formula to a range of cells.
Public methodSetArrayFormula(String, Int32, Int32, Boolean, Boolean)
Sets an array formula to a range of cells.
Public methodSetCharacters
Sets rich text format of the cell.
Public methodSetFormula(String, Object)
Set the formula and the value of the formula.
Public methodSetFormula(String, Boolean, Boolean, Object)
Set the formula and the value of the formula.
Public methodSetSharedFormula(String, Int32, Int32)
Sets a formula to a range of cells.
Public methodSetSharedFormula(String, Int32, Int32, Boolean, Boolean)
Sets a formula to a range of cells.
Public methodSetStyle(Style)
Sets the cell style.
Public methodSetStyle(Style, StyleFlag)
Apply the cell style.
Public methodSetStyle(Style, Boolean)
Apply the cell style.
Public methodToString
Returns a string represents the current Cell object.
(Overrides ObjectToString.)
See Also