Currently, we are creating a Work Flow that pastes the contents of a CSV file into Excel.
However, as shown in the figure, if I use another scope in the Excel application scope, I cannot use the external Excel and cannot paste the CSV file.
I would like to paste the new CSV file data under the previously pasted CSV file data, so is there any good way to manipulate not only the current CSV file but also the Excel file?
・Why not use merge activities?
At first I used merge, but the amount of data in all the CSV files was so large that Studio stopped in the middle and I couldn’t do the pasting process.