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

[@SunnyAnand-w2t]

Love the way u tell about this .....

[@sujangowda8876]

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

[@Tvs615]

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

[@suryamanikanta788]

Hello Mr. Naveen .Good Explanation,,,

[@kavitamathpati6740]

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.

[@venkatn794]

Thank you so much Naveen for the well explanation.

[@harmanmaan870]

Hi , naveen very nice explanation.

[@NaveenKumar-kv4gu]

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

[@khajazakiuddin931]

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

[@real_hello_kitty]

Thanks! Appreciate. 🙏

[@navenreddyaleti7446]

it's nice naveen

[@kapildharmale319]

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.

[@abraham2961]

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 ??

[@saikirantelapalli8785]

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

[@arunkumarpandey4989]

github.com/naveenanimation20/NewExcelUtil2020_ApachePOI/blob/master/src/main/java/com/excel/lib/util/Xls_Reader.java

[@naweedsharifi84]

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

[@dileepks2319]

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.

[@sureshsubramaniyan3201]

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

[@basasufi5182]

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

[@deep80105]

Better clone the project from Naveen git hub link. All the jar files are mentioned in pom file.

[@kalyanijoshi6884]

Hi Naveen, My excel is getting corrupted while writing to excel. Initial few values are written but as the number of values are written the excel gets corrupted.Please help

[@sainagakumaraswamy3580]

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

[@navyachinnari]

Hi Naveen Sir, Good Morning... I tried this for columns.. But I was stuck in middle... In my webtable page 10 records are there on 1st page... n nxt 10 records on 2nd page... I can able to get d data from 1st page but once the 10th record is completed not able to go 2nd page...How to achieve this.. I tried with for loop but no use... Can u please suggest m any solution for this?

[@ramakrishna3604]

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

[@NaveenKumar-kv4gu]

You should create class with name of Xls_Reader and then you can import form Util

[@arunkumarpandey4989]

Hi guys i have seen a lot of people are asking about the Xls Reader link, so guys below is the github link of XLs Reader github.com/naveenanimation20/NewExcelUtil2020_ApachePOI/blob/master/src/main/java/com/excel/lib/util/Xls_Reader.java

[@AjayKumar-ye2cu]

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.

[@abraham2961]

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

[@justchill298]

Thanks. kindly share complete code of lectures

[@notiues3535]

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

[@khajazakiuddin931]

Hi Naveen, I'm unable to see the package for Xls_Reader in my eclipse. It is not showing any suggestions to import the Util package for the command Xls_Reader reader=new XLS_Reader(Filepath). I've already configured the Apache POI jar files into the libraries. Could you please help me out with this. Thank you.

[@altafshaikh3280]

I'm also facing the same issue.

[@marufsayyed4103]

hi Naveen eclipse is not able to recognize xls-reader can u plz share xls reader jar download link or your xls classpath from github Note: i have added all poi jar then also i am not able to xls reader

[@munnambabar640]

I found an error regarding Xls_reader and cannot resolve it even after adding all Apache POI dependencies

[@arunkumarannamalai5202]

Bro can u tell me how to compare web table with Excel sheet

[@vinayvykuntam3503]

hi naveen, getting error like Xls_Reader cannot be resolved to a type and showing XSSFReader and XSSFBReader in help

[@vinayvykuntam3503]

package naveen; import java.util.List; import java.util.concurrent.TimeUnit; import java.util.*; import org.openqa.selenium.By; import org.openqa.selenium.WebDriver; import org.openqa.selenium.WebElement; import org.openqa.selenium.chrome.ChromeDriver; public class WriteDatatoExcel { public static void main(String[] args) { WebDriver driver; String driverPath = "D:\\NEW DOWNLOA\\"; System.out.println("launching chrome browser"); System.setProperty("webdriver.chrome.driver", driverPath + "chromedriver.exe"); driver = new ChromeDriver(); driver.manage().window().maximize(); driver.manage().timeouts().implicitlyWait(20,TimeUnit.SECONDS); driver.get("www.w3schools.com/html/html_tables.asp"); //*[@id="customers"]/tbody/tr[2]/td[1] //*[@id="customers"]/tbody/tr[3]/td[1] String beforpath= "//*[@id='customers']/tbody/tr["; String afterpath="]/td[1]"; List rows= driver.findElements(By.xpath("//*[@id='customers']//tr")); System.out.println("NO OF ROWS "+(rows.size()-1)); int rowcount= rows.size(); String path = "D:\\selenium excel\\testdata.xlsx"; Xls_Reader reader = new Xls_Reader("D:\\selenium excel\\testdata.xlsx"); for(int i=2;i

[@prakashpohi7314]

thanks for the video ...... how can i join the live class ????

[@naveenautomationlabs]

Send me a mail to [e-mail]

[@ravindrababugogula6927]

@@naveenautomationlabs hii naveen I want Xls_Reader jar how can I get

[@vishaljodwal9647]

Dony know why in my code its writing only one record in excel...top one... But in output all records are coming

[@somukesani0097]

Thank you so much for explaining, Can you please share us the XLS class file path from github

[@ramyakrishnapothem8666]

How to convert multiple tables to excel plz reply me

[@sanjaydwivedi4001]

i am having problem with xls_reader . It showing cannot resolve to a type.

[@deep80105]

Use CellType class instead of Cell.Cell_Type_String for e.g

[@manikantanagudu4967]

How to write the code for .Xlsx

[@anilkumardevaki7014]

How to Append data in excel

[@mdaffan2398]

Your all videos are stretched too long ... otherwise it is very good