Copy columns from one excel to another ( no read range activity )

Help Studio
,
1

Hello,

I want copy couple columns from one excel to another. I don`t want to to use read range activity beacuse there are merged cells, therefore it will copy and paste it diffrently. I just want to copy 1 to 1 as it is, no need to put it in datatable at all. I wanted to use VBA makro but it is working only in excel scope and that activity accept only one excel file at once, so if i want to copy from one to another, how im supposed to do this?

2

Hi @Add_Bddd ,

Maybe your task is similar to copying a Sheet ? If so, you could use the Copy Sheet Activity.

Check the possibilities whether after the Copy, we could keep only the required data that you need for the output.

Let us know if this doesn’t work.

3

@Add_Bddd Can you share us the sample excel file and column names which you want to copy to other sheet?