Excel search and copy

[Mayank_mehta]

Hi all, I have 2 sheets in a workbook, from 1 sheet, from 1st column I need to take cell value search it in 2nd sheet, if the value is found I need to copy the value from 3rd cell and paste it in 1st sheet in 3rd column. and need to do it for all the rows.

[balupad14 (Balamurugan)]

Hi @Mayank_mehta,

Welcome to UiPath Community!

• To search the value, you can use the below activity. It will return the cellinfo and Row Index. They are array.

UiPath Go ! BalaReva EasyExcel Activities

Hi , Here is the video demonstration for find , find and replace. Sample Project : 23FindReplace.zip (94.8 KB) Video : [Uipath Excel Find | Search | Find and Replace (BalaReva)] Thank you Balamurugan.S

Video :

Uipath Excel Find | Search | Find and Replace (BalaReva)

• To Copy Paste you can use this one.

Uipath excel copy paste data | Uipath clipboard to datatable

Sample :

UiPath Go ! BalaReva EasyExcel Activities

Dear All, I have explained in the video. how to copy paste data inside excel using UiPath studio how to copy paste data one excel file to another excel file using UiPath studio how to convert the clipboard data to datatable. [Uipath excel copy paste data | Uipath clipboard to datatable] Sample : 29_CopyPastDataTable.zip (98.7 KB) Thank you Balamurugan.S

Regards
Balamurugan.S

[Srini84 (Srinivas Kadamati)]

@Mayank_mehta

Welcome to forums

You can search in my videos which you can get few info for your reference
https://forum.uipath.com/t/tutorial-how-to-check-a-string-is-present-in-excel-sheet-part-1/243696/2

Hope this helps you

Thanks