How do i read excel data as key value pair without using cell number

[abishekhari007]

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.

[anupamchampati · Accepted solution]

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.

[sonya_m]

Thank you anupamchampati 🙂

@abishekhari007 Did you get a chance to try what's suggested? What's your result?