http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFDate Util.html
> -----Original Message----- > From: Olivier Matt [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 11, 2005 11:53 AM > To: [email protected] > Subject: strange values in numeric field > > > Hi, > > I'm using HSSF to read some cells in an excel file. > The cell I'm reading is displayed as "1/01/05" (a date) by Microsoft > Excel. > In my java program, first i get the cell: > > switch ( cell.getCellType() ) { > case HSSFCell.CELL_TYPE_NUMERIC: > switch(cell.getCellNum()) > { > case 0: date = new String((new > Double (cell.getNumericCellValue())).toString()); break; // <-- > look here > default:System.out.println("dont > understand numeric(row " + row.getRowNum() + " cell " > + > cell.getCellNum() + ") = " + cell.getNumericCellValue()); > break; > } > break; > > > and then later I display it ... and I see the content as "38383.0"... > I dont understand how I shoud interpret it... > > any advise ? > > Thanks, > > Olivier Matt > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
