Bug 53990 - Date is not fetched properly using eventusermodel while reading the excel file in xml format
Summary: Date is not fetched properly using eventusermodel while reading the excel fil...
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.8-FINAL
Hardware: PC Windows XP
: P4 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2012-10-11 07:57 UTC by Mani
Modified: 2012-10-11 12:41 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Mani 2012-10-11 07:57:46 UTC

I am reading the excel file(.xlsx format), it is giving "Java heap space" error because my file contains more than 75 rows and 300 columns. So, i am using 
eventusermodel and SAX parser to read the data as mentioned POI site. while fetching the values, the date is displayed as "12/12/10" where as in my excel sheet it is given as "12/12/2010". I changed the date to "12/12/1910" in excel, even then i am getting the date as "12/12/10" format. Is there a way i can fetch the date as it in excel spreadsheet using eventusermodel.

Also, using the eventusermodel i am able to fetch all the records at once. Is there any way  i can fetch particular row data.

Thanks in advnace,
Comment 1 Mani 2012-10-11 10:01:17 UTC
The number of records is 75k rows and 300 columns
Comment 2 Yegor Kozlov 2012-10-11 11:07:21 UTC
Firstly, Bugzilla is not a place to ask questions, use the @poi-user for that. And please don't abuse Bugzilla, you will get nothing by setting priority to blocker.

Please try XLSX2CSV from poi-examples. Does it format your data correctly ? 

If it does not and you think it is a bug in POI, please attach the input file and sample Java code that demonstrates the trouble. 

Comment 3 Mani 2012-10-11 12:41:09 UTC
Apologies for asking this question in Bugzilla. I used XLSX2CSV from poi-example only and i got the solution by changing the date format(formatString variable in the example) and i got the exact date as in excel sheet.