Write WebTable values into Excel Sheet in Selenium with Apache POI API

In this video, you will learn about how to fetch data from web table rows and columns and write data into Excel sheet.

This is the most famous selenium interview questions.

~~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:

Follow me on my Facebook Page:

Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:

WebServices API Automation Tutorials:

Follow me on my Facebook Page:

Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:

Paid courses (Recorded) videos:
📗 Get My Paid Courses at
Paid courses (Recorded) videos:
-------------------------------

✔️SOCIAL NETWORKS
--------------------------------

Support My Channel✔️Or Buy Me A Coffee
--------------------------------
✔️Thanks for watching!
देखने के लिए धन्यवाद
Благодаря за гледането
感谢您观看
Merci d'avoir regardé
Grazie per la visione
Gracias por ver
شكرا للمشاهدة

[kavitamathpati]

Hi, Naveen I have below 3 scenarios
I hope you can write script and explain...I will wait for it
1. Your Business Analyst has asked to write an automation script which can search for iPhones
having a maximum price of INR 40, 000 on Flipkart website.
2. The automation script should be capable of retrieving the device model with storage capacity
and customer ratings.
3. The information retrieved should be saved in a CSV file where data is sorted by Price in
ascending order.

[sujangowda]

Naveen you are a genius.! Thanks a ton.!🙏

[Tvs]

This video was so helpful for me.Thanks naveen a lot for this video

[suryamanikanta]

Hello Mr. Naveen .Good Explanation, , ,

[venkatn]

Thank you so much Naveen for the well explanation.

[NaveenKumar-kvgu]

Hi Naveen, Can you please show me the logic what you written in Xls_ Reader class, to read the data into excel sheet

[khajazakiuddin]

Well explained naveen. Got to know few more things on writing excel data. Thank you so much..🙂

[naweedsharifi]

Thanks for your video it is really informative, I'm trying to do the same thing in side page factory method in the consul it prints the output line by line and it create the sheet and columns in excel but not write the data in rows

[abraham]

Like in this table suppose if I don't want to add any duplicate value or I don't want to retrieve duplicate value then ??

[kapildharmale]

Hi navin, thanks for the video, but im not able to find or use the xls reader after created xls class and also added apache poi jar files too.can u please help me out, is there any other specific apache jar file version which s
I need to add into library.

[sureshsubramaniyan]

Yes, , it is famous interview question not got an answer... could you explain how to insert data in excel for specific cell.. Thanks for your effort

[AjayKumar-yecu]

Hi Naveen Sir.. Please can you refer the video for a scenario where we can continue our test even if any none get failed and we want to continue script.

[dileepks]

Hi Naveen, That was a nice video. I have a doubt here? What if the sheet exist but column does not exist?, How do we handle this since reader object will come out of the loop.

[saikirantelapalli]

Hello Naveen, thanks for this video. Can you please share us the XLS class file path from github

[sainagakumaraswamy]

Naveen how can I apply bold font and color to text using xls_reader. Kindly share a video for that.

[abraham]

Hi Naveen here you are fetching data from web table and writing it on excel and if we want to verify that data is correct or not then how to do that

[basasufi]

Hi Naveen,
Please help me out, I am practising on this but for Xls_Reader I am not able to find and jar file.

[ramakrishna]

Hi Naveen thanks for this video, which dependency or jar we are used for Xls_Reader class?

[justchill]

Thanks. kindly share complete code of lectures

[notiues]

can we do it from excel to Contact and save in in freeCrm