Forum Discussion

abishekhari007's avatar
Champion Level 0
4 years ago

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   |  abcdefgh   I don't want to pass cell number instead, when i pass the email paramet...
  • anupamchampati's avatar
    4 years ago

    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.