Excel to JSON Converter

Content Type: Widget
Categories: Import/Export,Visualization

Overview

This widget allows Mendix users to upload and preview Excel files client-side, instantly converting their contents into clean, structured JSON output.

Unlike traditional file importers that store files into the Mendix file system or commit data to the domain model, this widget is designed for lightweight, frontend processing – ideal for:

  • JSON API calls

  • Dynamic microflow logic

  • Local validation workflows

  • Pre-import inspection of Excel files

Documentation

✅ When to Use This Widget

Use this widget when you need to parse Excel client-side, preview or preprocess data before commit, or transform Excel input into JSON for custom integrations, without relying on Mendix FileDocument storage.

Common use cases include:

  • Lightweight integrations with REST APIs

  • Import preview before submitting to a backend

  • JSON payload generation for external systems

  • Workflow automation and rule engines

⚠️ What This Widget Does NOT Do

  • It does not persist Excel files in the Mendix file system.

  • It does not automatically map or commit data to entities.

  • It is designed for frontend-only scenarios.

🛠 Developer Use

You can combine this widget with:

  • A string attribute to hold the output JSON

  • A microflow or Java action to parse JSON into Mendix objects

  • Your own commit logic for full import pipelines

🔐 Security & Performance

  • All parsing is handled client-side

  • No server load or file transfer

  • Safe for preview and local transformations

🧩 Widget Properties

  • File Name – Outputs the name of the uploaded Excel file (String)

  • JSON String – Outputs the parsed Excel data as a JSON string (String)

  • Header Row – Row number where headers are located (Integer, 0-based)

  • Data Row – Row number where data starts (Integer, 0-based)

  • Sheet Name – Name of the Excel sheet to parse (String, optional).If left empty ,The First Sheet will be taken as default

 

💡 Final Note

This widget is built for data flexibility — developers can choose how and when to store or act on the parsed JSON. It fills the gap between Mendix file upload components and full-fledged import modules by offering a declarative, code-free JSON generation solution.

Releases

Version: 1.0.0
Framework Version: 9.24.0
Release Notes: 📌 Version 1.0.0 – Initial Release Release Date: [Insert Date of Release] Compatible Mendix Versions: 9.0.5 and above Widget Type: Pluggable React Widget (Client-side only) 🚀 Features ✅ Upload and parse .xlsx or .xls files directly in the browser ✅ Bind parsed output to a Mendix string attribute as JSON ✅ Optional binding for file name output ✅ Automatically detects Excel headers and data rows using widget parameters ✅ Converts Excel date serial numbers and ISO date strings to dd-mm-yyyy format ✅ Retains symbols, strings, and numbers exactly as typed ✅ No server load – fully client-side processing ✅ No file is committed to FileDocument – ideal for preview and dynamic logic