There will be one main Excel Sheet [Test Runner] with Test Modules listed along with that the flagged test cases to be Run as Yes/No.
There will be test modules Workbooks, per module one workbook. This test module workbook will have two sheets.
The first sheet will have test case IDs and keywords to be run listed in a horizontal keyword-driven sequence.
The second sheet will have the test case IDs and data to be used; mentioned column-wise, this data will be used in the keyword methods from sheet1.
Behavior to be achieved:
The flagged cases as Yes from the main sheet will be picked against the test modules; based on the keywords arranged in sheet1; will be run; using the test data from sheet 2.
The key identifier is TC ID from the main sheet to test module workbook [sheet1 ,sheet2]
The keywords mentioned in sheet 1 here are testng methods from script class.
Main sheet is : Test Runner
Test Module Sheet sample: MobileSite_Test
8 freelancers are bidding on average ₹9361 for this job
Hello, I'm java programmer and tester. I work with java, python, selenium and testNG. I worked making automatic testing excell. I can help you with this.
Hi, I have knowledge on your requirement and able to automate using Data driven framework. Handling multiple excel files using POI api. Please reach out to me to discuss more details.