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 2006/12/16 07:10:13 UTC
DO NOT REPLY [Bug 41187] New: - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
Summary: Problem reading xls files created by Perl module
Spreadsheet::WriteExcel
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Linux
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: poi-dev@jakarta.apache.org
ReportedBy: hubertwslin@gmail.com
Hello,
I had problem reading xls files created with Perl module Spreadsheet::WriteExcel
(v2.17, released May 21, 2006)
Sample files to follow.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From hubertwslin@gmail.com 2006-12-17 06:13 -------
Created an attachment (id=19270)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=19270&action=view)
simple java code to test poi
Further test shows the flow never goes into the while( rows.hasNext() ) loop.
It's pretty easy to reproduce this, please give it a try. Thanks.
[h@mag ~]$ /usr/java/j2sdk1.4.2_13/bin/javac -classpath
poi-3.0-alpha3-20061216.jar POITest.java
[h@mag ~]$ /usr/java/j2sdk1.4.2_13/bin/java -classpath
poi-3.0-alpha3-20061216.jar:. POITest perl.xls
[h@mag ~]$ /usr/java/j2sdk1.4.2_13/bin/javac -classpath
poi-2.5.1-final-20040804.jar POITest.java
[h@mag ~]$ /usr/java/j2sdk1.4.2_13/bin/java -classpath
poi-2.5.1-final-20040804.jar:. POITest perl.xls
[h@mag ~]$
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From hubertwslin@gmail.com 2006-12-15 23:18 -------
Quoted from Spreadsheet::WriteExcel manpage:
The Spreadsheet::WriteExcel module can be used to create a cross-platform
Excel binary file. Multiple worksheets can be added to a workbook and formatting
can be applied to cells. Text, numbers, formulas, hyperlinks and images can be
written to the cells.
The Excel file produced by this module is compatible with 97, 2000, 2002 and
2003.
Here's the java code i used to parse the excel file:
http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From hubertwslin@gmail.com 2006-12-15 23:19 -------
The java code produce no error or exception, and nothing on the stdout.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From hubertwslin@gmail.com 2006-12-15 22:14 -------
Created an attachment (id=19268)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=19268&action=view)
perl src to write xls file
This code is availabe in the manpage of Spreadsheet::WriteExcel.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From hubertwslin@gmail.com 2006-12-15 22:12 -------
Created an attachment (id=19267)
--> (http://issues.apache.org/bugzilla/attachment.cgi?id=19267&action=view)
xls created with Perl module Spreadsheet::WriteExcel
This file can be opened without any problem in
1. MS office
2. OpenOffice
3. Google Docs & Spreadsheet
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From acoliver@apache.org 2006-12-16 05:13 -------
I'm a bit incredulous because POI (OLE2FS at the time) .01 was loosely based on
the documentation produced by the author of that module. Secondly POI generally
barfs with big fat stack traces when it doesn't like something. I'd suggest
writing the mail list providing executable copies of each part and see if
someone will run it for you and maybe figure out what's missing...
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
acoliver@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
------- Additional Comments From acoliver@apache.org 2006-12-15 22:48 -------
Is it an Excel 97+ format? We do not read anything but 97 or later. Those may.
Was there a stack trace or any other info?
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
dkatzel@jcvi.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
------- Additional Comments From dkatzel@jcvi.org 2008-01-22 13:25 -------
I too have just encountered this error (using poi-3.0.2beta2. It appears the
perl module does not create any RowRecord records. so
org.apache.poi.hssf.model.Sheet.createSheet(List, int, int) never populates the
rows field.
I have found a workaround to be to open the perl generated file in OpenOffice /
Excel and then do a "save as" this will create the missing RowRecords.
I hope this helps,
Danny
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 41187] - Problem reading xls files created by Perl module Spreadsheet::WriteExcel
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41187>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41187
------- Additional Comments From dkatzel@jcvi.org 2008-01-22 15:27 -------
I have added a bug report to the Perl SpreadSheet :: WriteExcel module on cpan:
the problem is known and will be corrected in a future release of WriteExcel.
http://rt.cpan.org/Public/Bug/Display.html?id=32544
Even though the problem will be resolved on the Perl side, I think it is still a
good idea to handle this issue on the Java side as well.
-Danny
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org