|Summary:||Convert Date cell to CSV fails|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
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
Description ishai 2009-01-13 01:18:36 UTC
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
Comment 1 ishai 2009-01-13 01:20:24 UTC
Created attachment 23109 [details] The file as converted to CSV by Excel, see the dates
Comment 2 ishai 2009-01-13 01:25:20 UTC
Created attachment 23110 [details] The file as converted to CSV by XLS@CSVmra class, see the dates
Comment 3 Nick Burch 2009-01-15 04:26:26 UTC
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?
Comment 4 ishai 2009-01-15 05:32:02 UTC
I now use the new HSSFDataFormatter class and it solved the problem, thanks!!!