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
Hii naveen this video is so helpful and the only issue i have is.... I have to call a mobile number & the code is like getNumericCellValue which is returning me double value.. can you please help me out by changing it to int or long?? I tried type casting ,wrapper classes & math round.. any other possible way??
@6:16 Creating a class inside package which is consisting Datadriven Test. @6:53 A code to invoke browser and opening a site using @BeforeMethod annotation. @9:06 A code to quit browser using @AfterMethod annotation. @9:49 Writing testcase for locators of the site input fields. @14:03 Passing suitable parameters for testcase. @15:58 Using DataProvider annotation to pass data to the testcase. @17:03 Creating a utility package and inside that package, creating a class. @17:32 Importing opensource Arraylist method inside class belonging to utlity package. @20:00 Giving Excel sheet to the class belonging to utility package. @21:22 Correcting "for" loop according to Excel sheet. @24:43 Creating an object array to store existing String values. @25:52 Adding the object array into the arraylist. @28:03 Calling that Arraylist method into DataProvider annotation of testcase @29:05 Writing an method to iterate an arraylist. @30:40 Passing Iterator method from DataProvider annotation inside testcase @34:48 Running the code.
How cool it is !! We are going to read data from Excel to DataProvider and then that DataProvider is going to feed data to various methods in application for Processing. Thank you Naveen !!
I have viewed about 10 different instructors videos but among them all Naveen Sir's videos are top on the List, the way explanation given is really kool Thank you Very Much sir for your Greatest Help
Hello Naveen Sir, Namaste, I am the Big Fan of you Sir, You have posted this video 3 years back but still helping me and like such kind of students lot of there. Really clear explanations sir. You have put the seeds before 3 years it will grown today as big tree we peoples are utilizing like shadow. Your are big contribution in Testing Industry Sir. Thank for your once again. Please Keep Posting Sir. :)
Thank you so much Naveen. Very helpful. Your are spot on. Detailed Explanation. Anyone can Understand. Data Provider concept is required for my full project.
Hello @@kenjalgundecha5870 , you can get Xls_reader class here, github.com/naveenanimation20/SeleniumJavaCourse/blob/master/src/com/excel/utility/Xls_Reader.java . its basically a custom call that Naveen has written for the AUT.
Hi Naveen, When we are working on end to end testing, we work on multiple pages and for every pages we have to pass different test data. e.g. we login the page and go to second page and do some verification and go to third page do some calculation and verify the result. As we are not passing multiple set of data for one page and we are dealing with multiple page at one time, In this case which framework(Data Driven, Hybrid etc.) will be suitable? Or how we can achieve this using framework structure?
Hello Naveen, Can you please share the link for the previous video where u created the excel and created all the Apache POI operations. Thanks in Advance.
Hi Naveen, firstly, I follow all your videos of selenium tutorials. And they all are very clear with excellent explanation. Would like to say thank you for that. Secondly with this video above how do you do validation of the testcase. Please explain. Thank you
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
hi naveen, In Xls_reader, excel code for date format was given as d/m/yy but how to change the code to dd/mm/yyyy format for picking date into my application. Please help me
This video is very helpful, but i need to know how to use dropdown,doubleclick,and click option through this way could you share that type of videos its very helpful sir.
+Lakshmi Ch Thanks Lakshmi. Ya I'm working upon it. Selenium Interview questions video will be uploaded soon. Plz subscribe the channel and press the bell icon to get the notification. Thanks
Please refer the full playlist of Selenium WebDriver. You will find different Selenium Tutorials videos over there. Here is the link: ua-cam.com/video/L8Qj6VcNGEw/v-deo.html
QQ: When we say that the parameters that we pass in the test method should be same as that in object repository-- it means that only the string parameters should remain same and we can have other datatypes in the method argument?
Hi @Naveen AutomationLabs, I am using the same utility but facing one problem, suppose there is only one row in the excel(with valid data) and running the test case it is running 2 times. One is for valid data, 2nd one is for blank data(for 2nd row) while there is no data in the 2nd row. Could you please help on that?
This video is very helpful for me. Actually I am searching for something how to read multiple data sets parallely from Excel using same class/multiple classes whatever possible. Can we achieve this using data driven frame work? Or else any other frame work will help? Please help me..
Hi Naveen, i followed and created a program as you showed. But @Test annotation method is not executing. And I have a question, @Test method runs and calls @DataProvider annotation method or @DataProvider annotation method runs first. Your help will be more useful to me. Thank you.
Great job I was trying to add parameters in testng.xml file to my appium test, it working properly when im all tests, capabilities and android driver are written on same class But i found strange behaviour when im applying parameters for page object model ( baseSetup class contains capabilities, android driver and teardow - page class contains elements and steps - test class )
Thank you Naveen ,your video helps a lot I have small doubt in TestUtil class u where converting the excel sheet data into String but in real time will use for loop to fetch the data from Excel sheet in case of numeric data what we have to use if u use integer r double it will show data provider mismatch error
Thanks, Hi Naveen, I have one question, I have multiple tests and I want to execute all tests in first iteration and likewise all tests in everyiteration rather than just Test1 being executed multiple times, Because in my framework Test1 take a url, client from excel and other tests are verifying various pages based on the url and client chosen in Test 1, how to implement that ? There is not even a single tutorial on this, everyone has a single test scenario.
Hi Naveen, where can i find the utility that is being discussed in the "DataProvider In TestNG" session. can you please share. I checked the git hub link provided below, however i could not find this utility.
It looks like for data provider we are again partially using the concept of reading Excel file and sending data from excel. If we know that approach is there any additional value/benefit of DataProvider?
Hi Naveen. That class Xls_Reader which u created an object for that is not available in java packages neither in apache POI . Is that something you written on own?
Hai Rahul ,I'm facing an issue , how to register a company using JSON request in beta. I want to register ten company with different roles. How to register. Here beta means production environment. Is it possible to do a API or selenium how register 10times quickly .. can you please which approach I have follow.
@Naveen AutomationLabs, I did the same you mentioned in video but still it is not writing data from excel file. If you can share any possible solution.
Hi Naveen Need your help to fetch the data using dataprovider for a scenario: there may be two sheets or two excels in which one sheet there is a customer id and in another sheet the customer name and other details(each 1st row of sheet1 has corresponding 1st row in 2nd sheet) I have to take 1st customer id(1st sheet) and proceed to next page to add other details(from 2nd sheet) and similarly go ahead adding further records.
Hi Naveen, Could you please explain how to write in excel. I am using Xls_Reader file and setcelldata( ) to write in excel, m not able to write.after execution when i m opening the file, a file gets corrupted.
Hi Naveen, I have took the XLS creation code from the link you have given. After importing the poi jars, still it is showing so many errors. Can you please help how to resolve these errors. Most of the errors are related to cell type
@naveenautomationlabs thank you for this video, this is great and helpful sir!... Can we also use this DataProvider for TestNG when writing back to the Excel or adding the new Status column using rowNum from Excel Utility class into the main Test annotations? Thank you @naveenautomationlabs
Hi Naveen, running the same program gives me the below error. Can you please help me. FAILED CONFIGURATION: @AfterTest tearDown java.lang.NullPointerException
Naveen I am unable to read the data from the excel, I am using same as your code but it is showing the errors. Is there something I might be missing? Please help....
@naveen . Using data provider if I want TestNG result should show 1 in place of 4 then how to use. I don't want result shown as total test as 4. I want test results as 1. What to do
Hi Naveen! Thanks a lot for this video! Can you please clear my one question.. I have uploaded the POI jar files but Xls_Reader function is not working.. any suggestion please? I am using the XSSFWorkbook.. and calling each rowNum and ColumnNum.. your techniques seems simple and effective.. (I have POI 3.17 version) List of POI jar files in Library: poi.3.17.jar poi.ooxml-3.17.jar poi-ooxml-schemas-3.27.jar (Am I missing any jar file?)
Hi Naveen, Here in this example, as soon we are entering numerical data (zip-code), it enters as 94510.0 instead of 94510 which we have provided in Excel, How can we resolve this problem?
how can we save the excel sheet data in webpage or example if we want to enter values in contacts of FREECRM.plz let me know it will be great help.Thank you for all videos
hi naveen .. i have all the apache poi dependency in my maven projects , but I am not able to see the XLS Reader class coming .. can you please help how can we import XLS Reader class from utilty package .. i am using the latest poi jars ..
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
Naveen sir, can u please tell us how to create our own framework to run our automated test scripts by using excel. It's not about data driven testing concept. Please help me out...
Hi sir how can we use two dataprovider in same class for two test cases with parameters eg dataprovider1 for test1 and dataprovider2 for test2 which depends on test1 in same testclass.java
does any jar file required to import com.excel.utility.Xlx_Reader? I am not getting any option to import in eclipse. Any one Please help.. Thanks a lot!!!
Hi naveen, Thank you, Excellent tutorial, I like it. without TestNG also the DDF are using in the industry ? TestNG is mandatory skill? Kindly suggest us.
Hey Naveen, one question in the Test Utiil class you have the method with return type as - ArrayList. Do we really need the generic ArrayList to hold array of Object type ? I did something like this - ArrayList, i.e. ArrayList will hold collection of String arrays.and it worked fine. As the data in all the cells in excel file are saved as Strings, so cant we store those as String arrays rather than creating Object arrays ?
sir.. there is a program "XLs_Reader.java" ........you not discuss about this,..... plz explain ..error occur at xls.reader... while importing from excel utility .. selenium shows =create .XLs_Reader.java
Hello sir, can you help me to remove this error? Error occurred during initialization of boot layer java.lang.module.FindException: Unable to derive module descriptor for \selenium-java-3.4.0\lib\xalan-2.7.2.jar Caused by: java.lang.module.InvalidModuleDescriptorException: Provider class org.apache.bsf.BSFManager not in module
Hello All, can anyone please let me know how to import com.excel.utility.Xls_Reader I am unable to import and use. in eclipse it showing nothing to import for this. Any help would be much appreciated!
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
Thanks a lot
can you make video on reading data from json file instead of excel in selenium test
Thanks Naveen ,so this looks like an alternative for Apache poi ,correct me if I am wrong.
Hii naveen this video is so helpful and the only issue i have is.... I have to call a mobile number & the code is like getNumericCellValue which is returning me double value.. can you please help me out by changing it to int or long?? I tried type casting ,wrapper classes & math round.. any other possible way??
@@kavitadhalape312 excel mai kya problem hsi sister?
@6:16 Creating a class inside package which is consisting Datadriven Test.
@6:53 A code to invoke browser and opening a site using @BeforeMethod annotation.
@9:06 A code to quit browser using @AfterMethod annotation.
@9:49 Writing testcase for locators of the site input fields.
@14:03 Passing suitable parameters for testcase.
@15:58 Using DataProvider annotation to pass data to the testcase.
@17:03 Creating a utility package and inside that package, creating a class.
@17:32 Importing opensource Arraylist method inside class belonging to utlity package.
@20:00 Giving Excel sheet to the class belonging to utility package.
@21:22 Correcting "for" loop according to Excel sheet.
@24:43 Creating an object array to store existing String values.
@25:52 Adding the object array into the arraylist.
@28:03 Calling that Arraylist method into DataProvider annotation of testcase
@29:05 Writing an method to iterate an arraylist.
@30:40 Passing Iterator method from DataProvider annotation inside testcase
@34:48 Running the code.
How cool it is !! We are going to read data from Excel to DataProvider and then that DataProvider is going to feed data to various methods in application for Processing. Thank you Naveen !!
I have viewed about 10 different instructors videos but among them all Naveen Sir's videos are top on the List, the way explanation given is really kool
Thank you Very Much sir for your Greatest Help
Hello Naveen Sir, Namaste, I am the Big Fan of you Sir, You have posted this video 3 years back but still helping me and like such kind of students lot of there. Really clear explanations sir. You have put the seeds before 3 years it will grown today as big tree we peoples are utilizing like shadow.
Your are big contribution in Testing Industry Sir. Thank for your once again. Please Keep Posting Sir. :)
I'm getting ample amount of knowledge watching your videos Naveen. A big thumbs up to you.
One word sir,, you are just an amazing PERSON!!!1
Very Crisp & Clear Explanations, Thank u, Naveen.
Thank you Naveen...such a wonderful video i have ever seen. Clearly explained point to point. Thank you so much
Very Simply and clearly explained Thanks Naveen.
You're most welcome
Hey, Naveen you have explained the complex topic in the simplest possible way. Kudos to ur explanation.
Thanks you for providing the in detailed explanation on Data Provider :)
Thank you so much Naveen. Very helpful. Your are spot on. Detailed Explanation. Anyone can Understand.
Data Provider concept is required for my full project.
Nicely explained Naveen, keep it up with good work.
Thank you soo much for explaining this in detail. it helped me alot...👍😊
The content is amazing and gives an in-depth insight into the concepts involved. Thank you!
Amazing tutorial Naveen sir, thanks a lot , such a complex topic is explained in such a simple way
Amazing lecture sir, thanks a lot❤
Very brilliant explanation and so easy to understand. Thanks a lot.
Thank you so much naveen you cleared my doubt by watching these amazing videos
I really appreciate you brother.
You're most welcome
very easily understand thanks navin
Very good explanation...really helpful for complex topic to get clear properly..
Hello Naveen could you please tell me from where can i download that excel utility package to use Xls_reader class
Hello @@kenjalgundecha5870 , you can get Xls_reader class here, github.com/naveenanimation20/SeleniumJavaCourse/blob/master/src/com/excel/utility/Xls_Reader.java . its basically a custom call that Naveen has written for the AUT.
Hi Naveen, When we are working on end to end testing, we work on multiple pages and for every pages we have to pass different test data. e.g. we login the page and go to second page and do some verification and go to third page do some calculation and verify the result. As we are not passing multiple set of data for one page and we are dealing with multiple page at one time, In this case which framework(Data Driven, Hybrid etc.) will be suitable? Or how we can achieve this using framework structure?
Thanks Naveen for the tutorial. Its really helpful.
Thank you Naveen.....Superb teaching.
So smoothly explained...
Hello Naveen, Why Xls_Reader decalred as static ? and then we are creating object of that new XLS_Reader
Hello Naveen, Can you please share the link for the previous video where u created the excel and created all the Apache POI operations. Thanks in Advance.
Thank you so much Naveen!
Thanks a lot for sharing such wonderful videos. It means a lot.
Hi Naveen, firstly, I follow all your videos of selenium tutorials. And they all are very clear with excellent explanation. Would like to say thank you for that.
Secondly with this video above how do you do validation of the testcase. Please explain. Thank you
Thank you,it was a very good explanation about TestNg
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
Mail me at naveenanimation20@gmail.com
Nice video keep uploading
hi naveen,
In Xls_reader, excel code for date format was given as d/m/yy but how to change the code to dd/mm/yyyy format for picking date into my application. Please help me
This video is very helpful, but i need to know how to use dropdown,doubleclick,and click option through this way could you share that type of videos its very helpful sir.
Naveen Garu your explanation is good..more useful to all..please make a video for interview questions..it will be more helpful for us.
+Lakshmi Ch Thanks Lakshmi. Ya I'm working upon it. Selenium Interview questions video will be uploaded soon. Plz subscribe the channel and press the bell icon to get the notification. Thanks
Naveen AutomationLabs Naveen Garu is there any other advanced topics in selenium..
Please refer the full playlist of Selenium WebDriver. You will find different Selenium Tutorials videos over there. Here is the link: ua-cam.com/video/L8Qj6VcNGEw/v-deo.html
Hi Naveen,is it possible to read selective records from the excel sheet when using data provider
please let me know Xls_reader library for import - I am unable to get it
QQ: When we say that the parameters that we pass in the test method should be same as that in object repository-- it means that only the string parameters should remain same and we can have other datatypes in the method argument?
Very informative video man. Thanks
Thanks sir ,it really help me
Could you share some java related interview questions
Hi @Naveen AutomationLabs, I am using the same utility but facing one problem, suppose there is only one row in the excel(with valid data) and running the test case it is running 2 times. One is for valid data, 2nd one is for blank data(for 2nd row) while there is no data in the 2nd row. Could you please help on that?
This video is very helpful for me. Actually I am searching for something how to read multiple data sets parallely from Excel using same class/multiple classes whatever possible. Can we achieve this using data driven frame work? Or else any other frame work will help?
Please help me..
Hi Naveen, i followed and created a program as you showed. But @Test annotation method is not executing. And I have a question, @Test method runs and calls @DataProvider annotation method or @DataProvider annotation method runs first. Your help will be more useful to me. Thank you.
Great job
I was trying to add parameters in testng.xml file to my appium test, it working properly when im all tests, capabilities and android driver are written on same class
But i found strange behaviour when im applying parameters for page object model ( baseSetup class contains capabilities, android driver and teardow - page class contains elements and steps - test class )
Thanks a lot Mr. Naveen garu.
@naveenautomationlabs , could you please confirm if we can use String as Storing data in ArrayList
ArrayList obj = new ArrayList();
Thank you Naveen ,your video helps a lot I have small doubt in TestUtil class u where converting the excel sheet data into String but in real time will use for loop to fetch the data from Excel sheet in case of numeric data what we have to use if u use integer r double it will show data provider mismatch error
Hey , did you get the solution for that?
Please user data DataFormatter via apache POI.
Thanks, Hi Naveen, I have one question, I have multiple tests and I want to execute all tests in first iteration and likewise all tests in everyiteration rather than just Test1 being executed multiple times, Because in my framework Test1 take a url, client from excel and other tests are verifying various pages based on the url and client chosen in Test 1, how to implement that ? There is not even a single tutorial on this, everyone has a single test scenario.
Hi Naveen, where can i find the utility that is being discussed in the "DataProvider In TestNG" session. can you please share. I checked the git hub link provided below, however i could not find this utility.
I figured it out i did not have the Reader_Xls utility in the project folder hence it was not recognizing the method... thanks!
It looks like for data provider we are again partially using the concept of reading Excel file and sending data from excel. If we know that approach is there any additional value/benefit of DataProvider?
Hi Naveen. That class Xls_Reader which u created an object for that is not available in java packages neither in apache POI . Is that something you written on own?
Did you got the answer?
Hai Rahul ,I'm facing an issue , how to register a company using JSON request in beta. I want to register ten company with different roles. How to register. Here beta means production environment. Is it possible to do a API or selenium how register 10times quickly .. can you please which approach I have follow.
@Naveen AutomationLabs, I did the same you mentioned in video but still it is not writing data from excel file. If you can share any possible solution.
Hi Naveen
Need your help to fetch the data using dataprovider for a scenario:
there may be two sheets or two excels in which one sheet there is a customer id
and in another sheet the customer name and other details(each 1st row of sheet1 has corresponding 1st row in 2nd sheet)
I have to take 1st customer id(1st sheet) and proceed to next page to add other details(from 2nd sheet)
and similarly go ahead adding further records.
Thank You Naveen....Can't thank you enough.
Hi Naveen, Could you please explain how to write in excel. I am using Xls_Reader file and setcelldata( ) to write in excel, m not able to write.after execution when i m opening the file, a file gets corrupted.
very nice explanation sir
Thanxu brother it was really helpful.
Hi! Thanks for clear explanation. I have a question, what about if the browser will not close during the suit session? how to clear it quickly ?
Hello, I haven't got the "get datafromExcel class file(utility file) with this video, where I get this file?
Hi naveen, shouldn't we use next() to iterate over the elements? How can it directly get access to all the element?
Hi Naveen, I have took the XLS creation code from the link you have given. After importing the poi jars, still it is showing so many errors. Can you please help how to resolve these errors. Most of the errors are related to cell type
@naveenautomationlabs thank you for this video, this is great and helpful sir!... Can we also use this DataProvider for TestNG when writing back to the Excel or adding the new Status column using rowNum from Excel Utility class into the main Test annotations? Thank you @naveenautomationlabs
Hello sir,
we can fetch values directly from excel file into our script. why dataProvider is needed in between ..
To work with TestNG DataProvider for DD approach, is it necessary to use Apachi POI for doing Excel operations?
Hi Naveen, running the same program gives me the below error. Can you please help me.
FAILED CONFIGURATION: @AfterTest tearDown
java.lang.NullPointerException
hi , after the method is it mandatory to close the browser ??
because i have many test cases after the test case which i use with data provider !!!!!
@NaveenAutomationLabs
This is fine. But how can we call the dataprovider from one class to multiple classes?
How can we get the utility other than "xls_reader" which returns the Arralylist Object
Naveen I am unable to read the data from the excel, I am using same as your code but it is showing the errors. Is there something I might be missing? Please help....
@naveen . Using data provider if I want TestNG result should show 1 in place of 4 then how to use. I don't want result shown as total test as 4. I want test results as 1. What to do
can we use multiple data provider ..?? or i have to create multiple methods in utility for different sheet data using single data provider ..?
Hi Naveen! Thanks a lot for this video! Can you please clear my one question.. I have uploaded the POI jar files but Xls_Reader function is not working.. any suggestion please? I am using the XSSFWorkbook.. and calling each rowNum and ColumnNum.. your techniques seems simple and effective.. (I have POI 3.17 version)
List of POI jar files in Library:
poi.3.17.jar
poi.ooxml-3.17.jar
poi-ooxml-schemas-3.27.jar
(Am I missing any jar file?)
Yes please add the jar files from the folders too
Hi Naveen, Here in this example, as soon we are entering numerical data (zip-code), it enters as 94510.0 instead of 94510 which we have provided in Excel, How can we resolve this problem?
how can we save the excel sheet data in webpage or example if we want to enter values in contacts of FREECRM.plz let me know it will be great help.Thank you for all videos
hi naveen .. i have all the apache poi dependency in my maven projects , but I am not able to see the XLS Reader class coming .. can you please help how can we import XLS Reader class from utilty package .. i am using the latest poi jars ..
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
thanks naveen i got the answer..this XLS Reader is coming from the separae class which you hv created..
Sir,Data providers testng data driven framework video is not downloading.
Hi Naveen, I have one doubt can we write more than two methods under a @dataprovider annotation or we should mention @dataprovider for each methods
Can you please show us how to write test results(pass/fail) into XL sheet using Xls_reader when there are multiple xlsheets?
Naveen sir, can u please tell us how to create our own framework to run our automated test scripts by using excel. It's not about data driven testing concept. Please help me out...
Hi sir how can we use two dataprovider in same class for two test cases with parameters eg dataprovider1 for test1 and dataprovider2 for test2 which depends on test1 in same testclass.java
If we use data provider ..can I run from testng XML file? Am facing issue.can you help me on this
Hi Naveen, Can you please explain on different set of data in the same sheet to execute multiple cases
does any jar file required to import com.excel.utility.Xlx_Reader? I am not getting any option to import in eclipse. Any one Please help.. Thanks a lot!!!
What video did you talk about the Excel sheet?
Hi Naveen,Show how to open the script from selenium and how to debug the values of string
Hey Naveen, Thanks for sharing the tutorial. Can you please let us know how can we call the method which is having data provider associated with it.
Hi naveen,
Thank you, Excellent tutorial, I like it.
without TestNG also the DDF are using in the industry ? TestNG is mandatory skill? Kindly suggest us.
Hey Naveen, one question in the Test Utiil class you have the method with return type as - ArrayList. Do we really need the generic ArrayList to hold array of Object type ? I did something like this - ArrayList, i.e. ArrayList will hold collection of String arrays.and it worked fine.
As the data in all the cells in excel file are saved as Strings, so cant we store those as String arrays rather than creating Object arrays ?
you can use String also.
@@naveenautomationlabs Thanks for the response 🙂
If I don't want the browser should close after every entry I want one time browser open and then do all the entry then quite how to do that ??
sir.. there is a program "XLs_Reader.java" ........you not discuss about this,..... plz explain ..error occur at xls.reader... while importing from excel utility .. selenium shows =create .XLs_Reader.java
Hi naveen , how to use dataprovider for menubar concept?
Hi Naveen, can we open 5 browser in a single shot reading data from excel file..
Hi
At the place of Xls reader i am getting an error.
Xls reader cannot be resolved to type..
Please help
Hello sir, can you help me to remove this error?
Error occurred during initialization of boot layer
java.lang.module.FindException: Unable to derive module descriptor for \selenium-java-3.4.0\lib\xalan-2.7.2.jar
Caused by: java.lang.module.InvalidModuleDescriptorException: Provider class org.apache.bsf.BSFManager not in module
HSSFDateUtil can't be resolved after adding org.apache.poi version I found this depreciated what can be used alternatively?
Hello All, can anyone please let me know how to import com.excel.utility.Xls_Reader I am unable to import and use. in eclipse it showing nothing to import for this. Any help would be much appreciated!
Hello, first thank you very much for the videos. I am not able to import Xls_Reader, what should I do? thankyou
i have same problem what should we do that Naveen please let us know .Thank you