/** * Get the value of the cell as a string * <p> * For numeric cells we throw an exception. For blank cells we return an empty string. * For formulaCells that are not string Formulas, we throw an exception * </p> * @return the value of the cell as a string */ @Override public String getStringCellValue() { return getRichStringCellValue().getString(); }
@Override public String getStringCellValue() { return _cell.getRichStringCellValue().getString(); }
return getRichStringCellValue().toString(); case FORMULA: return getCellFormula();
/** * Get the value of the cell as a string * <p> * For numeric cells we throw an exception. For blank cells we return an empty string. * For formulaCells that are not string Formulas, we throw an exception * </p> * @return the value of the cell as a string */ public String getStringCellValue() { XSSFRichTextString str = getRichStringCellValue(); return str == null ? null : str.getString(); }
/** * Get the value of the cell as a string * <p> * For numeric cells we throw an exception. For blank cells we return an empty string. * For formulaCells that are not string Formulas, we throw an exception * </p> * @return the value of the cell as a string */ @Override public String getStringCellValue() { return getRichStringCellValue().getString(); }
public String getStringCellValue() { return _cell.getRichStringCellValue().getString(); } public int getCachedFormulaResultType() {
@Override public String getStringCellValue() { return _cell.getRichStringCellValue().getString(); }
System.out.println(cell.getRichStringCellValue().getString()); cellTempList.add(cell.getRichStringCellValue().getString()); break; case Cell.CELL_TYPE_NUMERIC:
System.out.println(cell.getRichStringCellValue().getString()); cellTempList.add(cell.getRichStringCellValue().getString()); break; case Cell.CELL_TYPE_NUMERIC:
break; case Cell.CELL_TYPE_STRING: value = cell.getRichStringCellValue().getString(); break; case Cell.CELL_TYPE_NUMERIC:
return getRichStringCellValue().toString(); case FORMULA: return getCellFormula();
/** * Returns a string representation of the cell * <p> * Formula cells return the formula string, rather than the formula result. * Dates are displayed in dd-MMM-yyyy format * Errors are displayed as #ERR<errIdx> * </p> */ public String toString() { switch (getCellType()) { case CELL_TYPE_BLANK: return ""; case CELL_TYPE_BOOLEAN: return getBooleanCellValue() ? "TRUE" : "FALSE"; case CELL_TYPE_ERROR: return ErrorEval.getText(getErrorCellValue()); case CELL_TYPE_FORMULA: return getCellFormula(); case CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(this)) { DateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy"); return sdf.format(getDateCellValue()); } return getNumericCellValue() + ""; case CELL_TYPE_STRING: return getRichStringCellValue().toString(); default: return "Unknown Cell Type: " + getCellType(); } }
break; case Cell.CELL_TYPE_STRING: value = cell.getRichStringCellValue().getString(); break; case Cell.CELL_TYPE_NUMERIC:
targetCell.setCellValue(sourceCell.getRichStringCellValue()); break; case HSSFCell.CELL_TYPE_NUMERIC:
XSSFCell cell = row.getCell(cellReference.getCol()); XSSFRichTextString cellText = cell.getRichStringCellValue();