You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2012/10/11 09:57:46 UTC
[Bug 53990] New: Date is not fetched properly using eventusermodel
while reading the excel file in xml format
https://issues.apache.org/bugzilla/show_bug.cgi?id=53990
Priority: P2
Bug ID: 53990
Assignee: dev@poi.apache.org
Summary: Date is not fetched properly using eventusermodel
while reading the excel file in xml format
Severity: blocker
Classification: Unclassified
OS: Windows XP
Reporter: manivel.mymail@gmail.com
Hardware: PC
Status: NEW
Version: 3.8
Component: XSSF
Product: POI
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
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 53990] Date is not fetched properly using eventusermodel while
reading the excel file in xml format
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53990
--- Comment #1 from Mani <ma...@gmail.com> ---
The number of records is 75k rows and 300 columns
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 53990] Date is not fetched properly using eventusermodel while
reading the excel file in xml format
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53990
Mani <ma...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P1 |P4
Status|NEEDINFO |RESOLVED
Resolution|--- |FIXED
--- Comment #3 from Mani <ma...@gmail.com> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 53990] Date is not fetched properly using eventusermodel while
reading the excel file in xml format
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53990
Mani <ma...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P1
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 53990] Date is not fetched properly using eventusermodel while
reading the excel file in xml format
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53990
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
Severity|blocker |normal
--- Comment #2 from Yegor Kozlov <ye...@dinom.ru> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org