How do i read excel data as key value pair without using cell number
I have an excel file that has data as following
filename - example.xlsx
USERNAME | PASSWORD
xxx@yyy.com | abcdefgh
I don't want to pass cell number instead, when i pass the email parameter as(xxx@yyy.com ) i need to get the password(abcdefgh) value equivalent to the email id as we do in the key value pairing, there are many usernames like that in that excel.
How do i achieve this using testcomplete javascript.
Yes you can do that very easily
I will just write the step you can code on it
1. Open Excel
2. Take the RowCount of the Username cell
3. Use For Loop (increasing i as row no) and check for the Username value you want
4. Once you find the correct i of Username, return the Coloum (PASSWORD) for the same i
Please let me know whether you need some help in the code.
