How to copy the entire data from one excel to another excel

Help Studio
, ,
1

Hi,

Please help me with the logic how to copy the entire excel column data into another excel.

Sample Excel:
Status_07092022_07_05.xlsx (10.6 KB)

Thanks
Likitha

2

Hi @vinjam_likitha

  1. Use Read range activity → Store it as Dt

  2. Use Write range activity pass the Dt into another excel.

Regards
Gokul

3

Check out the XAML file @vinjam_likitha

CopyDataFromOneExcelToAnother.xaml (5.2 KB)

Regards
Gokul

4

Hello @vinjam_likitha

Do you need to apply some conditions or just need to copy data from one excel to another?

If second scenario you can do as below:

1)Use Read Range on the first excel and get the data to a datatable.
2)Use Write range on the second excel and write the datatable from step1.

If number of input excels are more, you can do as below.

Thanks

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.