Bug 53990

Summary: Date is not fetched properly using eventusermodel while reading the excel file in xml format
Product: POI Reporter: Mani <manivel.mymail>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P4    
Version: 3.8-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Mani 2012-10-11 07:57:46 UTC 
hi,

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,
Mani
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. 

Yegor
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.