Copy Columns

how do i copy column C to col E? I cant use read range because my range will change on different excels. I tried using Ctrl + C but error occurs…

image

Ctrl+C and Ctrl+V should work, what is the error ? Can you post the code & error message ?

1 Like

Hi @qaz1, the differences in range as in rows or columns?

I am not clear…can u post the error message ?

Hi @qaz1

1.You can assign a value inside FOR EACH ACTIVITY
Assign row(4)=row(2).ToString .
If you want to delete the column(Index C).then use remove data column to delete.

2.Else, Use Hotkeys.

:slight_smile:

1 Like

Hi Sob, I got an exception “Assign : Exception has been thrown by the target of an invocation.”
I have the XAML file. Please have a look.

Main.xaml (7.8 KB)

Hi @qaz1,

Below it has an activity called copy data. It may helps you.

Regards
Balamurugan.S

3 Likes

Thanks Bala. You are a genius. Hats off to you.

1 Like