Transfer datatable

[Muneer_Alrashdan]

welcome
How can I transfer data from an excel file to another excel file based on similar page numbers ??

[fernando_zuluaga]

Hey

you can use a read range activity to read data from first excel, and then use a write range activity to write data readed into the second excel

Regards!

[Kalimuthu_Kalimuthu (muthu)]

Hi,@Muneer_Alrashdan
First step- Read the second data table and using “Get workbook sheets” activity.
Second step-After using for loop activity pass the variable for “Get workbook sheets” .
Third step-Then you using read range and write range.

if you want more clarification Tell us

Regards!

[Anil_G (Anil Gorthi)]

@Muneer_Alrashdan

If sheets are already present in the destination then use read range and write range respectivey to copy and paste the data

If you need to create sheets as wwll then directly use copy sheet activity to copy sheet from one excel to another…to see this…from activities-> filter icon-> show classic

Cheers