jXLSer
Content Type: Module
Categories: Import/Export
Overview
This is a Excel report formatter based on jXLS. It offers flexible template form with multiple parameters to create Excel file.
Documentation
Description
jXLSer provides Excel reporting functionality to your App. It wraps the jXLS library and is very easy to use. You can implement the Excel report generation function without complicated programs and settings just by preparing the Excel report template for jXLS. In addition, it can handle complicated layouts such as reports containing multiple tables.About jXLS, see also http://jxls.sourceforge.net/
-Provides intuitive usability for most engineers.-Multiple parameters can be passed to the template.-Supports non-persistent entities for parameters.-It is possible to display unrelated entities on the data model, including multiple grids, instead of just outputting a list.
Typical usage scenario
This is useful if you want to easily implement complex Excel reports.
Features and limitations
AddJxlsContextParameter ActionSpecifies a context parameter object to merge into the template.
AddJxlsContextParameters ActionSpecifies a context parameter object list to merge into the template.
ProcessJxlsTemplateByFileDocument ActionGenerates an Excel file by merging the specified context parameters and template file. The template file is specified in Mendix's System.FileDocument object.
ProcessJxlsTemplateByResourcePath ActionGenerates an Excel file by merging the specified context parameters and template file. Store the template file in the project's resource folder and specify its path.
Dependencies
Requires Mendix 9.24.23 or higher.
Installation
You can easily download and install the module from the App Store on Studio Pro.
Releases
Version: 1.4.1
Framework Version: 9.24.23
Release Notes: - This is the oss jar files maintenance upgrade.
- The following upgrades were applied.
-- commons-beanutils-1.9.4.jar ==> commons-beanutils-1.11.0.jar
-- commons-codec-1.17.0.jar ==> commons-codec-1.17.1.jar
-- commons-compress-1.26.2.jar ==> commons-compress-1.27.1.jar
-- commons-io-2.16.1.jar ==> commons-io-2.18.0.jar
-- commons-lang3-3.14.0.jar ==> commons-lang3-3.18.0.jar
-- poi-5.3.0.jar ==> poi-5.4.0.jar
-- poi-ooxml-5.3.0.jar ==> poi-ooxml-5.4.0.jar
-- poi-ooxml-lite-5.3.0.jar ==> poi-ooxml-lite-5.4.0.jar
-- xmlbeans-5.2.1.jar ==> xmlbeans-5.3.0.jar
-- log4j-api-2.23.1.jar ==> log4j-api-2.24.3.jar
- Dependency-wise, this version is compatible with:
-- Excel Importer v11.1.2.
-- Excel exporter v7.5.6.
- When upgrading, make sure it is consistent with other modules that use Apache POI and that the old jar files have been deleted.
- If you use this module on Mendix 10.3.0 or higher with Java Dependencies settings, you can improve the consistency of jar dependencies across your entire app molules with the following settings. In that case, please also delete the jars that are required only by this module from the userlib folder.
Group Artifact Version
org.jxls jxls-poi 3.0.0
org.apache.poi poi 5.4.0
org.apache.poi poi-ooxml 5.4.0
org.apache.commons commons-lang3 3.18.0 (due to the vulnerabilities of 3.16-17)
commons-beanutils commons-beanutils 1.11.0 (due to the vulnerabilities of 1.9-10)
commons-logging commons-logging 1.2
-- v1.4.1 contains jars as blow in userlib. --
SparseBitSet-1.3.jar
commons-beanutils-1.11.0.jar
commons-codec-1.17.1.jar
commons-collections-3.2.2.jar
commons-collections4-4.4.jar
commons-compress-1.27.1.jar
commons-io-2.18.0.jar
commons-jexl3-3.3.jar
commons-lang3-3.18.0.jar
commons-logging-1.2.jar
commons-math3-3.6.1.jar
curvesapi-1.08.jar
jxls-3.0.0.jar
jxls-poi-3.0.0.jar
log4j-api-2.24.3.jar
poi-5.4.0.jar
poi-ooxml-5.4.0.jar
poi-ooxml-lite-5.4.0.jar
xmlbeans-5.3.0.jar
Version: 1.4.0
Framework Version: 9.24.23
Release Notes: - Added Support of jXLS streaming mode.
- Supports Mendix 9.24.23 and higher with Java17.
- Upgrad jxls, poi, and other jar files.
- Dependency-wise, this version is compatible with:
-- Excel Importer v10.7.4.
-- Excel exporter v7.5.4.
- When upgrading, make sure it is consistent with other modules that use Apache POI and that the old jar files have been deleted.
- If you use this module on Mendix 10.3.0 or higher with Java Dependencies settings, you can improve the consistency of jar dependencies across your entire app molules with the following settings. In that case, please also delete the jars that are required only by this module from the userlib folder.
Group Artifact Version
org.jxls jxls-poi 3.0.0
org.apache.poi poi 5.3.0
org.apache.poi poi-ooxml 5.3.0
commons-logging commons-logging 1.2
--------------------------------------------------------------------------
- The jar files of userlib are as follows.
--------------------------------------------------------------------------
-- v1.4.0 contains jars as blow in userlib. --
SparseBitSet-1.3.jar
commons-beanutils-1.9.4.jar
commons-codec-1.17.0.jar
commons-collections-3.2.2.jar
commons-collections4-4.4.jar
commons-compress-1.26.2.jar
commons-io-2.16.1.jar
commons-jexl3-3.3.jar
commons-lang3-3.14.0.jar
commons-logging-1.2.jar
commons-math3-3.6.1.jar
curvesapi-1.08.jar
jxls-3.0.0.jar
jxls-poi-3.0.0.jar
poi-5.3.0.jar
poi-ooxml-5.3.0.jar
poi-ooxml-lite-5.3.0.jar
xmlbeans-5.2.1.jar
log4j-api-2.23.1.jar
Version: 1.3.0
Framework Version: 9.24.2
Release Notes: - Supports Mendix 9.24.2 and higher.
- Upgrad jxls, poi, and other jar files.
- Dependency-wise, this version is compatible with:
-- Excel Importer v10.6.2.
-- Excel exporter v7.4.1.
- When upgrading, make sure it is consistent with other modules that use Apache POI and that the old jar files have been deleted.
--------------------------------------------------------------------------
- The old and new jar files of userlib are as follows.
--------------------------------------------------------------------------
-- v1.3.0 contains jars as blow in userlib. --
SparseBitSet-1.3.jar
commons-beanutils-1.9.4.jar
commons-codec-1.16.0.jar
commons-collections-3.2.2.jar
commons-collections4-4.4.jar
commons-compress-1.26.0.jar
commons-io-2.15.1.jar
commons-jexl3-3.2.jar
commons-logging-1.3.1.jar
commons-math3-3.6.1.jar
curvesapi-1.08.jar
jxls-2.14.0.jar
jxls-poi-2.14.0.jar
poi-5.2.5.jar
poi-ooxml-5.2.5.jar
poi-ooxml-lite-5.2.5.jar
slf4j-api-1.7.36.jar
xmlbeans-5.2.0.jar
log4j-api-2.21.1.jar
Version: 1.2.1
Framework Version: 8.12.7
Release Notes: - Upgraded poi-ooxml from 4.1.2 to 5.2.2 to fix the common vulnerabilities and exposures.
- When upgrading, make sure it is consistent with other modules that use Apache POI and that the old jar files have been deleted.
- This version is compatible with:
-- Excel Importer v10.1.1
-- Excel exporter v7.0.4
--------------------------------------------------------------------------
- The old and new jar files of userlib are as follows.
--------------------------------------------------------------------------
-- Userlib of v1.2.1 --
commons-beanutils-1.9.4.jar
commons-codec.commons-codec-1.15.jar
commons-collections-3.2.2.jar
org.apache.commons.commons-collections4-4.4.jar
org.apache.commons.commons-compress-1.21.jar
commons-digester-2.1.jar
commons-io-2.11.0.jar
commons-jexl3-3.2.1.jar
commons-logging-1.2.jar
org.apache.commons.commons-math3-3.6.1.jar
com.github.virtuald.curvesapi-1.07.jar
jxls-2.12.0.jar
jxls-poi-2.12.0.jar
org.apache.poi.poi-5.2.2.jar
org.apache.poi.poi-ooxml-5.2.2.jar
org.apache.poi.poi-ooxml-full-5.2.2.jar
slf4j-api-1.7.36.jar
org.apache.xmlbeans.xmlbeans-5.0.3.jar
log4j-api-2.17.2.jar
-- Userlib of v1.2.0 --
commons-beanutils-1.9.4.jar
commons-codec.commons-codec-1.13.jar
commons-collections-3.2.2.jar
org.apache.commons.commons-collections4-4.4.jar
org.apache.commons.commons-compress-1.19.jar
commons-digester-2.1.jar
commons-jexl3-3.1.jar
commons-logging-1.2.jar
org.apache.commons.commons-math3-3.6.1.jar
curvesapi-1.06.jar
jxls-2.10.0.jar
jxls-poi-2.10.0.jar
org.apache.poi.poi-4.1.2.jar
org.apache.poi.poi-ooxml-4.1.2.jar
org.apache.poi.poi-ooxml-schemas-4.1.2.jar
slf4j-api-1.7.30.jar
xmlbeans-3.1.0.jar
Version: 1.2.0
Framework Version: 8.12.7
Release Notes: Add the SetUserTimeZone action to allow the POI to process datetime in any timezone.
Add commons-collections-3.2.2.jar to fix the problem of groupBy option.
Version: 1.1.0
Framework Version: 8.12.7
Release Notes: - This version supports Mendix 8.12.7 and higher
- We have upgraded the apache-poi,jxls and commons-beanutils libraries. If you are upgrading this module from an older version, make sure to manually locate and remove older versions libraries from the userlib folder.
- We also renamed some Jar files to match those of Excel importer / exporter.
- The old and new jar files of userlib are as follows.
-- Userlib of v 1.1.0
commons-beanutils-1.9.4.jar
commons-codec.commons-codec-1.13.jar
org.apache.commons.commons-collections4-4.4.jar
org.apache.commons.commons-compress-1.19.jar
commons-digester-2.1.jar
commons-jexl3-3.1.jar
commons-logging-1.2.jar
org.apache.commons.commons-math3-3.6.1.jar
curvesapi-1.06.jar
jxls-2.10.0.jar
jxls-poi-2.10.0.jar
org.apache.poi.poi-4.1.2.jar
org.apache.poi.poi-ooxml-4.1.2.jar
org.apache.poi.poi-ooxml-schemas-4.1.2.jar
slf4j-api-1.7.30.jar
xmlbeans-3.1.0.jar
-- Userlib of v 1.0.1
commons-beanutils-1.9.2.jar
commons-codec-1.13.jar
commons-collections4-4.4.jar
commons-compress-1.19.jar
commons-digester-2.1.jar
commons-jexl3-3.1.jar
commons-logging-1.2.jar
commons-math3-3.6.1.jar
curvesapi-1.06.jar
jxls-2.8.1.jar
jxls-poi-2.8.1.jar
poi-4.1.1.jar
poi-ooxml-4.1.1.jar
poi-ooxml-schemas-4.1.1.jar
slf4j-api-1.7.30.jar
xmlbeans-3.1.0.jar
Version: 1.0.1
Framework Version: 7.23.7
Release Notes: There is no functional improvement, but fixed the problem caused by the Java package name when running on Eclipse.
Version: 1.0.0
Framework Version: 7.23.7
Release Notes: First release.