Hi Team, I have 2 Excel named as A and B excels. I want to copy the entire row in a A excel and paste into B excel . Please help me to slove the issue Thanks in advance…

Hi, Try This [DT_Output] DT_A.AsEnumerable().Where(Function(Datarow) Datarow(1).ToString <> Datarow(2).ToString).CopyToDataTable Sample Xaml is attached MergeDatatable.xaml (7.9 KB) Thanks, Muthuraj

How to copy entire row in one excel and paste in to excel

Help Activities

muthuraj.c (Muthuraj) September 7, 2022, 10:22am 3

Hi,

Use Read Range Activity to read both excel(A and B).
Use merge datatable activity

Xaml is attached
MergeDatatable.xaml (5.3 KB)

Thanks,
Muthuraj

Topic		Replies	Views
How to copy the entire data from one excel to another excel Studio studio , question , activities_panel	4	700	September 23, 2022
How to copy one excel row to paste in another excel update row Help excel , activities , question	14	5087	December 9, 2019
Copying a whole row of one excel sheet and paste it in other sheet Help excel , activities , question	6	3256	November 28, 2019
How to copy a row from one table and paste it on another table on another table Help datatable , excel , activities , question	3	4483	November 21, 2019
How to copy to paste one excel to another excel Activities excel , activities , question	4	57	September 30, 2024

How to copy entire row in one excel and paste in to excel

Related topics