idare.imagenode.internal.DataSetReaders.CSVReader

Class CSVCell

java.lang.Object

idare.imagenode.internal.DataSetReaders.CSVReader.CSVCell

All Implemented Interfaces:

org.apache.poi.ss.usermodel.Cell

public class CSVCell
extends Object
implements org.apache.poi.ss.usermodel.Cell

A implementation of a Cell for use in CSV files. A csv cell can only ever contain numeric, blank or string values. and will act as such.

Author:

Thomas Pfau

Field Summary

Fields inherited from interface org.apache.poi.ss.usermodel.Cell

CELL_TYPE_BLANK, CELL_TYPE_BOOLEAN, CELL_TYPE_ERROR, CELL_TYPE_FORMULA, CELL_TYPE_NUMERIC, CELL_TYPE_STRING

Constructor Summary

Constructors

Constructor and Description
CSVCell(int type, CSVRow row) Create a new cell with of a specific type and in a specific row.

Method Summary

Modifier and Type	Method and Description
org.apache.poi.ss.util.CellRangeAddress	getArrayFormulaRange()
boolean	getBooleanCellValue()
int	getCachedFormulaResultType()
org.apache.poi.ss.usermodel.Comment	getCellComment()
String	getCellFormula()
org.apache.poi.ss.usermodel.CellStyle	getCellStyle()
int	getCellType()
int	getColumnIndex()
Date	getDateCellValue()
byte	getErrorCellValue()
org.apache.poi.ss.usermodel.Hyperlink	getHyperlink()
double	getNumericCellValue()
org.apache.poi.ss.usermodel.RichTextString	getRichStringCellValue()
org.apache.poi.ss.usermodel.Row	getRow()
int	getRowIndex()
org.apache.poi.ss.usermodel.Sheet	getSheet()
String	getStringCellValue()
boolean	isPartOfArrayFormulaGroup()
void	removeCellComment()
void	setAsActiveCell()
void	setCellComment(org.apache.poi.ss.usermodel.Comment arg0)
void	setCellErrorValue(byte arg0)
void	setCellFormula(String arg0)
void	setCellStyle(org.apache.poi.ss.usermodel.CellStyle arg0)
void	setCellType(int arg0)
void	setCellValue(boolean arg0)
void	setCellValue(Calendar arg0)
void	setCellValue(Date arg0)
void	setCellValue(double arg0)
void	setCellValue(org.apache.poi.ss.usermodel.RichTextString arg0)
void	setCellValue(String arg0)
void	setHyperlink(org.apache.poi.ss.usermodel.Hyperlink arg0)
String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CSVCell

public CSVCell(int type,
               CSVRow row)

Create a new cell with of a specific type and in a specific row.

Parameters:

type - the type of the row

row - the CSVRow containing the cell

Method Detail

getArrayFormulaRange

public org.apache.poi.ss.util.CellRangeAddress getArrayFormulaRange()

Specified by:

getArrayFormulaRange in interface org.apache.poi.ss.usermodel.Cell

getBooleanCellValue

public boolean getBooleanCellValue()

Specified by:

getBooleanCellValue in interface org.apache.poi.ss.usermodel.Cell

getCachedFormulaResultType

public int getCachedFormulaResultType()

Specified by:

getCachedFormulaResultType in interface org.apache.poi.ss.usermodel.Cell

getCellComment

public org.apache.poi.ss.usermodel.Comment getCellComment()

Specified by:

getCellComment in interface org.apache.poi.ss.usermodel.Cell

getCellFormula

public String getCellFormula()

Specified by:

getCellFormula in interface org.apache.poi.ss.usermodel.Cell

getCellStyle

public org.apache.poi.ss.usermodel.CellStyle getCellStyle()

Specified by:

getCellStyle in interface org.apache.poi.ss.usermodel.Cell

getCellType

public int getCellType()

Specified by:

getCellType in interface org.apache.poi.ss.usermodel.Cell

getColumnIndex

public int getColumnIndex()

Specified by:

getColumnIndex in interface org.apache.poi.ss.usermodel.Cell

getDateCellValue

public Date getDateCellValue()

Specified by:

getDateCellValue in interface org.apache.poi.ss.usermodel.Cell

getErrorCellValue

public byte getErrorCellValue()

Specified by:

getErrorCellValue in interface org.apache.poi.ss.usermodel.Cell

getHyperlink

public org.apache.poi.ss.usermodel.Hyperlink getHyperlink()

Specified by:

getHyperlink in interface org.apache.poi.ss.usermodel.Cell

getNumericCellValue

public double getNumericCellValue()

Specified by:

getNumericCellValue in interface org.apache.poi.ss.usermodel.Cell

getRichStringCellValue

public org.apache.poi.ss.usermodel.RichTextString getRichStringCellValue()

Specified by:

getRichStringCellValue in interface org.apache.poi.ss.usermodel.Cell

getRow

public org.apache.poi.ss.usermodel.Row getRow()

Specified by:

getRow in interface org.apache.poi.ss.usermodel.Cell

getRowIndex

public int getRowIndex()

Specified by:

getRowIndex in interface org.apache.poi.ss.usermodel.Cell

getSheet

public org.apache.poi.ss.usermodel.Sheet getSheet()

Specified by:

getSheet in interface org.apache.poi.ss.usermodel.Cell

getStringCellValue

public String getStringCellValue()

Specified by:

getStringCellValue in interface org.apache.poi.ss.usermodel.Cell

isPartOfArrayFormulaGroup

public boolean isPartOfArrayFormulaGroup()

Specified by:

isPartOfArrayFormulaGroup in interface org.apache.poi.ss.usermodel.Cell

removeCellComment

public void removeCellComment()

Specified by:

removeCellComment in interface org.apache.poi.ss.usermodel.Cell

setAsActiveCell

public void setAsActiveCell()

Specified by:

setAsActiveCell in interface org.apache.poi.ss.usermodel.Cell

setCellComment

public void setCellComment(org.apache.poi.ss.usermodel.Comment arg0)

Specified by:

setCellComment in interface org.apache.poi.ss.usermodel.Cell

setCellErrorValue

public void setCellErrorValue(byte arg0)

Specified by:

setCellErrorValue in interface org.apache.poi.ss.usermodel.Cell

setCellFormula

public void setCellFormula(String arg0)
                    throws org.apache.poi.ss.formula.FormulaParseException

Specified by:

setCellFormula in interface org.apache.poi.ss.usermodel.Cell

Throws:

org.apache.poi.ss.formula.FormulaParseException

setCellStyle

public void setCellStyle(org.apache.poi.ss.usermodel.CellStyle arg0)

Specified by:

setCellStyle in interface org.apache.poi.ss.usermodel.Cell

setCellType

public void setCellType(int arg0)

Specified by:

setCellType in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(double arg0)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(Date arg0)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(Calendar arg0)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(org.apache.poi.ss.usermodel.RichTextString arg0)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(String arg0)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setCellValue

public void setCellValue(boolean arg0)

Specified by:

setCellValue in interface org.apache.poi.ss.usermodel.Cell

setHyperlink

public void setHyperlink(org.apache.poi.ss.usermodel.Hyperlink arg0)

Specified by:

setHyperlink in interface org.apache.poi.ss.usermodel.Cell

toString

public String toString()

Overrides:

toString in class Object