Search
Cell Members
Methods
 


Identifies a single cell in a Worksheet.

The following tables list the members exposed by the Cell type.

 Public Methods

  Name Description

clear

Clears the contents of this cell.

equals

 

getAnnotation

Gets the Annotation object that represents a comment for this cell.

getColumn

Gets the zero-based index of the column of the represented cell.

getConditionalFormats

Gets a list with format objects that can be used to customize the appearance of the cell based on various conditions.

getData

Gets or sets the cell data.

getHyperlink

Gets a Hyperlink object that represents the hyperlink associated with this cell.

getLocale

Gets the locale used to format the value of this cell.

getRow

Gets the zero-based index of the row of the represented cell.

getStyle

Gets an IStyle object that can be used to customize the appearance of the cell.

getValidation

Gets an IValidation object that can be used to specify validation rules for the data in the cell.

getValue

Gets the effective value of this cell. If the cell contains a formula, this property should return the result of the formula evaluation.

getWorksheet

Gets the worksheet this cell belongs to.

hashCode

 

isEditable

Gets a value indicating whether this cell is editable.

isHidden

Gets a value indicating whether this cell belongs to a hidden column or row.

isMerged

Gets a value indicating whether this cell is part of a merged cell.

removeAnnotation

Removes an annotation object from the cell.

removeHyperlink

Removes the hyperlink associated with this cell.

reset

Clears the cell contents, as well as its associated style, hyperlink, annotation, conditional formatting and data validations.

setAnnotation

Sets the text of the annotation object, associated with this cell.

setData

Overloaded. Sets the cell data.

setEditable

Sets a value indicating whether this cell is editable.

setHyperlink

Overloaded. Sets a hyperlink, associated with the cell.

setLocale

Sets the locale used to format the value of this cell.

toString

 

valueAs

Down-casts the cell value to specified type.

 See Also