So to convert this to a java time do the following: > - adjust for the different start day Jan 1, 1970 is excel date 25,569 > - multiply by the number of milliseconds in a day 8,6400,000 > - convert to a Date using java.util.date.Date(long date) > - use the Calendar class to adjust timezone > - use java.text.SimpleDateFormat to convert it to text. > > /peter >
...which is almost what HSSFDateUtil.getJavaDate(Date) does :) ...and you dont even have to call HSSFDateUtil.getJavaDate(Date) if you use HSSFCell.getDateCellValue() since thats what it uses internally. ~ amol --------------------------------------------------------------------- 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/
