Check and copy data between 2 excel files

Help
1

This is my class assignment
I have a problem
How to copy column “Status = unregistered” in book2.xlsx to book1.xlsx
Can someone help me, pls?

Untitled
Untitled1920×1080 74.3 KB

2

@Th_nh_Nguy_n_Cong

Welcome to the UIpath Community.

  1. use Read Range Activity to read data from book2.xlsx file and will give you output as dataTable say ‘DT’

  2. In Assign, newDT = DT.Select(“Status = ‘unregistered’”).CopyToDataTable

  3. Then use Append Range Activity and pass the “newDT” to append data to book1.xlsx file.

1 Like
3

Hi @Th_nh_Nguy_n_Cong

Assign newdt=dt.Select(“[status]=‘unregistered’”). copy todatatable ()

Use write range of dt to book1

Thanks
Ashwin.S

1 Like
4

thanks guys. IT WORKS NOW :DDD THANKSSSSSS

1 Like
5

thanks guys. IT WORKS NOW :DDD THANKSSSS

6

@Th_nh_Nguy_n_Cong

Could you please close this thread by marking my above post as solution.

7

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