Forum Discussion

abishekhari007's avatar
abishekhari007
Champion Level 0
4 years ago
Solved

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.

2 Replies

  • anupamchampati's avatar
    anupamchampati
    Frequent Contributor

    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's avatar
      sonya_m
      SmartBear Alumni (Retired)

      Thank you anupamchampati ğŸ™‚

       

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