Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


com.aspose.cells
Class LightCell

java.lang.Object
  extended by com.aspose.cells.LightCell

public class LightCell
extends java.lang.Object

Wrapper for data of one cell, used for process spreadsheet file in Event-Driven access mode


Method Summary
 LightCell copy()
          create a new copy of this object.
 short getColumnIndex()
          Gets the column index of the cell.
 java.lang.String getFormula()
          get cell's formula.
 java.lang.String getFormulaRange()
          If this cell's formula is the master formula of shared formula, array formula or data table, return the range of cells which the formula applies to.
 byte getFormulaType()
          get the formula type.
 int getRowIndex()
          Gets the row index of the cell.
 java.lang.Object getValue()
          get cell's value.
 short getValueType()
          get type of cell value, see the value type defined in CellValueType.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getRowIndex

public int getRowIndex()
Gets the row index of the cell.

Returns:
row index of the cell.

getColumnIndex

public short getColumnIndex()
Gets the column index of the cell.

Returns:
column index of the cell.

getValueType

public short getValueType()
get type of cell value, see the value type defined in CellValueType.

Returns:
type of cell value

getValue

public java.lang.Object getValue()
get cell's value. Corresponding to valueType:
valueType value
CellValueType.BOOLEAN Boolean
CellValueType.INT Integer
CellValueType.DOUBLE Double
CellValueType.DATETIME Long
CellValueType.STRING String
CellValueType.ERROR String
CellValueType.NULL null
For value type as DATETIME, the long value is time in UTC milliseconds.

Returns:
cell's value

getFormula

public java.lang.String getFormula()
get cell's formula.

Returns:
cell's formula. null if it is not a formula

getFormulaRange

public java.lang.String getFormulaRange()
If this cell's formula is the master formula of shared formula, array formula or data table, return the range of cells which the formula applies to. otherwise return null. Only applied for master formula of shared formula, array formula or data table, subsequent cells whose formula belonging to the same shared group, array, or data table will return null.

Returns:
the range of cells which the shared formula, array formula or data table applies to.

getFormulaType

public byte getFormulaType()
get the formula type. see FormulaType

Returns:
type of cell's formula

copy

public LightCell copy()
create a new copy of this object.

Returns:
new copy of this object