Apache POI Tutorial Part7 - MS-Excel with Java Hash Map

[@bhadaribasanta7]

That would be very helpful if you upload video, reading excel data if the key is column headers and value is located on multiple rows :)

[@deepakchaudhary9569]

very good work sir, one single place to learn automation with Latest material

[@sdetpavan]

Thanks

[@suprabathj7843]

Nice one

[@sdetpavan]

Thanks

[@muneet4079]

Nice one!

[@sdetpavan]

Thanks

[@satyahari2238]

Thanks for great lecture I have a question. How do we pass these parameters in send keys function? ... In map we get key value pairs but send keys accept only one string value at a time... How to approach this scenario. I belive... Map. Getkey("username") I think this will work but all value inputs it entered in send keys function.. But I need one single string value to be enter

[@sivan2878]

Well explained

[@sdetpavan]

Thanks

[@CricMedia-w5n]

@sdet Pavan, When am trying to read the integer value from excel it shows illegalstate exception, but it read string value, could you please give a solution

[@samratjulme8418]

thank u so much sir from bottom of my heart....❤❤❤❤❤❤❤

[@sdetpavan]

most welcome

[@KkdvPrasad]

@SDET Pavan WHERE do I get this source gode for this apace poi videos

[@swarnaumavlogs4769]

Could you please explain how to import complex json data into Excel and read that data from Excel to hashmap??

[@sourabhchougule5642]

sir please make tutorials on dropdown its very important topic....

[@KkdvPrasad]

@sdet Pavan, After reading from Excel , again after reading from hashmap, how to put each value in field, if I have 10 fields in a form, I want to send each hashmap value

[@sdetpavan]

HashMap will be preferred if you have data in key value pairs.

[@KkdvPrasad]

@@sdetpavan My question is how to send the hashmap value to application, ex form has 10 fields first field o written like 1 for 10, second field 2 for 20 like that 10 sets of data , how do I pass this data to fields in form which is in the application?

[@pratiksonkusale7570]

Sir I want to ask how we can fetch data from excel and convert into nested HashMap.Can you just provide the code

[@shubhamjha9206]

sir i need your help

[@luiscevallos1]

part 7 about apache poi? or part 7 about other subject

[@sdetpavan]

it's same subject. Apache POI