Customized Excel Export
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
- Import the widget into your Mendix project.
- Place the widget on the same page as the ListView or DataGrid.
- Ensure the widget is bound to the same datasource as the grid or list.
Releases
Fixes
Fixed DateTime export to respect Mendix date format configuration.
Fixed issue where Excel file was not downloaded when the data source returned no records.
Improvements
When empty result validation is disabled, the widget now downloads an Excel file with headers even if there is no data.
✅ Version 2.2.0
New Features
Added validation popup for empty export results
Added configurable popup title
Added toggle to enable/disable validation
Improvements
Button auto-resizes to content
Improved icon & label behavior
Improved loader experience
Cleaner Studio property layout
Behavior Updates
Export now proceeds with returned data
Validation no longer blocks export
✨ New Features
Added Column Freezing support
Developers can configure number of columns to freeze from the left.
Added Header Row Freezing option
Allows locking the header row during scrolling in exported Excel.
Added Column Filter Support
Developers can enable Excel filters for exported columns using a global toggle.
🚀 Major Feature Release
Added drag-and-drop column reordering inside the column selection popup.
New Features:
• Drag & drop column reordering
• New "Allow Column Reordering" configuration property
• Improved export selection UX
• Export button now dynamically disables when no columns selected
• Enhanced drag stability and performance
Improvements:
• Removed browser alert popups
• Improved modal interaction behavior
• Better accessibility and keyboard drag support
New Features
- Added support for Header Font Color using expression configuration.
- Added support for Body Font Color using expression configuration.
- Introduced Column-level Font Color Mode with:
- Inherit (uses global body font color)
- Conditional (expression-based font color per row)
Enhancements
- Improved Excel styling flexibility with advanced conditional formatting support.
- Enhanced property panel behavior with dynamic visibility for conditional font settings.
Improvements
- Optimized styling architecture for better scalability and future formatting features.
✨ New Features
- Added expression support for Export File Name
- Added expression support for Date Format
- Added expression support for Header Background Color
- Added expression support for Body Background Color
- Added Border Style option (None, Thin, Thick)'
🔧 Improvements
- Enhanced Excel export customization
- Improved flexibility for dynamic configurations
1. Date Formatting for DateTime Attributes
- Added configurable date formatting for DateTime attribute columns
- Supports various format patterns:
YYYY-MM-DD HH:mm:ss(default)MM/DD/YYYYDD/MM/YYYY hh:mm:ss AYYYY-MM-DD- And many more custom formats
- Date formatting only applies to DateTime attributes automatically
2. Placeholder Support for Empty Values
- New "Show Placeholder for Empty Values" option for each column
- When enabled, displays a custom placeholder text instead of empty cells
- Configurable placeholder text (default: "N/A")
- Handles
null,undefined, and empty string values - Works with all attribute types (String, Integer, DateTime, Boolean, etc.)
3. Popup Visibility Fix
- Resolved issue where column selection popup appeared even when disabled
- Fixed boolean property evaluation for widget settings
Customized Excel Export