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
email@example.com | abcdefgh
I don't want to pass cell number instead, when i pass the email parameter as(firstname.lastname@example.org ) 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.
Solved! Go to 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.
Thank you anupamchampati 🙂
@abishekhari007 Did you get a chance to try what's suggested? What's your result?
Community and Education Specialist