Merge two excel file into to one csv

0
I want to merge two excels into one CSV using Mendix. Please suggest the possible ways. First excel data is static and other is dynamic.      
asked
2 answers
1

Hi Kirti, 

 

You might need the combination of two modules: excel importer and the excel exporter. Follow the documentation for the following:

  • Import the two excel files to persistent-object. 
  • Create logic via microflow to combine the data to your CSV structure. You probably need a new entity for this.
  • Create a datagrid for the new entity and use Export to CSV button or use the excel exporter functionality for a more advanced options.

Regards, Thijs

answered
0

I agree with Thijs that this can be achieved with the Excel Importer and perhaps the CSV Exporter module. This is the best option, but does come with a fair share of overhead.

 

If you don’t really need the data in the Mendix app, but really only want to automate then a simple Java action could do the trick. If the files are uploaded in Mendix, create a Java action that gets a CSV file and an Excel file as input and reads the content of this input Excel file and appends the content to this existing CSV file. Call this Java action as many times as you have Excel file content to append to the CSV file. Should be fairly straightforward if you or your team mates have basic Java skills. 

 

 

answered