@1:28 creating a package for utility @2:53 importing opensource Excel Util into utility package @3:22 viewing all methods present in Excel Util @4:58 Downloading and extracting Apache POI library @7:49 importing JAR files of Apache POI library into project (@8:57 Ignore this JAR file.) @9:34 Renaming package of Excel Util @10:50 Creating a package for Datadriven Test. @11:09 Creating a Datadriven Test class under the package. @11:45 Creating a Excel file @12:04 Renaming Excel sheet @13:06 Choosing a site to automate @13:34 Entering data to Excel according to site fields @15:06 Entering our desired data on Excel according to the site fields. @16:20 saving Excel file @17:24 creating a package and moving a Excel file into it. @17:51 closing Excel file and opening Excel file which was present in the project. @19:13 Writing code of invoking browser and opening the site in the Datadriven Test. @19:20 Running the code. @20:03 Creating a object for Excel JAVA file in the Datadriven Test. @20:42 Giving Excel file path to the Datadriven Test. @23:10 Writing a code inside Datadriven Test to fetch data of single row of a column from Excel file. @25:28 Printing that single cell data into console without invoking browser. @26:44 Writing code for fetching the data from remaining rows of that same column and importing into the Datadriven Test. @27:43 Giving names for all String variables. @29:51 Writing code for locators of site input fields into the Datadriven Test. @30:23 Passing String variables to locators. @31:43 Writing locator code for dropdown menu into the Datadriven Test. @35:19 Running the code. @37:22 Adding multiple entries into Excel file. @40:13 Creating a class for parameterizing those multiple entries under package consisting Datadriven Test. @42:23 Using "for loop" to fetch the data from multiple cells from single column of Excel file into this parameterizing class @46:47 Printing the data of multiple cells from single column. @48:31 Writing and printing the code to fetch the data from multiple cells from remaining columns of Excel file into this parameterizing class @50:02 Printing the data from multiple cells in a organized manner. @50:57 Inside "for" loop, writing code for locators of site input fields into this parameterizing class @51:26 Running the code. @52:40 Optizimizing the code to stop multiple invokings of a browser for entering the data into site input fields. @57:29 Running the code.
@naveenautomationlabs2 жыл бұрын
You can find the latest Excel Reader util with apache poi api 5.x versio: github.com/naveenanimation20/ExcelUtil
@vaishnavijaiswal11902 жыл бұрын
@@naveenautomationlabs Hi Naveen I follow all the steps but not able to read some fields from Excel sheet can you please help me with that?
@HitManav2 жыл бұрын
@@vaishnavijaiswal1190 You can check other video of him
@iyerakhila1235 жыл бұрын
Naveen you have explained this concept brilliantly! I regret not having watched this video last week when I had an interview. They asked me this question- "How do you read the data from excel file?".
@naveenautomationlabs5 жыл бұрын
Thanks for watching Akhila
@parvathidevi92894 жыл бұрын
what u answered for this question
@ksdnsdkumar13752 жыл бұрын
@@parvathidevi9289 Answer is APACHE POI library.
@nasruddinmaniyar53256 жыл бұрын
How simple your explanation was... Wanna hug you for the beautiful explanation....
@naveenautomationlabs6 жыл бұрын
Thanks for watching buddy
@nasruddinmaniyar53256 жыл бұрын
@@naveenautomationlabs that was the first video I just watched...need to finish all your videos asap... Thanks alot...
@nikitaagrawal7903 жыл бұрын
Hi Naveen, Your explanation is so simple even I used same explanation in my all interviews and all the interviewers are so impressed by the way I explain the concepts. Thank you so much for all the videos. kudos to you sir!
@harish37873 жыл бұрын
Excellent.... you are the best selenium teacher on KZbin .. You give real world example I learned a lot from you.. hope will get placed soon..
@naveenautomationlabs3 жыл бұрын
So nice of you
@priyasai9356 жыл бұрын
Thank you so much Naveen. I'm your new subscriber. These days, finding a good tutor online is a major first step in the learning process. I'm so happy that i found you. Thank you.
@shravankumar-ro9uk4 жыл бұрын
agree
@user-qy2kv9sx9m Жыл бұрын
Thanks for the concept explanation. It will solve my problem in automation.
@SubbuTube4 жыл бұрын
Hi Naveen, thank God I found your channel. You explain things so simple and in detailed way that any person can understand and learn selenium. Thanks for the good work
@jannatulnayeem68585 жыл бұрын
Just thinking, how do you explain so easily and clearly, it's very useful, Thanks Naveen for the videos....
@mariajurovata4 жыл бұрын
Great video, great utility, great explanation, thank you very much. Only problem was with Apache POI, but downloading older version (3.6) fixed all the errors.
@naveenautomationlabs4 жыл бұрын
Hello All, Sharing the latest Excel Util - Xls_Reader class used to perform read/write operations on Excel files. This util is having all the latest dependencies as per Apache POI api - 4.x.x version. You can get this util from my GIT Repo: github.com/naveenanimation20/NewExcelUtil2020_ApachePOI/blob/master/src/main/java/com/excel/lib/util/Xls_Reader.java
@jeevanesh254 жыл бұрын
Thank you Naveen..
@piyushmathpal42444 жыл бұрын
Hey @naveen Can you please make a quick video on how to perform data driven testing using google spreadsheets. I think this will help a lot to everyone.
@swapnilkale70394 жыл бұрын
hey Naveen - for zip-code here it is reading as 94085.0 instead of 94085, in my code also password field is returning extra .0 could you please help me out on this?
@naveenautomationlabs4 жыл бұрын
@@swapnilkale7039 use '94085 in your excel.
@daxeshshah49824 жыл бұрын
Hey @@swapnilkale7039 ,Have you find any solution, I am facing the same issue
@qal63344 жыл бұрын
Thank you from the heart Naveen Sir for your contribution to Tester community
@omkarpotdar2763 Жыл бұрын
Thanks a lot Naveen for explaning the data driven approch in simple words. Your videos are always helpful for interviews & project perspectives. Keep it up🙂
@manishasehgal24013 жыл бұрын
Hey Naveen....your videos are quite useful. One thing I really like is your focus is always on to enable people to code/automate rather than just describing how to achieve specific task. Keep it up....Thank you so much.
@someanimation68074 жыл бұрын
I am new To Java and Selenium, I will get a job within one month just watching Naveen videos.
@rohithreddy88374 жыл бұрын
I have watched many videos and still I was in big question mark. But this video really helped me.Thanks Naveen.
@pravinkokadwar32092 жыл бұрын
Super cool explanation !!!
@vsu12255 жыл бұрын
Great Work Naveen,Thanks a lot ,All your videos are useful to my job career .
@purushothamareddy93965 жыл бұрын
Thank You Naveen, Your Explanation is simply amazing...
@shravankumar-ro9uk4 жыл бұрын
after searching a lot i got easy explanation Thank you Naveen
@somukesani00975 жыл бұрын
Mind blowing Explanation Naveen garu. Thank you so much.
@nisharaj91323 жыл бұрын
Thank you for your crystal clear explanation Naveen!!
@amitkhosla84745 жыл бұрын
You are great person, God bless you :)
@akshathadinesh10115 жыл бұрын
Amazing Explanation, it's very useful, Thanks Naveen for the videos !!
@MamtaRani-to4ns3 жыл бұрын
How beautifully this is explained. Thanks so much, Naveen !!
@alinakuch31464 жыл бұрын
What a wonderful explanation! Thank you.
@jackft66454 жыл бұрын
before watching video i liked beause of u naveen
@paritapatel21092 жыл бұрын
Hi Naveen, you are such an excellent teacher, explaining everything in a simple manner ,so learners can understand easily. Thank you so much for all your support. keep it up.
@monikkap23084 жыл бұрын
Excellent way of teaching...
@manoranjankumardubey17064 жыл бұрын
This is very good and awesome!
@sarojasaru44732 жыл бұрын
Simply superb sir, very easy to understand sir,👌🏻
@ManishKumar-ow2ew4 жыл бұрын
Thanks a lot naveen. You have explained it so nicely.
@sailynagarkar11994 жыл бұрын
very helpful video ...easy to understand. Thank you so much sir
@vishnu-oz5yo5 жыл бұрын
Dear Naveen, Your videos are awesome and easy to learn. I have a query regarding reading blank cells. I am using apache poi 4.0.0. i am able to get only celltype.BLANK and my test ng code is not taking blank cell as blank and it goes to catch block.please help me resolve this.
@premtripathi8254 жыл бұрын
Thanks for ur amazing work... Its really inspiring
@themusicblaze26925 жыл бұрын
HI All, you guys can refer updated xls_reader file. Below is the url. drive.google.com/open?id=0B2i0eXr3_uQDSFpkUElzNGNkYm8
@naveenautomationlabs2 жыл бұрын
You can find the latest Excel Reader util with apache poi api 5.x versio: github.com/naveenanimation20/ExcelUtil
@username12345ghvvv10 ай бұрын
Hi Naveen, I am getting below error while trying to run the code: org.apache.poi.poifs.filesystem.OfficeXmlFileException: at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:152) at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:140) at org.apache.poi.poifs.filesystem.NPOIFSFileSystem.(NPOIFSFileSystem.java:302) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:413) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:394) at Excel.Utility.NALExcelReader.(NALExcelReader.java:56) at DataDriven_Testing.Ebay.main(Ebay.java:33) java.lang.NullPointerException at Excel.Utility.NALExcelReader.getCellData(NALExcelReader.java:84) at DataDriven_Testing.Ebay.main(Ebay.java:34) row 2 or column firstname does not exist in xls Can anyone help me.
@tayyabzaffar6974 жыл бұрын
your utility really helps a a lot thanks
@MegaSoumya12 Жыл бұрын
Acha padhaya Hai bhai...
@sridevidurga53175 жыл бұрын
Thank you so much for this video. Its help me a lot.
@shabreentaj10404 жыл бұрын
Thank you so much Naveen :) Its an amazing tutorial to learn !
@naveenautomationlabs4 жыл бұрын
Thanks for watching :)
@vishnupandey35135 жыл бұрын
Brilliant explanation..... great teaching technique.
@paramjitbhuller592211 ай бұрын
Just today i got a lecture on it . She did not told all that . Just explained the code that is already written and I was thinking that all that i have to write,
@santanunayak44025 жыл бұрын
Really great explanation....many thanks Naveen...
@shoyebkhatib80845 жыл бұрын
Great explanation Naveen, hats off
@momentsoflife3563 жыл бұрын
Thank you so much Naveen!! I couldn't find any better videos than this. You are like an angel for us :) And Please let me know how to purchase. Its declining the transaction even after adding correct details
@naveenautomationlabs3 жыл бұрын
Mail me at naveenanimation20@gmail.com
@asmarazaq91224 жыл бұрын
Hi Naveen, yu are simply awesome your way of teaching is very impressive indeed. I have got an issue with my test cases I am running on Mac book. The script is accepting neither chrome nor Firefox . It says driver is not executable
@naveenautomationlabs4 жыл бұрын
Plz mail me at naveenanimation20@gmail.com
@apoorvachatla23485 жыл бұрын
Hi Naveen, thank you so much for such a clear explanation, you rock. I have a doubt when i added Xls_Reader class , i am getting few errors 1. XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE); error: LINK_FILE cannot be resolved or not a field. 2.style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); error: SOLID_FOREGROUND cannot be resolved or not a field. 3.style.setFillPattern(HSSFCellStyle.NO_FILL); error: NO_FILL cannot be resolved or not a field. Please Help.
@jeeteshvarma5 жыл бұрын
download Apachepoi 3.17 version mentioned in the links below the video
@krishna_raj93315 жыл бұрын
Great work sir... Thanks 👌👌
@PiotrPiotr-mo4qb5 жыл бұрын
For all who have problems with Xls_Reader just do what Naveen was doing on the video but... I had the same problem as you. To solve problem in InteliJ in the dependencies all POI Jars should be on the top of the list ☺
@Srhnu4495 жыл бұрын
i didnt get you. i am getting continuos errors pls help me out ... top of the list means .. r u saying that external jars should be in the top of the list what we have added ?
@PiotrPiotr-mo4qb5 жыл бұрын
@@Srhnu449 Yes, I am using Intelij. Watch video carefully to make sure that you are adding all poi dependencies from all folders, and then move them up on the dependencies list.
@Srhnu4495 жыл бұрын
r u facing any issues after moving them up. pls tell me .can we connect anydesk session pls . i have an interview after three days . pls help on this.
@PiotrPiotr-mo4qb5 жыл бұрын
@@Srhnu449 w8 a second, I am going to work. In some hours I can help you. But please text me.
@Srhnu4495 жыл бұрын
@@PiotrPiotr-mo4qb sure man thanks for your help ... will wait here
@nehamirpagar63936 жыл бұрын
Thanks for the video. You are an awesome tutor!!
@lavanyadasari2305 жыл бұрын
Amazing teaching Mr Naveen, Thank you for the detailed videos. I subscribed to your channel.
@tusharkhade106 жыл бұрын
Your all videos are good but need to zoom because not snowing some words clearly. Pls always take care about that.
@alka2402804 жыл бұрын
Awesome Explanation!! Thanks a lot.
@Suganthdeepak4 жыл бұрын
Thanks again for ur amazing work... Its really inspiring
@footprints24894 жыл бұрын
Thank you so much for this video Naveen ...
@avinashthakur75546 жыл бұрын
Superb explanation Naveen...hats off
@ManojGupta-kx9qv5 жыл бұрын
Awesome explanation , Thanks a lot Naveen
@bharathi802055 жыл бұрын
HI Naveen, How do you do? I'm continuously following your videos and it's awesome! Can you add the video for that to perform excel operations like copy data from one excel to another, how fetch the specific conditions data(Example: i want fetch the employee names whose salary greater than 1000 like that)
@ksdnsdkumar13752 жыл бұрын
That's not possible.
@mamathagarlapati4 жыл бұрын
Excellent explanation...
@binnymartin14552 жыл бұрын
i have to read only 3rd row data from the excel sheet then how can i break the loop and fill only the 3rd row data ??
@nitingupta824 жыл бұрын
Hi Naveen! Please update upon the POI Jar Version to be used so that one does not get Error(s) in Xls_Reader File. Many are facing issues by using the latest version of POI i.e. 4.1.0! Thank you!
@ritu.a.mullurritu.a.mullur46336 жыл бұрын
Hey Naveen thank you , you're videos are very helpfull:)
@madoneu1114 жыл бұрын
Nice and good explanation, videos are awesome and it's very clear. Please let me know how to train from you(Paid), wanted to learn Selenium in more detail.
@memeguycool45812 жыл бұрын
Hi Naveen I follow all your videos because you will cover all end to end concepts so that we cannot miss any important question in the interview. Could you please confirm me Is it possible while executing the selenium scripts I wanted to get all the 6 rows data like(Invoice) from the excel sheet to be executed within a single browser by clearing each data
@prajaktabadarayani81375 жыл бұрын
"CELL_TYPE_BLANK cannot be resolved or is not a field" type error we are facing. Please suggest solution
@rameshwarkachhave23282 жыл бұрын
Hi Naveen, Thank you for making videos and giving knowledge to us. Can you make a video for complete framework design? In so many interviews, they are asking like"Have u involved in framework design"? every time i am saying no only and i don't know how it look like. can you please help on this.
@atulughade4 жыл бұрын
Thanks naveen
@mamtanandurkar8680 Жыл бұрын
Nice
@iftekerahmed4 жыл бұрын
thanks a lot guru. I think this video should be in your testNG playerlist, this one is missing over-there, if I am not wrong.
@ramkumartalatam55074 жыл бұрын
Thankyou so much Naveen.
@narendrasharma97676 жыл бұрын
Replace the errors with XSSFHyperlink link = createHelper.createHyperlink(HyperlinkType.FILE); style.setFillPattern(FillPatternType.SOLID_FOREGROUND); style.setFillPattern(FillPatternType.NO_FILL);
@poojagoel33655 жыл бұрын
I was also getting this error. Thank you for the solution
@myfocus74476 жыл бұрын
useful. thanks for sharing
@thiery5726 жыл бұрын
Interesting utilities...
@desuteja5024 жыл бұрын
Sir,at the time of entering zip/postal code in the website,it is taking the values as float data type in the website(zipcode=123456.0),, may i know why such thing is happening.
@gayatriganyarpwar20905 жыл бұрын
Awesome videos by you Naveen, yesterday asked same question but was unable to answer. It will help me in Future. My question was, How to get data from 3rs row and 4th column?
@pragyasahu19914 жыл бұрын
Hi Naveen, Can you please upload videos on Automation using Qualitia Tool? It will be really very helpful.
@tejkumarkempaiah49065 жыл бұрын
when i print the value for row_count with rows having data upto 5 rows, The S.O.P statement for row_count gives me 1000. Please suggest. Code: package com.datadriven.test; import com.excel.utility.Xls_Reader; public class ParameterizedTest { public static void main(String[] args) { Xls_Reader reader = new Xls_Reader("C:\\Users\\Tejkumar\\Desktop\\DataDrivenFramework\\contactform.xlsx"); int row_count = reader.getRowCount("contactform"); System.out.println(row_count); } } Output: 1000 Expected Output: 5 Actual Output: 1000
@rihaskh5 жыл бұрын
Some of the keywords in XLS_reader.java (Like XSSfF,HSSF)are not working in latest version of POI
@AbhishekKumarChainy4 жыл бұрын
Rihas Hassan refer this docs.google.com/document/d/1Qg_-iIKCOe0OO2wMiyBcF3bXStH6PzXg7UM49bAsXmI/edit?usp=sharing
@ankush85854 жыл бұрын
@@AbhishekKumarChainy Can you please the dependencies for this?
@naveenautomationlabs4 жыл бұрын
Hello All, Sharing the latest Excel Util - Xls_Reader class used to perform read/write operations on Excel files. This util is having all the latest dependencies as per Apache POI api - 4.x.x version. You can get this util from my GIT Repo: github.com/naveenanimation20/NewExcelUtil2020_ApachePOI/blob/master/src/main/java/com/excel/lib/util/Xls_Reader.java
@lakshmikanthlucky55595 жыл бұрын
Hi Naveen, I am not able to import Xls_Reader package.. can u tell me the solution
hi naveen ..Excel Utility java code , there is error as below: CELL_TYPE_STRING cannot be resolved or is not a field CELL_TYPE_NUMERIC cannot be resolved or is not a field CELL_TYPE_FORMULA cannot be resolved or is not a field CELL_TYPE_BLANK cannot be resolved or is not a field please reply as soon as possible, i cant move without error correction
@venkatabhargav35185 жыл бұрын
Hi I got the same error. Are you able to resolve it? If you have, please tell you how you did it?
@justinlambert71094 жыл бұрын
Hi , Here you have entering values from data sheet , but without doing any action my question is how can we entering values and validate by click submit button and then entering next data set from sheet and validate?
@dada62355 жыл бұрын
This is so awesome..
@deshandaniel55846 жыл бұрын
Hi Naveen... pls to upload explaination of data driven framework "Xls_Reader" class inside utility package...i'm begineer ..so concern my test
@archanajain49136 жыл бұрын
Thank you so much Naveen for sharing :) I am trying to automate google account creation page but for the field 'Month' in Birthday section i am getting following error when trying to select month:-- Exception in thread "main" org.openqa.selenium.support.ui.UnexpectedTagNameException: Element should have been "select" but was "span" Can you please guide me how to handle this ?Thanks in Advance
@jaykishoreduvvuri75986 жыл бұрын
Hi Naveen, Very nice Explanation! Incredible Job! keep up the good work, Thank You! I have one question how do you get Number/ digits from the excel for example - Telephone number from excel?
@chundurusukumar38474 жыл бұрын
Hi Naveen I have a query. I have 3 sheets in my workbook and 3 methods. Each sheet is for one method first time when I Should be able to read 1 first row from 1st sheet and pass to 1st method , 1st row from 2nd method and pass to method 2 1st row from 3rd sheet and enter to 3rd method like this I want to execute can you please tell me how can we do this ?
@abraham29615 жыл бұрын
Hi Naveen here u r writing column as hard code value if we don't want to hard code this we should take it in global variable just like rowcount you have written in this class as variable and we also need to Tak 2nd for loop for column is it so please rectify me if I m wrong thanks Naveen
@sainiranjan405 жыл бұрын
Never mind I fixed it. - Earlier versions - Cell.CELL_TYPE_STRING - In Latest versions (4.1.0 poi) - CellType.STRING
@lavanyadasari2305 жыл бұрын
I tried your solution and that helped, but i still see few more errors. Can you please tell me how to fix the below errors, Thanks in advance style.setFillForegroundColor(HSSFColor.GREY_40_PERCENT.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); and style.setFillPattern(HSSFCellStyle.NO_FILL);
@devendrapawar24254 жыл бұрын
I am also getting the same issue. Please suggest what to do? CELL_TYPE_STRING CELL_TYPE_NUMERIC CELL_TYPE_FORMULA CELL_TYPE_BLANK LINK_FILE GREY_40_PERCENT SOLID_FOREGROUND
@parvathidevi92894 жыл бұрын
sir could pls help me how to resolve the errors
@stayfit33834 жыл бұрын
i also facing this errors
@avishekbehera6 жыл бұрын
Why don't we use maven and POM to use dependencies instead importing jar files? amazing work and nicely explained though, thank you.
@naveenautomationlabs6 жыл бұрын
In other vdos I have explained with maven as well. Thanks for watching
@cynoldias74406 жыл бұрын
Can you please tell me in which video you have explained?
@Pravi_FireBreather5 жыл бұрын
Naveen sir, can you please make a video to read data from powerpoint slides.. Specifically to differentiate the various objects like graph, text, table etc in the slide . Also, wanted to know how to compare the table data from the PPT slide and database table data..
@sandipb88222 жыл бұрын
thank you...!!
@RehanSayyad-ir7jx2 жыл бұрын
This Error Will doing Excecution😟😟 import org.apache.poi.hssf.usermodel.HSSFDateUtil; Please Reply
@tausiffiroj20964 жыл бұрын
Hello sir, I have one question suppose there is multiple data in excel sheet but we don't know the count of that data which is store in excel sheet but i want to read one particular data from excel sheet then how we will read particular data from excel sheet .
@muthinenirajasri3366 жыл бұрын
XSSFHyperlink link = createHelper.createHyperlink(XSSFHyperlink.LINK_FILE); im getting an error at this line even after adding all the jar files.
@shrutiprajapati45245 жыл бұрын
Hyperlink link = createHelper.createHyperlink(HyperlinkType.FILE); use this
@aratisingh38514 жыл бұрын
Hi Naveen, your video is very good. Have one small question. I have added date column in my excel and passed value "7/12/2020", but i run the code, in console i see the data being displayed as 12/60/20. Can you please help with this
@909praveen6 жыл бұрын
Hello Naveen, I have followed all your videos and when it comes to the Excell utilities I am facing issue with the "Xls_Reader" and I have gone through some other videos or websites all the members used " Xssf or Hssf workbook" classes to retrieve the data or to set the data . Could you please let me know whats the difference between Xls_Reader and Xssf workbooks and also let me know why are we unable to import Xls reader class even after adding Apache poi jar files .
@sandeep1234525 жыл бұрын
Yes, am also facing same problem. unable to import Xls_reader with Apache POI library
@SANATANIAMERICA5 жыл бұрын
Thank you so much naveen ,very useful and explained clearly ! By the way when I am paste the Java file after adding all jar , I am getting error message for few like " can not be a removed type or is not a field " , could you please kindly help
@closetonature24996 жыл бұрын
HI Naveen, Thanks much for sharing wonderful videos on selenium. Please help on how to navigate or the order of learning in posted videos. I see different play lists but not sure on order. Java, selenium locators after this what should I start?
@ashishmishra72144 жыл бұрын
Hi naveen I have a question, What if my registration page is in dyanamic in nature for example: My next input in form will be dependent of my previous values in that case, do I need to write all the possibilities in Excel sheet or any alternatives to that? revert please