https://issues.apache.org/bugzilla/show_bug.cgi?id=45365
Summary: Converting sheet to csv gives Malformed exponential
pattern error
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=22235)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22235)
Sheet causing Malformed exponential pattern error when converted to csv
Using v3.1 (20080629) and the code:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java
I am converting many excel workbooks each with many (50+ sheets). For one
particular workbook I get an exception, java.lang.IllegalArgumentException with
message:
Malformed exponential pattern "0.00E+00". Looking at the workbook in question
there seems nothing obvious. Looking at XLS2CSVmra.java, it fails on the line
in the porocess() method:
factory.processWorkbookEvents(request, fs);
I went though all 84 sheets and narrowed it down to the problem sheet (see
attached poi.xls). I can't see what the problem is on this sheet, but it gives
the Malformed exponential pattern error every time
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
