org.jxls.common

Class CellData

java.lang.Object

org.jxls.common.CellData

public class CellData
extends Object

Represents an Excel cell data holder and cell value evaluator

Author:

Leonid Vysochyn

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	CellData.CellType
static class	CellData.FormulaStrategy

Field Summary

Fields

Modifier and Type	Field and Description
protected XlsArea	area
protected CellRef	cellRef
protected CellData.CellType	cellType
protected Object	cellValue
protected Object	evaluationResult
protected String	formula
static String	JX_PARAMS_PREFIX
protected CellData.CellType	targetCellType

Constructor Summary

Constructors

Constructor and Description
CellData(CellRef cellRef)
CellData(CellRef cellRef, CellData.CellType cellType, Object cellValue)
CellData(String sheetName, int row, int col)
CellData(String sheetName, int row, int col, CellData.CellType cellType, Object cellValue)

Method Summary

Modifier and Type	Method and Description
void	addTargetParentAreaRef(AreaRef areaRef)
boolean	addTargetPos(CellRef cellRef)
boolean	equals(Object o)
Object	evaluate(Context context)
XlsArea	getArea()
Map<String,String>	getAttrMap()
String	getCellComment()
CellRef	getCellRef()
CellData.CellType	getCellType()
Object	getCellValue()
int	getCol()
String	getDefaultValue()
List<String>	getEvaluatedFormulas()
String	getFormula()
CellData.FormulaStrategy	getFormulaStrategy()
int	getRow()
String	getSheetName()
List<AreaRef>	getTargetParentAreaRef()
List<CellRef>	getTargetPos()
Transformer	getTransformer()
int	hashCode()
boolean	isFormulaCell()
boolean	isJointedFormulaCell()
protected boolean	isJxlsParamsComment(String cellComment)
boolean	isParameterizedFormulaCell()
protected void	processJxlsParams(String cellComment) The method parses jx:params attribute from a cell comment
void	resetTargetPos()
void	setArea(XlsArea area)
void	setAttrMap(Map<String,String> attrMap)
void	setCellComment(String cellComment)
void	setCellType(CellData.CellType cellType)
void	setDefaultValue(String defaultValue)
void	setEvaluatedFormulas(List<String> evaluatedFormulas)
void	setEvaluationResult(Object evaluationResult)
void	setFormula(String formula)
void	setFormulaStrategy(CellData.FormulaStrategy formulaStrategy)
void	setTransformer(Transformer transformer)
String	toString()
protected void	updateFormulaValue()

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

JX_PARAMS_PREFIX

public static final String JX_PARAMS_PREFIX

See Also:

Constant Field Values

cellRef

protected CellRef cellRef

cellValue

protected Object cellValue

cellType

protected CellData.CellType cellType

formula

protected String formula

evaluationResult

protected Object evaluationResult

targetCellType

protected CellData.CellType targetCellType

area

protected XlsArea area

Constructor Detail

CellData

public CellData(CellRef cellRef)

CellData

public CellData(String sheetName,
                int row,
                int col,
                CellData.CellType cellType,
                Object cellValue)

CellData

public CellData(CellRef cellRef,
                CellData.CellType cellType,
                Object cellValue)

CellData

public CellData(String sheetName,
                int row,
                int col)

Method Detail

updateFormulaValue

protected void updateFormulaValue()

getTransformer

public Transformer getTransformer()

setTransformer

public void setTransformer(Transformer transformer)

getArea

public XlsArea getArea()

setArea

public void setArea(XlsArea area)

getAttrMap

public Map<String,String> getAttrMap()

setAttrMap

public void setAttrMap(Map<String,String> attrMap)

setEvaluationResult

public void setEvaluationResult(Object evaluationResult)

getFormulaStrategy

public CellData.FormulaStrategy getFormulaStrategy()

setFormulaStrategy

public void setFormulaStrategy(CellData.FormulaStrategy formulaStrategy)

getDefaultValue

public String getDefaultValue()

setDefaultValue

public void setDefaultValue(String defaultValue)

getCellComment

public String getCellComment()

setCellComment

public void setCellComment(String cellComment)

isJxlsParamsComment

protected boolean isJxlsParamsComment(String cellComment)

getSheetName

public String getSheetName()

getCellRef

public CellRef getCellRef()

getCellType

public CellData.CellType getCellType()

setCellType

public void setCellType(CellData.CellType cellType)

getCellValue

public Object getCellValue()

getRow

public int getRow()

getCol

public int getCol()

getFormula

public String getFormula()

setFormula

public void setFormula(String formula)

getEvaluatedFormulas

public List<String> getEvaluatedFormulas()

isFormulaCell

public boolean isFormulaCell()

isParameterizedFormulaCell

public boolean isParameterizedFormulaCell()

isJointedFormulaCell

public boolean isJointedFormulaCell()

addTargetPos

public boolean addTargetPos(CellRef cellRef)

addTargetParentAreaRef

public void addTargetParentAreaRef(AreaRef areaRef)

getTargetParentAreaRef

public List<AreaRef> getTargetParentAreaRef()

setEvaluatedFormulas

public void setEvaluatedFormulas(List<String> evaluatedFormulas)

getTargetPos

public List<CellRef> getTargetPos()

Returns:

a list of cell refs into which the current cell was transformed

resetTargetPos

public void resetTargetPos()

evaluate

public Object evaluate(Context context)

processJxlsParams

protected void processJxlsParams(String cellComment)

The method parses jx:params attribute from a cell comment

jx:params can be used e.g.

• to set CellData.FormulaStrategy via 'formulaStrategy' param
• to set the formula default value via 'defaultValue' param

Parameters:

cellComment - the comment string

toString

public String toString()

Overrides:

toString in class Object

equals

public boolean equals(Object o)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object