Programming/과거포스팅
poi excel geCellValue
다중복이네
2014. 6. 12. 13:15
public static String getExcelCulumValue(Cell cell) { String value = ""; try { switch (cell.getCellType()) { case Cell.CELL_TYPE_FORMULA: value = cell.getCellFormula(); break; case Cell.CELL_TYPE_NUMERIC: value = "" + (int)cell.getNumericCellValue(); break; case Cell.CELL_TYPE_STRING: value = "" + cell.getStringCellValue(); break; case Cell.CELL_TYPE_BLANK: value = ""; break; case Cell.CELL_TYPE_ERROR: value = "" + cell.getErrorCellValue(); break; default: } } catch(Exception e) { e.printStackTrace(); value=""; } return value; }