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 Action
Specifies a context parameter object to merge into the template.

AddJxlsContextParameters Action
Specifies a context parameter object list to merge into the template.

ProcessJxlsTemplateByFileDocument Action
Generates an Excel file by merging the specified context parameters and template file. The template file is specified in Mendix's System.FileDocument object.

ProcessJxlsTemplateByResourcePath Action
Generates 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 7.23.7 or higher.

Installation

You can easily download and install the module from the App Store on Studio Pro.

Releases

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.