[MGNLEE-471] UnsupportedFileFormatException while working with excel sheet using POI Created: 10/Nov/16 Updated: 11/Nov/16 Resolved: 11/Nov/16 |
|
| Status: | Closed |
| Project: | Magnolia DX Core |
| Component/s: | None |
| Affects Version/s: | 5.4.9 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Blocker |
| Reporter: | Giovanni Regola | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Java jdk1.7.0_51 |
||
| Template: |
|
| Acceptance criteria: |
Empty
|
| Task DoD: |
[ ]*
Doc/release notes changes? Comment present?
[ ]*
Downstream builds green?
[ ]*
Solution information and context easily available?
[ ]*
Tests
[ ]*
FixVersion filled and not yet released
[ ] 
Architecture Decision Record (ADR)
|
| Bug DoR: |
[ ]*
Steps to reproduce, expected, and actual results filled
[ ]*
Affected version filled
|
| Description |
|
I've just implemented a simple Magnolia job, that reads an Excel file (xls or xlsx doesn't matter) and print some Excel cell values on stdout (at this time, the next step consists of storing these values on a database table). The official Apache POI API FAQ (http://poi.apache.org/faq.html#faq-N10204) explains that " A combination such as poi-3.11.jar and poi-ooxml-3.9.jar is not supported, and will fail to work in unpredictable ways" I've noticed that Magnolia 5.4.9 EE bundle comes with these Apache POI libs:
So it seems that my issue is related to a compatibility problem between the "master" POI lib (3.9) and the others "slave" POI libs (3.11). At this time I need to know which of the following options do you suggest in order to solve my issue: With the default "Magnolia 5.4.9 POI" config it seems to be blocked any "read & write" Apache POI action on any Excel file. Best regards, |
| Comments |
| Comment by Giovanni Regola [ 11/Nov/16 ] |
|
This issue has been cloned with the following https://jira.magnolia-cms.com/browse/MGNLEE-472 for customer support |