Can I ask, what does POI think the value in that cell is? I would guess that it is telling you that the cell holds a numeric value.
You do know that dates are actually stored as numeric values that are then 'converted' into the familair format by the formatting that is applied to the cell? If you are expecting to see a formatted date value recovered from the cell then you will need to use something like the DataFormatter class to convert the numeric value into the form you expect to see. Yours Mark B Bugzilla from [email protected] wrote: > > https://issues.apache.org/bugzilla/show_bug.cgi?id=48336 > > Summary: Error reading date > Product: POI > Version: 3.5-FINAL > Platform: Other > OS/Version: Linux > Status: NEW > Severity: critical > Priority: P2 > Component: HSSF > AssignedTo: [email protected] > ReportedBy: [email protected] > > > Created an attachment (id=24665) > --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24665) > Excel file > > The attached Excel has a date value in row 1, column D. POI doesn't read > it as > a date. The file was created by SoftArtisans OfficeWriter for Excel > 7.0.0.1642 > (http://officewriter.softartisans.com). > > Thanks. > > -- > Configure bugmail: > https://issues.apache.org/bugzilla/userprefs.cgi?tab=email > ------- You are receiving this mail because: ------- > You are the assignee for the bug. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-48336--New%3A-Error-reading-date-tp26630117p26630248.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
