| Summary: | Convert Date cell to CSV fails | ||
|---|---|---|---|
| Product: | POI | Reporter: | ishai <ishai.lekach> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | ishai.lekach |
| Priority: | P2 | ||
| Version: | 3.2-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows XP | ||
| Attachments: |
The source excel file to be convert
The file as converted to CSV by Excel, see the dates The file as converted to CSV by XLS@CSVmra class, see the dates |
||
Created attachment 23109 [details]
The file as converted to CSV by Excel, see the dates
Created attachment 23110 [details]
The file as converted to CSV by XLS@CSVmra class, see the dates
I suspect that this is actually an issue with the underlying HSSFDataFormatter class Can you try sending your date cells directly to HSSFDataFormatter (using the usermodel api), and see if it displays the same problem? I now use the new HSSFDataFormatter class and it solved the problem, thanks!!! |
Created attachment 23108 [details] The source excel file to be convert I try to convert the attach Excel file to CSV, using the XLS2CSVmra class and get wrong dates. For example - 01/01/08;@ in place of 01/01/08