Copy Columns

[qaz1 (qish)]

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…

[skini76]

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

[quihan]

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

[skini76]

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

[Sob (Bindu)]

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.

[Deepak11]

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)

[balupad14 (Balamurugan)]

Hi @qaz1,

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

BalaReva.Excel.Activities

Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies the data from Excel Sheet to the clipboard 2.Delete Data activity - It deletes the data in the Excel Sheet 3.Clipboard To Datatable activity - It converts the clipboard to Datatable Namespace [image] 1.Properties Copy Data activity [image] Sample File : CopyData.zip (8.1 KB) 2.Properties of Delete Data activity [image] Sample : DeleteData.zip (6.9 KB) 3.…

Regards
Balamurugan.S

[Deepak11]

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