Search for data in Excel file and copy data

[achalisma]

Hello everyone,
I hope you are doing well. I am creating a quite (for me) difficult robot.
I have an Excel sheet where I have some data. I copy the data from somewhere else and search it in the Excel sheet by sending the hotkey ctrl+F. Then I press enter and find the data. Now I need the data from the first column in the row where I searched the first word (ctrl+f). This cell needs to be copied then as well but first of all I need a solution for the first case.
I share a screenshot which makes the problem more comprehensive:

Basically I search for the word “blabla” so that I get the row I need in order to find “uipath”. I am only allowed to use the word “blabla” to find “uipath”. Also external packages can’t be used as well like BalaReva or some others.

I would be very grateful if you can help me.

Kind regards

[achalisma]

Actually the word I search for is stored in a variable because the word changes when I repeat the process. When I display a message box I can see the word I need to search for so that might help but I don’t know.

[balupad14 (Balamurugan)]

HI @achalisma,

Take a look at this thread.

Excel search and copy

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. 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 : Regards Balamurugan.S

Thank you
Balamurugan.S

[prasath17 (Guru)]

@achalisma - could you please show us what is your progress so far ? And share the workflow?

[NIVED_NAMBIAR (NIVED N)]

Hi @achalisma
Check this workflow
email.zip (41.4 KB)

Hope it helps you

Regards
NIVED N
Happy Automation

[veeraragavelu.gunaseelan]

Look data table activity

[achalisma]

@NIVED_NAMBIAR
Thanks for replying!
Actually this is the only thing I see
Maybe a screenshot can help

[achalisma]

Here it is:
Process.zip (41.9 KB)

[achalisma]

Sadly it didn’t solve my problem, but BalaReva is not allowed in my workplace anyways

[NIVED_NAMBIAR (NIVED N)]

Hi @achalisma this is the overall view of the workflow

Property panel of excel application scope

Property panel of read range

property Panel of Lookup Range

Property Panel of Matches activity

Hope it helps you

Regards
Nived N
Happy Automation

[mmcruzRPA (Marcelo Cruz)]

Check dependencies and repair the ones in fault to solve this error!