Question

Mendix with Excel

0

Hi, I am trying to connect mendix with excel to do calculations and return the result to me. For example pass 5 records from a microflow to excel, perform the calculation, and return it to mendix. This is possible, do you know any way? Thanks

asked 2020-07-30

Horacio MAggio

4 answers

Jonathan Cohen · Answer 1 · 2020-07-30

Hi Horocio,

You can look into using the ExcelExporter and ExcelImporter modules from the mendix store. I only have experience with the ExcelExporter module, and it is a little tricky to configure but here are the instructions.

https://docs.mendix.com/howto/integration/using-the-excel-exporter

There’s also an exportToExcel button that is easy to use but doesn’t allow for much customization.

Hope this helps!

Jon

Horacio MAggio · Answer 2 · 2020-07-30

Hi Jonathan,

I was looking at the excel importer / exporter, this would work, from what I understood, when the calculation in excel would be done by the user opening the file by calculating it and uploading it again with the excel importer. Here my intention is that the calculation process in excel is automatic without user interaction “as a service”. Thank you for all.

Mike Kumpf · Answer 3 · 2020-07-30

Horacio

To do this, I think you would need to integrate with Excel for Office 365 using the MSGraph api. Here is an example of how to call an Excel function in this way: https://docs.microsoft.com/en-us/graph/api/resources/workbook?view=graph-rest-1.0#functions and a general page on the MSGraph API: https://docs.microsoft.com/en-us/graph/overview

What calculation do you need to perform? Maybe it would be possible to build the calculation in a Mendix microflow.

Mike

Tim v Steenbergen · Answer 4 · 2020-07-30

An Excel spreadsheet can use a database as datasource, for instance an SQL-database. If you are familiar with that option then here is your next possibility:

Make your Mendix app connect to SQL databases, by using the AppstoreApp Database connector. Make it store data in the SQL-database. Make Excel get triggered, do the calculation, and store data in a response table.