PART 7 - Cucumber Feature file with Excel Data || Excel Utility || Apache POI API
Вставка
- Опубліковано 15 жов 2024
- #CucumberLatestVideos #CucumberBDD #NaveenAutomationLabs
In this video, I have explained how to get the data from excel sheet and use the same data in cucumber feature file.
Latest code available on GIT repo: github.com/nav...
We will be designing different components in this Framework:
1. Feature Files
2. Step Definition Classes
3. Configuration Files
4. Cucumber Hooks with before and after
5. Element Utilities/Libraries/Generic Functions
6. Cucumber 6 Extent Report Adaptor for Spark HTML / PDF Reports
7. Test Runners in JUnit/TestNG
8. Page Classes for POM
9. Maven with pom.xml with different dependencies and plugins
10. Parallel Execution
11. Cucumber 6 Web HTML Reports
12. Screenshot for Failure scenarios
13. Integration with GIT Repo
14. Running test cases from Jenkins
15. Running test cases on Dockerized Selenium GRID
And much more.....
Technologies Used:
1. Selenium WebDriver with Java Language binding
2. Cucumber 6.x JVM library
3. WebDriverManager
4. JDK 1.8
5. Maven (Build tool)
6. Maven Plugins
7. Cucumber extent report 6 adapter
8. JUnit 4.x library / TestNG Cucumber Lib
9. Log4j
10. GIT HUB - Git Repo
11. Docker
12. Jenkins
13. Eclipse (IDE)
14. APACHE POI APIs
15. Excel Sheet
~~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:
www.youtube.co...
Follow me on my Facebook Page:
/ naveenqtpexpert
Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:
t.me/joinchat/...
Paid courses (Recorded) videos:
naveenautomati...
For Java & Selenium - naveenautomatio...
For API (Manual + Automation) - naveenautomatio...
Latest code available on GIT repo: github.com/naveenanimation20/LatestCucumber6WithPOM
Awesome thank you !!!
Naveen , iam getting below error. can you please help me to resolve this
ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console...
[31mWhen [0m[31muser fills the form from given sheetname [0m[31m[1m"contactus"[0m[31m and rownumber [0m[31m[1m0[0m [90m# stepdefinition.ContactUsSteps.user_fills_the_form_from_given_sheetname_and_rownumber(java.lang.String,java.lang.Integer)[0m
[31morg.openqa.selenium.support.ui.UnexpectedTagNameException: Element should have been "select" but was "div"
Build info: version: '3.141.59', revision: 'e82be7d358', time: '2018-11-14T08:17:03'
System info: host: 'LAPTOP-CK5HNK8F', ip: '192.168.1.145', os.name: 'Windows 10', os.arch: 'amd64', os.version: '10.0', java.version: '12.0.2'
Driver info: driver.version: unknown
at org.openqa.selenium.support.ui.Select.(Select.java:48)
at com.pages.ContactUsPage.fillContactUsForm(ContactUsPage.java:27)
at stepdefinition.ContactUsSteps.user_fills_the_form_from_given_sheetname_and_rownumber(ContactUsSteps.java:40)
at ✽.user fills the form from given sheetname "contactus" and rownumber 0(file:///C:/Users/jsrin/eclipse-workspace/CucumberPOMSeries/src/test/resources/AppFeatures/Contactus.feature:7)
[0m
[36mAnd [0m[36muser clicks on send button[0m [90m# stepdefinition.ContactUsSteps.user_clicks_on_send_button()[0m
[36mThen [0m[36mit shows a successful message [0m[36m[1m"Your message has been successfully sent to our team."[0m [90m# stepdefinition.ContactUsSteps.it_shows_a_successful_message(java.lang.String)[0m
Embedding Contact_Us_scenario_with_different_set_of_data [image/png 148419 bytes]
Thanks Naveen. In my scenario, I wanted to fetch data in runtime, as the data status might be keep on changing in pipeline. So what might be the better solution here. Thanks!
You are the God for my automation work
This is what I was looking for from long....Thank you so much Naveen.
This was really helpful. better than most of the other solutions I found elsewhere.
Thankyou Naveen Most awaited topic for cucumber you are simply awesome
Will this work ?
Assume if we have too many rows in excel sheet and if we add new test data in between the rows whole index will change for every test data
Excellent explanation sir, thanks a lot for the video 😊
What if we have some other scenarios to run after this but test data needs to be same?
like for single test data some other scenarios are written but I need to run the whole flow with first set of data and then the whole flow with other set of data.
can you suggest some solution please?
Hello Naveen sir,
Do you have any video for the excel read part which you are using in this video.
Thanks in adv.
If my data set has around 50 columns, how do I do it efficiently? Please
Thank you so much Naveen Sir. We are blessed to have you as a teacher in QA community :)
Tushar, iam getting below error. can you please help me to resolve this
ERROR StatusLogger Log4j2 could not find a logging implementation. Please add log4j-core to the classpath. Using SimpleLogger to log to the console...
[31mWhen [0m[31muser fills the form from given sheetname [0m[31m[1m"contactus"[0m[31m and rownumber [0m[31m[1m0[0m [90m# stepdefinition.ContactUsSteps.user_fills_the_form_from_given_sheetname_and_rownumber(java.lang.String,java.lang.Integer)[0m
[31morg.openqa.selenium.support.ui.UnexpectedTagNameException: Element should have been "select" but was "div"
Build info: version: '3.141.59', revision: 'e82be7d358', time: '2018-11-14T08:17:03'
System info: host: 'LAPTOP-CK5HNK8F', ip: '192.168.1.145', os.name: 'Windows 10', os.arch: 'amd64', os.version: '10.0', java.version: '12.0.2'
Driver info: driver.version: unknown
at org.openqa.selenium.support.ui.Select.(Select.java:48)
at com.pages.ContactUsPage.fillContactUsForm(ContactUsPage.java:27)
at stepdefinition.ContactUsSteps.user_fills_the_form_from_given_sheetname_and_rownumber(ContactUsSteps.java:40)
at ✽.user fills the form from given sheetname "contactus" and rownumber 0(file:///C:/Users/jsrin/eclipse-workspace/CucumberPOMSeries/src/test/resources/AppFeatures/Contactus.feature:7)
[0m
[36mAnd [0m[36muser clicks on send button[0m [90m# stepdefinition.ContactUsSteps.user_clicks_on_send_button()[0m
[36mThen [0m[36mit shows a successful message [0m[36m[1m"Your message has been successfully sent to our team."[0m [90m# stepdefinition.ContactUsSteps.it_shows_a_successful_message(java.lang.String)[0m
Embedding Contact_Us_scenario_with_different_set_of_data [image/png 148419 bytes]
Hi Naveen ,could you pls provide excel which you are using?
Hi Naveen, is there a solution if my rows are dynamic. When and Then are dependent in my project, so cannot use a loop in When.
What about not to run parallelly and one set of data will complete full scenario flow and then browser quit then again browser will open for next user?
I have tried but getting session id null
Naveen how can we read multiple data without giving pre info. ? Is there any way to achieve it with cucumber-junit ?
Thanks for the efforts Naveen for creating this video, much much needed content 👍😊
@naveen can you please help me with one issue when reading data from excel file
I want to read string data which has space as the last character but when i tried using apache poi and read from cell data it is trimming out the last space in the string. Please give a solution for this
What to do if they asked to login once and execute test multiple test cases in a single browser?
Adding each rownumber in featurefile to get the data from an excel sheet is not a feasible solution. It would be better if we can iterate through the rows and columns just by adding the columnname only once. Can you suggest a way to do that in cucumber?
I am using mac and in excel while sending the date value its getting converted to General, though i have saved in date format but unable to pass as date value . Please help
Using the ExcelReader, but it seems openxml4j dependency cannot be found, also when running it, keeps giving me Error " java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream or you haven't provide the poi-ooxml*.jar in the classpath/modulepath - FileMagic: OOXML, having providers: [org.apache.poi.hssf.usermodel.HSSFWorkbookFactory@5e7c141d]" any ideas?? thank you!
Hi sir ,how can we execute same testcase multiple times with execute column "yes "with different test data
nice video. But I think using a feature parser will be the best option and in that way, we can generate report much informative rather than including row number / sheetname and sheet name
But we still have to know how many records we are going to test....is there anyway we can do this without knowing how many records are going to be in the Excel file?
Hi Naveen..ur all vedios are always very helpful..
I have one question...can we use two different execls for data in one feature file for same scenario..can u plz ans this
Hi Naveen,Pls start a API automation batch.
Thank you Naveen for the great content.. Question - Is there any advantage performance wise or space wise if data stored in excel or its just better option for maintenance ?
i am writing two feature file one is for login and another one is from product page . So i copy paste the feature file line from login into product and when i add lines in product feature then says driver is null . can anyone help me
Thanks for the video Naveen, can you please upload a video on how to give range 1-10 like that in examples using retention policy in java as mentioned by you. Please upload naveen, it will be helpful
Hi Naveen,
Thank you for giving us so much knowledge on cucumber.
Currently I am using cucumber in my current organization where I have the challenge to extract data from Excel, now in my project i have 10 feature files all 10 has different scenarios outline if i want to execute 5 different data to execute all 10 feature files 5 different times how to achieve such type is challenge could you please help me out on this
Under one feature file
How many scenario or scenario outline can be added pls answer..
Thanks for the explanation..
Can we write the result in excel sheet ??
Hi All, can anyone help me, I have captured OrderId from application, now i want to write it in my spark report. How do i do that?
Hi Sir , is there a way i can take data from a data provider and pass to a feature file. Please help , thanks
Very helpful video..thank your Sir
Hi Naveen, can we execute scenario based on cell value(Like only required call value rows need to read. All other rows need to skip )
Is there a way to read the whole excel rows without calling from feature file one by one? Bcz if there are a thousand of records in an excel file. We have to right all the rows in the feature file! Thank you.
I m curious about the same thing, I heard QMetry can do that but couldn't find any useful info about this tool
@@tahaa4733 It seems like QMetry is a great test management tool. Thank you very much for mentioning it.
Thats a good one..
1) Is it possible to write data too in the excel by fetching the value from Application?
2) Is it possible to update the data table with the values read from application during runtime?
#NaveenAutomationLabs
Did you get any solution for writting to excel?
Can we create parallel run for the script in this video??
Hi Naveen, Could you please attach the excel sheet? It will help to understand more.
bro when using ur code for csv file facing following error can you please give ant alternate idea for read data from csv file
org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x7974696C69636146, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document
Thanks a lot!sir I have tried working on same type of concept I'm getting classnotfound exception can you please help me out
Hello Naveen sir, Could you please share the CSV format Utility code using java selenium
How to pass the created object contactUsPage to another step definition file , because a common step is available only in another stepdefinition file
Hi Sir, Thanks for the great Information. But, how to test for different locales (localization testing) in cucumber, where expected and actual data will vary?
Nice explanation sir but where we get link of your git repo?
@Naveen I tried code but getting error java.io.FileNotFoundException: \Users
ilima.purane\Desktop\automation.xlsx...filepath is correct though still..can you please guide
use / instead of \
Hi there, thanks for your idea, but should we apply the solution when the excel file has thousands of rows, it means "RowNumber" is listed out from 0 to a certain thousand number?
hi have got answer for this ?
Hi Naveen.
Let's say if the excel sheet have 100 data. Do we have to write it 100 times in feature file ?
Hi did you got solution for this?
@Naveen , How do we handle the case where there are 100/500/1000 numbers of testdata in excel? Do we add those many row# in feature file? Also I want the excel file to be an input to the suite without any change in code. How can this be handled using BDD. Please reply
hey u got answer for this ?
do let me know if u got any videos or solution
Have you got any answer for this , please share
Great video. Please make video on Robot framework with Python and it's future.
Shandar zabardast zindabad
Hi Naveen
I'm having doubt in how to read data from Excel sheet for same scenario with different inputs in scenario outline
Hi have you found answer for this
Hello Naveen, What if we have 100 rows , is there any way to tackle this without Examples.Please help.
m looking for same did u find any way ?
Great to see this content.👌👌👌
How can I get the entire tutorial link?
Thanks Naveen for this video .
Please make a video on how to convert a excel file into cucumber data table just pass the excel file in features file then do some logic and convert that excel file into data tables.
Thanks and any help will be appreciated.
Great explanation sir
Thanks a lot for this video! It's really helpful for me!
Can you please share the How to generate excel reports like extent report in cucumber.
Superb 👍
@naveen how to proceed with feature file if we have 1000’s of row data in excel? Do you have any other idea or concepts?
Hi, do you got any solution for this
Hello sir, can you please do the same tutorial for writing the data into the excel sheet , thank you
Love you sir..
Please guide how to move to DevOps from selenium tester profile
Great Naveen 👍
Make a video for Exceptioninintializer error in cuckumber framework
Thank you so much!
Waiting for better approach..
How do I run parallel execution by getting data from Excel. My data is overridden