Overview

This widget provides an advanced, customizable Excel export option directly inside Mendix data grids and list views. Developers define which attributes are exportable, and end-users can dynamically choose the columns they want from a modern popup interface. The widget converts the selected data entirely on the client-side using pure JavaScript—no microflows required. It supports custom column labels, automatic Excel file generation, and works seamlessly across pages. A perfect lightweight solution for flexible, on-demand data exports.

Documentation

Overview

The Customized Excel Export Widget enables end-users to export data from Mendix ListView and DataGrid widgets into an Excel (.xlsx) file with fine-grained, column-level control. The widget operates entirely on the client side, eliminating the need for backend microflows and ensuring fast, responsive exports.

It is designed for applications where users require on-demand, customizable Excel downloads with professional usability features such as column selection, formatting, frozen headers, and filters.

Typical Usage Scenario

End-users can select specific columns from a ListView or DataGrid and instantly download only those selected columns as an Excel file. This is particularly useful in reporting dashboards, admin panels, and operational applications where different users need different export views of the same data.

Key Features

• Popup UI with dynamic checkbox list of exportable attributes
• End-user controlled column selection before export
• Fully client-side Excel generation (no microflows required)
• Supports ListView and DataGrid contexts
• Custom column header labels
• Auto or manual column width configuration
• Column-wise text alignment (left, center, right)
• Frozen header row for better navigation
• Excel AutoFilter applied to header row
• Lightweight and fast XLSX generation using ExcelJS
• Configurable output file name

Installation

1. Import the widget into your Mendix project.
2. Place the widget on the same page as the ListView or DataGrid.
3. Ensure the widget is bound to the same datasource as the grid or list.