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?
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.
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.
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.
In continuation with the same example , i am using Select function to get the data row but in my expression:
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.
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.
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?
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