I am not sure what you mean by models.
By models, I mean some products has its own models.
Example, EOP consist of EOP Samsung, EOP Apple, EOP Lenovo, etc... each model has its own Excel, same table header or column, just different data or content.
Once a week, I will receive an email from other department that consist 2 Excel file - RPA EOP Master List and EOP Trigger File_ModelName.
However, I do not see any code that actually writes to the master.
If the master here you are referring to the RPA EOP Master List Excel file that you see from the snapshot, this is another master list that I will use.
What I meant by I want to update all these data from different models into another master Excel file is another file. From the snapshot, I did write to the master - EOP_Trigger_File_GMC4B. Sorry for the confusion caused. I will change the name - EOP Trigger Main File.
To answer you, No, there is no way to just add the data without saving the "child". Technically speaking if it was a csv you could get the file content and concert it to text and parse it etc, but as its an Excel file, you must save it first
I have managed to save the Excel file as you can see from the flow I implemented - Create file 2.
Correct me if I am wrong, I am trying to understand the flow,
1. I need to save the Excel file first - done.
2. I need to get the content so that it could read the Excel data or file - List row present in a table action
3. Excel data will be updated into the main file (EOP Trigger Main File) - Add row into table (EOP Trigger Main File)
Am I correct?
