1 Private StaticSimpleDateFormat DateFormat =NewSimpleDateFormat ("Yyyy-mm-dd HH:mm:ss"); 2 3 /**4 * Get the value of a cell5 * 6 * @paramCell7 * @return8 */9 Public StaticString getcellvalue (cell cell) {TenDecimalFormat DF =NewDecimalFormat ("#"); One if(Cell = =NULL) A return""; - - if(Cell.getcelltype () = =cell.cell_type_string) { the returnCell.getstringcellvalue (); -}Else if(Cell.getcelltype () = =Cell.cell_type_boolean) { - returnstring.valueof (Cell.getbooleancellvalue ()); -}Else if(Cell.getcelltype () = =Cell.cell_type_formula) { + returnCell.getcellformula (); -}Else if(Cell.getcelltype () = =cell.cell_type_numeric) { + if(hssfdateutil.iscelldateformatted (cell)) {//judgment is a date type ADate dt = hssfdateutil.getjavadate (Cell.getnumericcellvalue ());//get into Date type at returndateformat.format (DT); -}Else{//conversion phone number and ID number are string - returnstring.valueof (Df.format (Cell.getnumericcellvalue ())); - } - - in - } to return""; +}
POI ID number How to handle the date value of the phone number