Question

Importing Excel based Applications with Macro (*.xlsm)

3

This may be asking for too much, but does Mendix allow importing of Excel files with macros into an Mendix App. What would be best way to start implementing my Excel (with Macros) based Application as a Mendix App. Please confirm whether it will require me start (re)coding the processing logic captured in macros ?

asked 2019-07-10

Dhiraj Shetty

1 answers

Ivo Sturm · Answer 1 · 2023-02-10

You can upload an XLSM. I have used XLSM templates in the ExcelExporter module before. Once a user clicks the export button that template is used to populate the data into this template with macro. After downloading the user can still trigger the macro via Excel to do any manipulations you didn’t want to have coded in Mendix.

But I assume that is not your actual question and you would like to either transform this macro logic into Mendix logic or let Mendix run the macro instead of the user. The first is a no. This can’t be automatically done. You would need to translate the macro logic into Mendix logic yourself. The second I looked into, but the Apache POI which Mendix uses to manipulate and generate Excel documents, isn’t capable of running macro’s. So there also a no..