Example usage for Java org.apache.poi.xssf.usermodel XSSFCell fields, constructors, methods, implement or subclass
The text is from its open source code.
boolean | getBooleanCellValue() Get the value of the cell as a boolean. |
CellType | getCachedFormulaResultType() Only valid for formula cells |
XSSFComment | getCellComment() Returns cell comment associated with this cell |
String | getCellFormula() Return a formula for the cell, for example, SUM(C4:E4) |
XSSFCellStyle | getCellStyle() Return the cell's style. |
CellType | getCellType() Return the cell type. |
CellType | getCellTypeEnum() |
int | getColumnIndex() Returns column index of this cell |
CTCell | getCTCell() Returns the xml bean containing information about the cell's location (reference), value, data type, formatting, and formula |
Date | getDateCellValue() Get the value of the cell as a date. |
String | getErrorCellString() Returns the error message, such as #VALUE! |
byte | getErrorCellValue() Get the value of the cell as an error code. |
XSSFHyperlink | getHyperlink() Returns hyperlink associated with this cell |
double | getNumericCellValue() Get the value of the cell as a number. |
String | getRawValue() Returns the raw, underlying ooxml value for the cell If the cell contains a string, then this value is an index into the shared string table, pointing to the actual string value. |
String | getReference() Returns an A1 style reference to the location of this cell |
XSSFRichTextString | getRichStringCellValue() Get the value of the cell as a XSSFRichTextString For numeric cells we throw an exception. |
int | getRowIndex() Returns row index of a row in the sheet that contains this cell |
XSSFSheet | getSheet() Returns the sheet this cell belongs to |
String | getStringCellValue() Get the value of the cell as a string For numeric cells we throw an exception. |
void | removeCellComment() Removes the comment for this cell, if there is one. |
void | setCellComment(Comment comment) Assign a comment to this cell. |
void | setCellErrorValue(byte errorCode) Set a error value for the cell |
void | setCellErrorValue(FormulaError error) Set a error value for the cell |
void | setCellFormula(String formula) |
void | setCellStyle(CellStyle style) Set the style for the cell. |
void | setCellType(CellType cellType) |
void | setCellValue(boolean value) Set a boolean value for the cell |
void | setHyperlink(Hyperlink hyperlink) Assign a hyperlink to this cell. |
String | toString() Returns a string representation of the cell Formula cells return the formula string, rather than the formula result. |