What I am doing is that, I have multiple CSV files. I read the contents from each of the CSV files and paste it on an excel worksheet from row : 1 and column : 1 in order.
When I paste CSV files that contain similar length of the contents, pasting on an excel work sheet works fine. However, when it comes to read CSV file that contains smaller length of the content, it places the contents from the end of the previous one although I set the start column and row as 1.
So what I am currently doing is to give a condition, "When it tries to read and past CSV files with certain names, open a new excel instance and paste it on it".
However, this causes a bad maintenance because, if there is a new CSV file that has smaller length of the contents than others, OR if there is a CSV file with smaller length of the contents being no more used, I have to edit the flow.
Does anyone know what makes it being pasted from the end of the previous one?
Thanks in advance!
