+44(0)1908738254
YOUR EXPERT RPA PARTNER

Team up with our RPA strategy and tech specialists for maximum automation impact

Find out more
Harness the power of UiPath in your business.
WATCH NOW

Save money and spend more time on priority work.

Book consultation
READY, SET, AUTOMATE

Let's choose, design and deploy a process automation solution for your business.

Find out more
TRANSFORM YOUR BUSINESS

Let's analyse your business to discover opportunities for innovation and automation.

Find out more

Begin your business transformation journey

Book consultation
AUTOMATE EVERY FUNCTION

Automate where it matters most. Scale to solve challenges in every area

Find out more
GIVE EVERY TEAM THE TOOLS FOR SUCCESS

Equip people with user-friendly solutions that save time and make work easier

Find out more

Which business problem
can we solve first?

Book consultation
01 May 2019

Excel Export in Mendix

Exporting to Microsoft Excel is an important day-to-day requirement of many business users, however, in Mendix there is presently no out-of-the-box feature that allows you to directly export to an Excel file. This blog will describe the process of configuring a 3rd party control that will give the ability to export Mendix data directly to Excel.

To achieve this functionality, please follow the below 10 steps.

Step 01

Open Mendix Modeller and open the project that you’d like to add the excel export to.

Step 02

Open the App Store by clicking on the shopping trolley icon in the top right corner:

Step 03

Download Mx Model reflection:

Mendix Model Reflection

Step 04

Download Microsoft Excel exporter:

Excel Exporter

 

Step 05

Create a new dashboard page and name the below two pages as follows: ‘Excel_Document_Overview’ & ‘Mx_Object_Overview’

Excel_Document_Overview 

Mx_Object_Overview

Step 06

Access your dashboard and follow these steps to configure the Mx_object_overview:

  1. Click on ‘MxObjects_Overview_Page’ Navigation:

2. Select your Modules on Mx objects overview page:

 

3. Click ‘Click to refresh’ button below ‘Synchonize all entities and microflows of checked modules on the left’:

Synchronise all entities

 

4. Select the entity from list of entity:

select entity from the list entry

Step 07

Follow these steps to configure the Excel_Document_Overview

  1. Go to created dashboard Page . Click on ‘Excel_document_Overview’ Navigation.

Excel document Overview

2. On Excel document overview page click ‘New’:

2. On Excel document overview page click New

3. In pop up window ‘New Template’ Please enter File Name , select the Input object ( Entity Name) and click Save and Next.

New Template

4. Select ‘date time export format’ in tempalte and create a new worksheet – click ‘New’ to create a worksheet:

New worksheet

 

5. Enter a worksheet ‘name’ and select ‘row object’ (entity name):

select worksheet and enter name

6. Add ‘Column data’ – Click on ‘New’ button in ‘Column data’ tab:

Add column data

7. Add Column data by taking the following action:

  • Column Number – Start from 0 to N
  • Name – Enter name of column
  • Retrieve type – set to Attribute
  • Select attribute – select the correct attribute
  • Save

8. Add vew column – Repeat step 7 to add another column manually.

9. End

Step 08

Select ‘Excel export’ to download the file:

Excel Export

Step 09

Call ‘Generate Report’ microflow from ‘XLS Report’ module:

Create a microflow

Step 10

Click on ‘Excel export’ to download the file:

Excel Export - Synergy Newsletter M4

  • CONGRATULATIONS – YOU NOW KNOW HOW TO EXPORT EXCEL FROM WITHIN MENDIX

Synergy is brought to you by our Technical Experts at Velocity IT, it provides low-code developers a knowledge base of intelligent and creative solutions, built and implemented on real-time projects.

Need further technical advice or support on Mendix or other low-code developments, get in-touch with one of our experts…