private static void gettingTheCellContents(CellReference cellRef, Cell cell,
XSSFWorkbook workbook) {
DataFormatter formatter = new DataFormatter();
FormulaEvaluator formulaEvaluator =
workbook.getCreationHelper().createFormulaEvaluator();
formatter.formatCellValue(cell,formulaEvaluator);
switch (cell.getCellTypeEnum()) {
case STRING:
System.out.println(cell.getRichStringCellValue().getString());
break;
case NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
System.out.println(cell.getDateCellValue());
} else {
System.out.println(cell.getNumericCellValue());
}
break;
case BOOLEAN:
System.out.println(cell.getBooleanCellValue());
break;
case FORMULA:
System.out.println(cell.getCellFormula());
break;
case BLANK:
System.out.println();
break;
default:
System.out.println();
}
}
------------------------------------------
Output is :
C34
But I need cell-value as output...
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Getting-the-cell-contents-tp5728401p5728405.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
