Studio Excel Copy Paste

Help Studio
1

Hey there,

how am I able to copy the all used rows & columns from one excel file (I) in another excel file (II) range (F2:I2) and afterwards append some more copied cells in excel file (II) range FX:IX?

When I try to use Cope/Paste range, I am able to paste a range in the same file as copied but not in another one.

Thanks & regards
Katarina

2

Hello @Katarina

You can use
1)Use Excel activity to open then the excel
2)Read range activity to read the excel and get it to Datatable varibale
3)Use excel activity to open the 2nd excel
4)Use WriteRange/Append range to insert the data to another excel.(you can specify the range to write the datatable)

like this way you can copy from one excel and paste it to another excel.

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.