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
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.
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
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.