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
The number of records is 75k rows and 300 columns
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
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.