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 org.jxls jxls-poi

Installation

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

Releases

Version: 1.11.0
Framework Version: 10.24.0
Release Notes:

We added three actions: GetSheetNames, GetXlsxProperties, and SetXlsxProperties.

Version: 1.10.0
Framework Version: 10.24.0
Release Notes:

We added the ProtectSheet action to password-protect the sheets.

Version: 1.9.0
Framework Version: 10.24.0
Release Notes:

The SetWithoutRecalculateFormulas action has been added.

Setting this to `true` disables formula evaluation.

Try setting it to `true` if errors occur within functions used in formulas.

Executing it once in the `AfterStartUp` event ensures the setting remains in effect thereafter.

Version: 1.8.0
Framework Version: 10.24.0
Release Notes:

Compatible with Mx v10.24.0 or higher.

Version: 1.7.0
Framework Version: 10.12.9
Release Notes:

We added support of dynamic grid with Grid command.

Version: 1.6.1
Framework Version: 10.12.9
Release Notes:

We added ParameterNameOfSheetNames parameter to SetJxlsSheetNames Java Action.

We fixed Java dependencies setting.

Version: 1.6.0
Framework Version: 10.12.9
Release Notes:

We added SetJxlsSheetNames java action to support multisheet option.

Version: 1.5.0
Framework Version: 10.12.9
Release Notes:

- Supports Mendix 10.12.9 and higher.

- Upgrad Jxls's version 3.0 to 3.1.

- Migrated the management of JAR files to Java managed dependencies.

 

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