Excel Data Extraction and Operation

Help
,
1

Hey all,
I need a help in extracting the age data from DataOut.xlsx (8.8 KB) excel and appending it to DataIn.xlsx (8.9 KB) excel based on the data.

The bot should check the names from DataIn excel and according to the names it should check the age in DataOut exce and those ages should be extracted and a new Age column should be created in DataIn excel sheet

Thanks

2

AgeLookup.zip (15.6 KB)

Thanks!

3

@kadiravan_kalidoss Thank you very much

4

@kadiravan_kalidoss In the above xaml, the output will be created as a new sheet in excel.
But, how can the same be saved in the same sheet of excel like below…

Screenshot%20(6)
Screenshot%20(6)764×705 26.3 KB

Thanks.

5

In Write Range activity, replace the sheet name as “Sheet1”.

Thanks!

6

Thanks a lot. @kadiravan_kalidoss :grinning:

7

cheers…Happy Learning…!:dizzy:

8

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