Overview

"Streaming Excel Module" allows Mendix applications to efficiently import and export large Excel files. The module supports reading and writing Excel files in a memory-efficient way, handling millions of rows without performance degradation. It includes support for streaming data, custom DateTime formatting, and flexible configurations, making it ideal for handling large datasets. Perfect for developers looking to integrate advanced Excel capabilities into their Mendix apps with minimal impact on system resources.

Documentation

The "Streaming Excel Module" is designed for applications that need to process large Excel files for data import and export. It allows customers to handle massive datasets, efficiently reading and writing rows in a streaming manner without consuming excessive memory. This is useful in scenarios such as bulk data migrations, financial reporting, or generating large datasets in Excel format directly from Mendix applications.

Features and Limitations:

Features:

• Efficient streaming of large Excel files without heavy memory usage.
• Supports both Excel import and export functionality.
• Allows for custom DateTime formatting and timezone configurations.
• Capable of handling millions of rows without performance degradation.
• Seamless integration with Mendix microflows for flexible data processing.

Limitations:

• Limited to .xlsx files; other Excel formats are not supported.
• Streaming only works for Excel files structured with standard rows and cells; complex Excel layouts may require additional handling.

Frequently Asked Questions:

Q: Can I use this module to handle .xls files or other Excel formats?

A: No, the module currently only supports .xlsx files (other formats not tested).

Q: Does this module support Excel files with multiple sheets?

A: Yes, you can specify which sheet to import or export by setting the sheet name parameter in the Java actions.

Q: How does the module handle DateTime fields?

A: You can provide custom DateTime formats and timezone codes when importing or exporting DateTime fields in Excel files.