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