How to read value from excel and execute it as command?

excel
#1

Hello Experts,

Please help in following problem.

Problem Statement : we are looking for an excel which contains some data like website name, login details and want to try out different user logins so how we can handle it? please brief about how UI path will read the value from excel and execute it, say like excel contain website as www.gmail.com and contain username & password.

Thanks in advance!

#2

@apurva.karandikar4 use foreach loop of dataTable to try different logins. Each time loop execute it will take new values for username and password.

#3

@apurva.karandikar4 attached file may be useful check it

ExlExample.zip (12.5 KB)