Hello! I am currently creating a calculation system where the user can enter the value on Mendix. Then, the admin will be able to export the entered value into an existing excel file which have been set to do the calculation. The question is, how can i create the system that allows mendix to export the item from mendix into the excel?
You should be able to accomplish this using the Advanced Excel module from the Marketplace (https://marketplace.mendix.com/link/component/116370). To do this, you would:
create a way to upload files into the Advanced Excel module excel document entity
create a microflow that retrieves the file you want to write values into
in this microflow, write the values you calculated in Mendix