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 paramet...
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.
