Details
-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: EE-4.2.0.GA
-
Component/s: ACE-Components
-
Labels:None
-
Environment:ICEfaces 4.x
-
Assignee Priority:P1
-
ICEsoft Forum Reference:
-
Affects:Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial, Compatibility/Configuration
Description
The POI library that the ace:dataExporter uses to export to .xls format currently seems to now also support the newer .xlsx format.
This JIRA is to enable exported to the .xlsx format using ace:dataExporter (in addition to the existing .xls format).
This JIRA is to enable exported to the .xlsx format using ace:dataExporter (in addition to the existing .xls format).
r51310: ace:dataExporter, added support for exporting data in the xlsx format
Supporting the xlsx format required updating the current poi library and adding other dependency libraries.
The core poi library doesn't support the xlsx format out of the box. It is necessary to also add the poi-ooxml library to support it, which in turn requires the poi-ooxml-schemas library and the dom4j library. This adds about 6 MB in libraries.
I tried using the previous poi 3.7 version, but the available dependencies mentioned above weren't compatible with it, so the core poi library had to be updated as well to the 3.9 version.
At the moment, the common.xml build file for the sample applications is not including these new libraries, since it would greatly increase the sizes of the sample applications. This is pending until we decide if we want to showcase the support for the xlsx format or if we simply want to document it in the wiki for those interested in it.