How to get specific cell value from excel with value form another cell

excel
activities

#1

Hello,

first of all, this is a great community from which I got a lot of help in the past.
I’m still not good with Excel though, so here is a question I have.

I have an Excel sheet with 2 columns. I have the string value of one cell from column A in my clipboard (extracted from SAP) (f.e. A5)
How do I get the value from the cell in the same row in column B (B5) as a string value?

Appreciate all the help.

Thanks,
Dustin


How to read specific cell from excel
#2

Hey @ntd

Agree…!! and on Behalf of them Thanks :slight_smile:

Let me know more about it. are you using citrix? and you wants to copy both data at the same time on the clipboard?

Regards…!!
Aksh


#3

Hi Aksh,

no Citrix, just a normal Windows RDP session.
No, in the end I only need data from column B which is an email address, to put it as a receiver into an Outlook mail.

BR!


#4

Hey @ntd

So what is problem you are facing? what you have done so far?

you can simply use “Read cell” Activity to get the column value.

For your Reference:

Regards…!!
Aksh


#5

Seems like I cannot really express myself, sorry.
In your example it works, because you know that is cell B5. But where I am right now, that cell is unknown.
Here is what I have.
The Excel sheet I am talking about looks like this:

What I get from my SAP with a Get Text activity is the name in Column A.
This is a string value now in uipath.
So how do I get the mailadress as a string value when uipath has only the stringvalue Smith as a variable? I need something to connect the name to the correct cell with the mailaddress.

BR!


#6

I found this post, which seems to be exactly my topic, but I don’t know how to put that into my sequence:

Any help is appreciated!

Thanks a lot


#7

You have to first take tall data into the datatable. so use read range activity and it will return output as a datatable.
Fire Datatable.select() method to filter the datatable records.

This link will be helpful for you :slight_smile:

https://www.dotnetperls.com/datatable-select

Regards…!!
Aksh


#8

Hi Aksh,

thank you for your support! I’m using UiPath since friday and I have almost no developing skills. :slight_smile:
Also this article helped me a lot in my task:

Thanks again and have a good week!

Dustin


#9

Hi Aksh,

In continuation with the same example , i am using Select function to get the data row but in my expression:

  1. arrDataRow = Dttable.Select("[ColB] = ‘Anna’") : When using hard-corded value 2, i get my desired outpur which is array of data row but when i am trying to replace it with variable, it is not yielding the output.

My new query is : arrDataRow = Dttable.Select("[ColB] ="+strName)

I tried using many other formats ("[ColB] = ‘+strName’") but was not successful. Could you please check the syntax, what is wrong.

Thanks,
Prachi


#10

arrDataRow = Dttable.Select("[ColB] =’"+strName+"’")


#11

Thanks for your help Aksh. It worked.


#12

Hi, it worked fine for me.

Thanks.


#13

Hi,

By any chance do you have the xaml or code for the same.I also have the similar requirement to get the corresponding value of column 2 based on the value of column 1 got from a web page.

Thanks,
Siva


#14

Hi @aksh1yadav …I have 2 excel and they both have date column in them…if the date matches then i need to write the rows from first sheet to the second…Currently I have first sheet as data row as i had to filter…I am reading range from Second sheet and storing as datatable…Can you please help?


#15

Use a for each of the first datatable, get the row item of the date column and store it as a variable. Do the same for the other datatable and then perform your if condition


#16