Overview

Easy Excel To Export is a Mendix pluggable widget that allows users to export DataGrid 2 data to professionally styled Excel files with one click.

KEY FEATURES

• One-Click Export: Download DataGrid 2 data to Excel instantly.

• Custom Header Styling: Set header background and text colors.

• Auto Filters: Adds Excel filter dropdowns to headers.

• Alternate Row Colors: Zebra striping for better readability.

• Summary Row: Shows total records and export timestamp.

• Multiple Button Styles: 7 color options to match your app.

• Event Actions: Trigger microflows on export start, success, or error.

USE CASES

• Export sales, financial, or inventory reports

• Download employee or customer lists

• Generate data exports for analysis

• Create audit records with timestamps

HOW TO USE

1. Add DataGrid 2 to your page and set its Name property

2. Drag Easy Excel To Export widget to the page

3. Enter the DataGrid Name (must match exactly)

4. Configure file name, sheet name, and styling

5. Run and click export!

CONFIGURATION OPTIONS

Button Settings: Caption, Style, Size, Show/Hide Icon

Export Settings: DataGrid Name, File Name, Sheet Name, Row Limit

Header Styling: Background Color, Text Color

Data Styling: Auto Filter, Alternate Colors, Summary Row

Events: On Start, On Success, On Error

REQUIREMENTS

• Mendix 9.x or 10.x

• DataGrid 2 widget

• Web platform only

EXCEL OUTPUT

• Styled headers with custom colors

• Auto-adjusted column widths

• Filter dropdowns on columns

• Alternating row colors

• Summary footer row

• Clean borders and formatting

This widget eliminates complex microflows for Excel export. Configure once, and your users get beautiful Excel downloads instantly. Perfect for any application requiring data export functionality.

Documentation

Typical usage scenario

Easy Excel To Export helps users download DataGrid 2 data into a professionally formatted Excel (.xlsx) file with just one click.

Features and limitations

One-Click Export

Export DataGrid 2 data to Excel instantly.

Header Styling

Customize header background and text color using hex codes.

Excel Filters

Automatically adds filter dropdowns to columns.

Alternate Row Colors

Improves readability using zebra-striping.

Summary Row

Shows total record count and export date at the bottom.

Button Customization

• 7 button styles (Primary, Success, Warning, etc.)
• Small, Medium, Large sizes
• Optional Excel icon

Event Actions

Trigger microflows or nanoflows on:

• Export Start
• Export Success
• Export Error

Flexible Settings

• Custom file name
• Custom sheet name
• Max rows limit
• Enable/disable headers

Professional Excel Output

• Bold headers
• Borders
• Centered text
• Auto column width

Loading Indicator

Shows spinner while exporting.

Dependencies [optional]

DataGrid 2

• Must have a Name set
• Export must be enabled

Mendix Studio Pro

• Version 9.x or 10.x

Installation [optional]

Open Mendix Studio Pro

Go to App → Marketplace

Search Easy Excel To Export

Click Download