Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

excel activites

How to retrieve the whole row of a matched value in excel?

 Ex:

If I'm matching with the ID in the excel I should retrieve the whole row (Name and Place) 

Can someone please help me with this?


Thanks in advance.


Capture.PNG
(3.1 KB)

Best Answer

Hello Jenice,


You can go with a part of logic that can be seen from the screenshot below:


If excel contains huge amount of data it is better to execute SQL Queries to Ms Excel. You may refer  to this article for more info.




The fastest way is using sql query.



SELECT *

from [Sheet1$]

where [ID] = 121




1 person likes this
ADMIN
Answer

Hello Jenice,


You can go with a part of logic that can be seen from the screenshot below:


If excel contains huge amount of data it is better to execute SQL Queries to Ms Excel. You may refer  to this article for more info.



Thank you so much for helping out.

Login or Signup to post a comment