Copy entire column data from excel to another excel?

Hi@All,

I have a scenario like I need to copy from one column in excel1 to excel2

Hi @varunk,

use read range to get all the data from the first excel to data table.(Dt1)

then use assign activity

Dt2=DT1.DefaultView.ToTable(false,"ColumnName").CopyToDataTable()

use write range activity to write the data into 2nd excel sheet(DT2)

Regards,
Arivu :slight_smile:

3 Likes

Hi @arivu96,

I have multiple columns are there I need to copy that entire column data to another excel
In different column name

Hi @varunk,

if you want you can add the column additionally by using below code

Dt2=DT1.DefaultView.ToTable(false,"Column1","Column2","Column3").CopyToDataTable()

Regards,
Arivu :slight_smile:

Hi @arivu96,

For me it was showing error , CopyToDataTable is not a member
If you have a sample flow can you share