Thank you Sir I have seen around 3-4 different video but I had not understood but after seeing your video I have successfully made excel dataprovider code in my project.Really helpful for me Thank You so much.God bless you.
Thanks a lot bro..u rockz..i searched whole day and getting fed up..and then i see ur 2-3 videos about read the data from excel and I have clear all the concept..keep sharing..
Mukesh otwani I am facing sone problem when I read the numeric value from excel..then in console error shows me..can't convert the numeric value to string value..plz suggest me what I will do..
I have visited so many channel for this but I couldn't get any thing finally referred ur video and I got everything.. Thnx mukesh ur explained it very well.
You are truly blessed, your videos are helping a lot. Though i took training for Selenium, your tutorials are much more easier to understand and detail oriented. Wish you success and good luck.
Woow beautiful explanation bro 💥 I tried and got the output ❤️ thank you so much bro I was struggling alot with different codes finally I wrote my own to read the excel file its just because of you thank you so much ❤️
Hi Mukesh , Your video is truly amazing... You have explained the whole concept in a very simple manner , this topic DDT now looks so much easy to do. once again sincere thanks to you ....
Thanks for this awesome explanation. I tried the same and it is running fine. The only problem I see in my code is, for all three inputs, the test shows pass. Its not failing for the wrong password input data.
Hi Mukesh, Can't thank you enough :) I was so confused in reading and writing excel sheets but your videos are really awesome and easy to understand. Keep going!!
Hi Mukesh Could you please make a video 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
Thank you so much mukesh , here i want to read numeric value from same excel sheet and as well after execution of my script i want to write data in same excel sheet , could please give me some clues.
Hi Mukesh, Thanks for this video its very simple and easy to understand but it works only for string values but when it comes to int or any other data type its failing. Do you have any video that covers at least integer also
Hi Mukesh, Completely impressed with the way how you are teaching. Suppose if i want to use the excel data in multiple classes present in different packages. Will you please let me know the generic code, how can i do that ?
Hi Mukesh, Thanks for your amazing explanation on DataDriven Framework. I got closer to the concept and like rows can you please explain how to include column number in the loop as well? will help when I have more than 10 column values to be read from excel.
Hi Mukesh, you have explained all the things very nicely and its really helpful in understanding the flow. One doubt is don't we have any main method when we are running our script using TestNG?
Hi Shweta I am glad you like it. You can use main method of Java or @Test of Testng framework. In above video I have used @DataProvider of TestNG framework. You can get full info about TestNG from below video. ua-cam.com/video/OTtFSnZY4f8/v-deo.html
Hi Mukesh , I have a doubt here , please clarify In WordPressLoginExcel class we are using the ExcelDataConfig lib to access the inputdata xl file My question is why we are agian giving the xl file path in WordPressLogin class ? Thanks in advance
I would suggest using *.csv instead of *.xls and especially *.xlsx. You can still use MS Excell to open *.csv files, but you can also use even simple notepad. Much more easier to access data file from anywhere, even from phone
Hi Mukesh, your videos are good and useful. I am gaining good knowledge with that. Thanks a lot. Could you please post some videos on Keyword driven framework in Selenium
Hi Mukesh, I wish you can create a data driven frame work using POM design/framework. Thank you. We're excited on the part 3 of the Data Driven and I hope it is designed as POM Thank you so much
hii mukesh, from these videos i understand about how to get values from xcel sheet its great. one dout if we have more no of columns like 50 then how can we write the column related code without using hardcode???????
yes i tried but its not working just skipping and getting a failure,here is the code i tried package pack01; //import org.junit.Test; import org.openqa.selenium.By; import org.openqa.selenium.WebDriver; import org.openqa.selenium.firefox.FirefoxDriver; import org.testng.annotations.AfterMethod; import org.testng.annotations.DataProvider; import org.testng.annotations.Test; import lib.xcel02; public class class01 { WebDriver driver;
@Test(dataProvider="fb") public void loginToFb(String username,String password) { driver=new FirefoxDriver(); driver.manage().window().maximize(); driver.get("facebook.com/"); driver.findElement(By.id("email")).sendKeys(username); driver.findElement(By.id("pass")).sendKeys(password); driver.findElement(By.id("u_0_2")).click(); driver.close(); } @DataProvider(name="fb") public Object[][] passData() { xcel02 xcel=new xcel02("C:\\projects\ ew_project\\src\\lib\\TestData\\InputData.xlsx"); int rows=xcel.getRowCount(0); int columns = xcel.getColumnCount(0); System.out.println(columns); Object[][] data=new Object[rows][columns]; for(int i=0;i
@@Mukeshotwani cannot agree more. I am keen to join to learn java, classes, adv reporting and creating test cases, suites ..i received email that you are starting on Oct 19..I am waiting confirmation mate
Hey Deepak, yes we can do that.. Like manual testing we have multiple test for positive and negative. Likewise you have to create multiple scripts in Selenium as well.
Hi Mukesh, Huge thanks for uploading this video. However, I am getting "Cannot get a STRING value from a NUMERIC cell" error message when i try to execute the script. Can you please help me?
Hi Mukesh , I would like to know what are the different ways we can use to fetch the data by using @dataprovider & @Test in TestNG Framework. As we know for upload or download files with TestNG we can use Robot Class or Auto IT etc. Thanks
Hi Rupa, Let me explain this @DataProvider works like Data Source for our test so we can feed the data from excel, csv, database, json, xml or many more. In my example I have used Excel but you can use any data source but make sure we pass the data in 2D array.
Hi Mukesh, Need your help to read data from two sheets, like from first sheet take some data and proceed to further page and take some data from second sheet(first sheet and 2nd sheet data has dependency). How shall i implement this using Dataprovider
Hi Reshma DataProvider takes same set of data and then pass the test. If you have such dynamic scenario then better to get direct values from excel and use in test cases.
Hi Mukesh, First of all, thanks a lot. Your videos are really very helpful to understand Selenium. I have covered Data Driven Framework, both parts. Now I am looking for Keyword Driven Framework, but not able to find it. Could you plz share the link.
Hi Mukesh, Thank you so much for your effort made to teach Selenium to the folks like me.. I am trying to find Part 3 of this DDF, that you mentioned at the end of the Part 2 video.. But i am unable to find. Pls assist me to find..
Hi...Mukesh. You have made very nice tutorial. Thanks a lot. As you mentioned, there will be part 3 of DDT framework, I am not able to find it. Would you please share the link.
When we use dataProvider and try to do cross-browser testing in parallel from the TestNG XML file, it doesn't behave right. provide one data for each browser, when I remove parallel execution and let it run sequential, works fine. Any solution
Hi Vida Waran, it depends on how your driver instance is invoked. If driver is static then it wont run in parallel. In order to run @DataProvider in parallel, please make below changes in your test. 1- Make sure driver is not static 2- @DataProvider(name="dataprovidername",parallel=true) Hope it will help.
@@Mukeshotwani thank you very much, yes my browser was static when I changed it worked, I didn't give @DataProvider(name="dataprovidername",parallel=true) . once I changed the browser it worked
@@Mukeshotwani Also can you update video lecture for attaching file in selenium webdriver, I know its simple when we have input tag, just in case if we dont have input tag
Hello Mukesh. I have followed your both lectures on Data driven framework excel based. And done the same as shown in the video. But while executing I'm getting this error. Can you help me with this? SKIPPED: Login java.lang.RuntimeException: java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
Hi Harshith Reason is you are trying to read numreric value. Kindly follow below post to fix issue. learn-automation.com/read-numeric-data-excel-using-apache-poi-selenium-webdriver/
For the time being you can use below github.com/saikrishna321/Page-Object-Pattern-with-WebDriver-and-TestNG/blob/master/src/main/java/org/sayem/util/Xls_Reader.java
Hi Mukesh, Thanks for the wonderful session on data driven concept. Very helpful to me. Can you please help me to handle multiple sheet data. Regards, Sayed
Hi Mukesh i have a question that, while execution can i run the code without closing the sheet from where i am providing the data or do i need to close the sheet every time i run the script??
yes, you can, because in current code, you are just performing the read operation... you will need to close the data sheet, when you will be performing the write operation
Again, this is super awesome video. Explained in great detail. I tried it on the website that I am trying to automate and it worked really well. I, however stumbled onto issues with the Testng annotations. My script does the same thing, test login first. However, there was another script that I wanted to execute once the login is successful. However, when I run that script, it started failing (my login script previously has the annotation @BeforeMethod which we changed to @Test(dataProvider = "logindata") Any suggestions here.
This may be too much of an ask to have you help us solve our problems. But your videos are good detailed and are turning new comers into good automation test engineers. I am completely glued to these tutorials.
Hi Pankaj, @Test method will run multiple times based on number of rows so make sure @BefireMethod has only browser related details. @Test should have actual test.
Sir , their is one problem. U had start the excel sheet from 1st row and if I want to use it from 2nd row by making int i=1.It shows null pointer exception.Please guide me
Hi Mukesh, What if i have more than 30 columns in the table and i have to pass through from dataprovider to test method, I struck here, any supported examples would help me to resolve this kinda of issues.
hi mukesh suppose if i want to add only numbers means.. what should i do? ..suppose if there is phone number field in application means what should i do..where to change the code? .i am getting an error like cannot get a string value from numeric cell.
Thank you Mukesh for the awesome video. Could you please let me know how to take screenshot for multiple test cases with different names. How will I have to pass the screenshot name argument here ?
Thanks a lot for replying !! Yes I already went through that video. But there u are hard coading the screenshot name.. But is there any way where we can pass the screenshot name as parameter?
Hi Mukesh, i have 4 rows in my excel and in for loop, i started with i=1. but while running, the script is running 4 times with first data set as null,null. im not sure why the script is picking the first set as null,null Can you advice on this?
Hi Mukesh, I have a small doubt, whenever in the for loop I change i=1 for reading through the excel, it passes null as username and password. Rest of the code I'm using the same as above. Can you please help in this regards.
Hi Mukesh, Nice explanation. I have used your code but i am getting error "" Cannot get a STRING value from a NUMERIC cell" , so could you please tell me what's the solution to fix this error.
Hi Mukesh, I'm new to selenium, but your videos are too helpful. Still I'm not able to find Data driven framework excel based part 3 Selenium Webdriver..
Hi sir, your tutorials are very nice...I hv one question You told while explaining DDF part 1 that if you don't know how configure means go through my previous video right..?? which video I shud go through m not getting please provide me URL of that video...
for those who worked in advance selenuim project, What is the difference between storing test dsta in yml file vs excel, when do we need to store data in sql DB?
Thanks a lot Mukesh, really it very useful video for beginners ... I really appreciate to keep posting this kind of video....I hope soon we will get part 3. can you tell me what is annotation ? how to use annotation and where ?
+Saravana Sakthi Hi Saravana yes will upload soon. Annotation in java is just the seperate class which perform the perticular task. We have different annotations based on requirement. TestNg and Java itself have plenty of annotation. Can you please specify the annotation which you want to know.
Hi Mukesh, your tutorials are really great help. Thank you so much Just one question, why did you put the FileInputStream inside the ExcelDataConfigConstructor? Is it possible to put it in an ordinary method?
I have to say Thank you. I successfully learnt Data driven Framework because of you. Thank you so much.
Welcome Mounika I am glad my video helped you. Keep learning. Let me know if any help from my side.
Thank you Sir I have seen around 3-4 different video but I had not understood but after seeing your video I have successfully made excel dataprovider code in my project.Really helpful for me Thank You so much.God bless you.
Hi Mukesh, I always refer your videos for selenium. Thanks for uploading such videos.Thanks a lot.
So nice of you Mili. Thank you and let me know know if you need any help from my end.
Thanks a lot bro..u rockz..i searched whole day and getting fed up..and then i see ur 2-3 videos about read the data from excel and I have clear all the concept..keep sharing..
Cheers Prateek :) Keep learning new concepts.
Join FB Group too.
facebook.com/groups/256655817858291/
Mukesh otwani I am facing sone problem when I read the numeric value from excel..then in console error shows me..can't convert the numeric value to string value..plz suggest me what I will do..
I have visited so many channel for this but I couldn't get any thing finally referred ur video and I got everything.. Thnx mukesh ur explained it very well.
Thanks Mate :) good to know you finally understand DDF. Keep learning.
your videos are helping me to brushup my coding and debugging skills
You are truly blessed, your videos are helping a lot. Though i took training for Selenium, your tutorials are much more easier to understand and detail oriented. Wish you success and good luck.
+Sowmya Poddaturi Thanks Sowmya thanks a ton. Please let me know if any help required from my side.
Thanks Mukesh, searching for this video since long time.
You are most welcome Juned.
Thank you mukesh waiting for part 3
Thanks for Uploading and explaining the POM in easily understandable way. Looking for more Information in Future...
All the Best
+AKBAR HUSSAIN Thanks Akbar :) Many videos in queue will upload soon.,
Thanks a lot. Finally understood data driven framework and could do it as well.
Thanks Shwetali and I am happy to hear from you.
Woow beautiful explanation bro 💥 I tried and got the output ❤️ thank you so much bro I was struggling alot with different codes finally I wrote my own to read the excel file its just because of you thank you so much ❤️
Awesome Prakash 🤗 Cheers
Wonderfully explain....you have unique skill to make things easier for other...
+nikunj bambhroliya HI Nikunj thanks a ton :)
Nice explanation to understand...thanks a lot.
Hi Mukesh , Your video is truly amazing... You have explained the whole concept in a very simple manner , this topic DDT now looks so much easy to do. once again sincere thanks to you ....
Thanks a ton Gaurav 🙏 Keep learning and let me know if any help required from my side.
Finally I have found one video with clear description what I was looking for. Thanks a lot Mukhesh. Looking forward to learn more from you.
+israt khan Thanks Israt will upload part 3 soon which will update the status in excel :)
you are really great mukesh we help to others
Thanks Manas
Thanks for this awesome explanation. I tried the same and it is running fine. The only problem I see in my code is, for all three inputs, the test shows pass. Its not failing for the wrong password input data.
Thanks a lot for explanation of DDF approach. Waiting for Part 3 .. :)
+Alexander Svyatenko Hi Alex will upload soon :) thank you
Hi Mukesh, Can't thank you enough :) I was so confused in reading and writing excel sheets but your videos are really awesome and easy to understand. Keep going!!
Thanks Priyanka :) keep learning and let me know if any help from my side.
Thank you Mukesh, waiting for part 3
will try to make new videos soon.
@Mukeshotwani
is there any place you have mentioned all the code in one placed which can copied or collected?
Good Mukesh,
Keep it up, You are growing our scripting knowledge. Now I am using this for my project and working good...
Thanks Niwrutti I am glad it is helping.
Thanks a lot Mukesh - do we have a video for reading data in more than 2 excel columns? (like by using Hashmap/set collection etc.)
Good Bro ,
Nice Explanation..Thanks for Sharing the Knowledge.
Thanks I am glad you liked it. Keep visiting.
Great Videos!! Thanks for doing this! Please do DDF part3!
Excellent Work. It helps a lot for Beginners. please upload Part 3 of DDF.
+M V REDDY yes will upload soon
+Mukesh otwani plz upload DDT Part-3 soon Sir ,i am waiting for that video from last 3 months Sir ,So plz upload ASAP Sir
Hi M V Reddy
Once I will get time I will upload part 3 and will let u know
These videos are really good. I could not find part 3 of Data Driven framework.
Hi bro thanq so much for uploading these videos and nice explanation i think this much is enough for beginners also.
Most welcome Seshasai :)
Hi Mukesh
Could you please make a video 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
Thank you so much mukesh , here i want to read numeric value from same excel sheet and as well after execution of my script i want to write data in same excel sheet , could please give me some clues.
Hi Mukesh if we want to loop through so many coloums then, do we need to manually update it.??
Hi Deepti no you can also get all columns using getPhysicalNumberOfCells and then run for loop.
@Mukesh otwani Can u help us in looping columns too
Hi Mukesh, Thanks for this video its very simple and easy to understand but it works only for string values but when it comes to int or any other data type its failing. Do you have any video that covers at least integer also
Very nice Tutorial.. Thank you Mukesh..
+Shilpa Thanks Shilpa
Excellent Work. It helps a lot for Beginners. please upload Part 3 of DDF. Please try to upload POM and Page Navigation if possible
+Manjunath B.N Thanks Manjunath I will upload by this weekend.. :)
Hi Mukesh,
Completely impressed with the way how you are teaching.
Suppose if i want to use the excel data in multiple classes present in different packages.
Will you please let me know the generic code, how can i do that ?
Hi Mukesh,
Before practicing DDT part1 and part2 do we need to do any set up in my project.if yes pls share that link for set up in my project
Hi Mukesh, Thanks for your amazing explanation on DataDriven Framework. I got closer to the concept and like rows can you please explain how to include column number in the loop as well? will help when I have more than 10 column values to be read from excel.
Hi Raja, in order to read column as well you need to use another loop as well.
Thank you so much for this excellent tutorial...
Thanks Sadhanana :) Happy weekend.
Hi, very nice and elaborate video. But how do you get the folder for default reporting?
Hi Pratilipi,
You can refresh the page. It comes by default.
You can check my TestNG video on this
ua-cam.com/video/OTtFSnZY4f8/v-deo.html
Hello Mukesh sir its very useful video for me and than you
Thank you Punam keep learning 😊
Thanks mukesh... Video is very helpful for us... Could you please upload Data Driven Framework Excel Based Part 3 video.
Thank you so much Mukesh for this video tutorial. It's really very helpful...:-)
Thanks Anurag :)
Hi Mukesh, you have explained all the things very nicely and its really helpful in understanding the flow. One doubt is don't we have any main method when we are running our script using TestNG?
Hi Shweta I am glad you like it. You can use main method of Java or @Test of Testng framework. In above video I have used @DataProvider of TestNG framework.
You can get full info about TestNG from below video.
ua-cam.com/video/OTtFSnZY4f8/v-deo.html
Hi Mukesh, its really good and you have explained in details. Thanks
waiting for part 3 :)
+Raghu Hoskote Hi Raghu will upload in May
+Mukesh otwani no worries thankQ :)
+Raghu Hoskote :)
thanks Mukesh for this helpful tutorial, plz upload part 3 of Data Driven Framework tutorial
+Sumit Kumar Hi Sumit coming soon.
Great video sir, it helped me lot. Please teach us how to mail the testng report to the desired recepients. Thanks again
Here is the detailed article ua-cam.com/video/qGq9K85mGyA/v-deo.html
Hi Mukesh ,
I have a doubt here , please clarify
In WordPressLoginExcel class we are using the ExcelDataConfig lib to access the inputdata xl file
My question is why we are agian giving the xl file path in WordPressLogin class ?
Thanks in advance
I would suggest using *.csv instead of *.xls and especially *.xlsx.
You can still use MS Excell to open *.csv files, but you can also use even simple notepad.
Much more easier to access data file from anywhere, even from phone
Hi Mukesh, your videos are good and useful. I am gaining good knowledge with that. Thanks a lot. Could you please post some videos on Keyword driven framework in Selenium
Hi Mukesh, I wish you can create a data driven frame work using POM design/framework.
Thank you. We're excited on the part 3 of the Data Driven and I hope it is designed as POM
Thank you so much
Hey Aldrin Part 3 will be Data driven with Page Object model
hi mukesh ...i could not find 3rd part of data driven framework with reporting that you were talking about in part 2(this).
Hi Sumit You can try part 3 as part of assignment.
Simply Superb.
+GAJANAN PATIL I m glad it helped u
Thank you so much.. excellent video , I have implemented and work nicely...
Cheers
Hi Mukesh,
Thanks for the clear explanation about DD framework. Can you please explain how to use column count in for loop without hard coding.
Hi Dwaraka you can use getPhysicalNumberOfCells(); for column count
hii mukesh, from these videos i understand about how to get values from xcel sheet its great. one dout if we have more no of columns like 50 then how can we write the column related code without using hardcode???????
Hi Keerthi, yes you can run a for loop as well for columns..
yes i tried but its not working just skipping and getting a failure,here is the code i tried
package pack01;
//import org.junit.Test;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
import lib.xcel02;
public class class01 {
WebDriver driver;
@Test(dataProvider="fb")
public void loginToFb(String username,String password)
{
driver=new FirefoxDriver();
driver.manage().window().maximize();
driver.get("facebook.com/");
driver.findElement(By.id("email")).sendKeys(username);
driver.findElement(By.id("pass")).sendKeys(password);
driver.findElement(By.id("u_0_2")).click();
driver.close();
}
@DataProvider(name="fb")
public Object[][] passData()
{
xcel02 xcel=new xcel02("C:\\projects\
ew_project\\src\\lib\\TestData\\InputData.xlsx");
int rows=xcel.getRowCount(0);
int columns = xcel.getColumnCount(0);
System.out.println(columns);
Object[][] data=new Object[rows][columns];
for(int i=0;i
Thank you Mukesh ji, I see only videos in your website, how to get this code to analyze in your website.
Hi Mate,
Code I have to modify. I would you to write from scratch which will add more value.
@@Mukeshotwani cannot agree more. I am keen to join to learn java, classes, adv reporting and creating test cases, suites ..i received email that you are starting on Oct 19..I am waiting confirmation mate
Hi Anand, I sent email regarding same, please check. Date and Time is confirmed.
I am new to selenium. Want to know how we can implement positive and negative scenario test cases.please, make one video on that.thanks.
Hey Deepak, yes we can do that.. Like manual testing we have multiple test for positive and negative. Likewise you have to create multiple scripts in Selenium as well.
Thank you Mukesh.
Hi Mukesh,
Huge thanks for uploading this video. However, I am getting "Cannot get a STRING value from a NUMERIC cell" error message when i try to execute the script. Can you please help me?
Hi Yojana I have explained the same in below post
learn-automation.com/read-numeric-data-excel-using-apache-poi-selenium-webdriver/
Hi Mukesh ,
I would like to know what are the different ways we can use to fetch the data by using @dataprovider & @Test in TestNG Framework.
As we know for upload or download files with TestNG we can use Robot Class or Auto IT etc. Thanks
Hi Rupa,
Let me explain this
@DataProvider works like Data Source for our test so we can feed the data from excel, csv, database, json, xml or many more.
In my example I have used Excel but you can use any data source but make sure we pass the data in 2D array.
Hi Mukesh,
Need your help to read data from two sheets, like from first sheet take some data and proceed to further page and take some data from second sheet(first sheet and 2nd sheet data has dependency).
How shall i implement this using Dataprovider
Hi Reshma DataProvider takes same set of data and then pass the test.
If you have such dynamic scenario then better to get direct values from excel and use in test cases.
Hi Mukesh, First of all, thanks a lot. Your videos are really very helpful to understand Selenium. I have covered Data Driven Framework, both parts. Now I am looking for Keyword Driven Framework, but not able to find it. Could you plz share the link.
Hi Swati, for Keyword driven framework I will upload soon.
Hi Mukesh, Thank you so much for the excellent video, When the 3rd part will be available?.
Hi Manoj hope so soon will upload.
Hi Mukesh,
Excellent video!! Please confirm if Part 3 is uploaded?
Part 3 you can try with Page Object Model
Hi Mukesh, I could not find it in your blog, can you please send me the link if possible?
Hi Mukesh, Thank you so much for your effort made to teach Selenium to the folks like me..
I am trying to find Part 3 of this DDF, that you mentioned at the end of the Part 2 video.. But i am unable to find. Pls assist me to find..
Hi Priya, I will try to publish soon.
Hi Mukesh,
Object[][] data = new Object[rows[[2]; Here columns is hard coded. Can you reply how to write optimized code for that?
Mukesh thanks good explanantion. Few things I heard was we should not give any hard coded values like path etc. How can we do that?
Hey Nikhil you can use map or POI methods for dynamic.
Hi...Mukesh. You have made very nice tutorial. Thanks a lot. As you mentioned, there will be part 3 of DDT framework, I am not able to find it. Would you please share the link.
+Abhishek Agrawal Hi Abhishek I still have not updated will upload soon.
When we use dataProvider and try to do cross-browser testing in parallel from the TestNG XML file, it doesn't behave right. provide one data for each browser, when I remove parallel execution and let it run sequential, works fine. Any solution
Hi Vida Waran, it depends on how your driver instance is invoked. If driver is static then it wont run in parallel.
In order to run @DataProvider in parallel, please make below changes in your test.
1- Make sure driver is not static
2- @DataProvider(name="dataprovidername",parallel=true)
Hope it will help.
@@Mukeshotwani thank you very much, yes my browser was static when I changed it worked, I didn't give @DataProvider(name="dataprovidername",parallel=true)
. once I changed the browser it worked
@@Mukeshotwani Also can you update video lecture for attaching file in selenium webdriver, I know its simple when we have input tag, just in case if we dont have input tag
@@Mukeshotwani Thank you very much for the answer it worked
Hi Mukesh, how can dataProvider will handle if we need 5 values from excel for one test? How can we handle that? Thanks in advance
Hi Mukesh,can you add TestNG framework with read data from excel??
Hello Mukesh.
I have followed your both lectures on Data driven framework excel based. And done the same as shown in the video.
But while executing I'm getting this error. Can you help me with this?
SKIPPED: Login
java.lang.RuntimeException: java.lang.IllegalStateException: Cannot get a STRING value from a NUMERIC cell
Hi Harshith
Reason is you are trying to read numreric value. Kindly follow below post to fix issue.
learn-automation.com/read-numeric-data-excel-using-apache-poi-selenium-webdriver/
Hello Mukesh, good video. do you have github account? and can you share you excel utils class where you keep all your methods which can be useful ?
Hi Mate I will upload soon
For the time being you can use below github.com/saikrishna321/Page-Object-Pattern-with-WebDriver-and-TestNG/blob/master/src/main/java/org/sayem/util/Xls_Reader.java
Instead of hard coding column number, can we just count the column and iterate according to the column index no?
Hi Swapna, you can use sh.getRow(0).getPhysicalNumberOfCells();
@@Mukeshotwani can you please explain where should I use the function mentioned y you in your comment
Hi Mukesh,
Thanks for the wonderful session on data driven concept. Very helpful to me. Can you please help me to handle multiple sheet data.
Regards,
Sayed
Hey Sayed, you can for loop for handling multiple sheet and then iterate row and column.
Hi Mukesh i have a question that, while execution can i run the code without closing the sheet from where i am providing the data or do i need to close the sheet every time i run the script??
yes, you can, because in current code, you are just performing the read operation... you will need to close the data sheet, when you will be performing the write operation
Again, this is super awesome video. Explained in great detail. I tried it on the website that I am trying to automate and it worked really well. I, however stumbled onto issues with the Testng annotations. My script does the same thing, test login first. However, there was another script that I wanted to execute once the login is successful. However, when I run that script, it started failing (my login script previously has the annotation @BeforeMethod which we changed to @Test(dataProvider = "logindata")
Any suggestions here.
This may be too much of an ask to have you help us solve our problems. But your videos are good detailed and are turning new comers into good automation test engineers.
I am completely glued to these tutorials.
Hi Pankaj, @Test method will run multiple times based on number of rows so make sure @BefireMethod has only browser related details. @Test should have actual test.
Sir , their is one problem. U had start the excel sheet from 1st row and if I want to use it from 2nd row by making int i=1.It shows null pointer exception.Please guide me
Hi Suraj, make sure you add NA or change your utility method which can handle null values.
Hi Mukesh,
What if i have more than 30 columns in the table and i have to pass through from dataprovider to test method, I struck here, any supported examples would help me to resolve this kinda of issues.
Thank you mukesh , in the same code plz help me how to write data in excel sheet
hi mukesh
suppose if i want to add only numbers means.. what should i do? ..suppose if there is phone number field in application means what should i do..where to change the code? .i am getting an error like cannot get a string value from numeric cell.
Thank you Mukesh for the awesome video.
Could you please let me know how to take screenshot for multiple test cases with different names. How will I have to pass the screenshot name argument here ?
Hi Shreesahaya this would help ua-cam.com/video/4ldt-KIgPUQ/v-deo.html
Thanks a lot for replying !!
Yes I already went through that video.
But there u are hard coading the screenshot name..
But is there any way where we can pass the screenshot name as parameter?
Ya I got the solution. I passed username parameter as screenshot name. So it stored all the separate screenshot with username.
Thank you.
Hi Mukesh, can you let us know how to write to the Excel file using the case you use here? Thank you.
+Hugo van den Berg Hi Hugo thanks yes planning for this sunday will upload and let you know
Hi Mukesh, i have 4 rows in my excel and in for loop, i started with i=1. but while running, the script is running 4 times with first data set as null,null. im not sure why the script is picking the first set as null,null
Can you advice on this?
Hi Mukesh,
I have a small doubt, whenever in the for loop I change i=1 for reading through the excel, it passes null as username and password. Rest of the code I'm using the same as above. Can you please help in this regards.
HI Pankaj,
Start loop with 0
Hi Mukesh,
Nice explanation.
I have used your code but i am getting error "" Cannot get a STRING value from a NUMERIC cell" , so could you please tell me what's the solution to fix this error.
Mukesh,
Please help us with an entire Hybrid Driven Framework creation from the scratch so that it can be helpful for us in projects.
Hi Mukesh,
I'm new to selenium, but your videos are too helpful. Still I'm not able to find Data driven framework excel based part 3 Selenium Webdriver..
Thanks Omkar, DDF3 you can explore from your side. I will try to publish soon.
Hi Mukesh , Nice Explanation , will you please come up with keyword or Hybrid framwork
+sra syed Hi Syed soon
Hi sir, your tutorials are very nice...I hv one question You told while explaining DDF part 1 that if you don't know how configure means go through my previous video right..??
which video I shud go through m not getting please provide me URL of that video...
+roopa patil I mean reading excel sheet
for those who worked in advance selenuim project, What is the difference between storing test dsta in yml file vs excel, when do we need to store data in sql DB?
Thanks a lot Mukesh, really it very useful video for beginners ... I really appreciate to keep posting this kind of video....I hope soon we will get part 3.
can you tell me what is annotation ? how to use annotation and where ?
+Saravana Sakthi Hi Saravana yes will upload soon. Annotation in java is just the seperate class which perform the perticular task. We have different annotations based on requirement. TestNg and Java itself have plenty of annotation. Can you please specify the annotation which you want to know.
Can I try storing all the values of id,xpath,classname,in excel file and then try to call them in through data driven concept.
Hello Mukesh, your video is really nice but where we are passing excel sheet path (test data) .As we need to pass the path.
Hi Saurav in my previous videos I have shown how to create library to read data so I have used the same lib.
Hi Mukesh, your tutorials are really great help. Thank you so much
Just one question, why did you put the FileInputStream inside the ExcelDataConfigConstructor? Is it possible to put it in an ordinary method?
Yes you can use ordinary method as well
can you tell how to read write locators from selenium java without looping?
Hi Areeba, you can use Page Object Model which is common/ standard for writing automated test cases.
Hi Areeba here is the link of Page Object Model ua-cam.com/video/w_iPCT1ETO4/v-deo.html
appreciate ur help....
+jayesh Hoondlani thnx bro
Hi Mukesh, you are the best. Can you please provide us the videos on Keyword Driven Framework also?
Thanks Shravani for KDF I have course for the same learn-automation.usefedora.com/p/selenium-frameworks-and-selenium-question-answers
Thank you.
Hi Mukesh,Pls share Part 3 Video...
Hi Mukesh, where is the part 3 ? unable to find it.