Overview

This javaaction allows you to convert your Excel (.xlsx) file to CSV (.csv) with your own single delimiter or double delimiter.

Documentation

Typical usage scenario

The Excel to CSV Converter Java action module enables users to convert .xlsx files into .csv format while allowing them to specify a custom delimiter. This module efficiently processes Excel spreadsheets, extracting data from all sheets or a selected sheet and transforming it into a structured CSV output. Users can define delimiters such as commas (','), semicolons (';'), tabs ('\t'), or any other character to ensure compatibility with their data processing needs. Built for Mendix applications, this Java action leverages Apache POI to handle Excel files and ensures accurate data conversion, preserving text formatting and special characters. Ideal for seamless data migration and integration, this module simplifies the transformation of spreadsheet data into a universally accepted CSV format.

Features and limitations

This module only accepts .xlsx file extension.

Dependencies 

• log4j-api-2.23.1.jar
• poi-5.3.0.jar
• poi-ooxml-5.3.0.jar
• poi-ooxml-lite-5.3.0.jar
• xmlbeans-5.2.1.jar
• commons-compress-1.26.2.jar
• commons-io-2.17.0.jar