How to test using one excel dataprovider in TestNG for multiple test cases

Question

I created a testdata in Excel with multiple test cases. Ex:

#UserName#      #Password#     #PhoneNumber#
invalidUsername validPassword    validPhoneNumber
vaidUsername    invalidPassword  vaildPhoneNumber
vaildUsername   vaildPassword    invailidPhonenumber

When I perform the tests, Each test case will show an error message according the error. Ex:

"Please enter valid username" 
"Please enter correct password" 
"please enter correct phone number"

I'm using TestNG framework. I want to use the @dataprovider method and @test to execute my tests. Is it possible to use one dataprovider for multiple test cases?

Example test I wanted to perform is follow

        @Test(priority=1, dataProvider="getFormTestData")
        public void invalidUsername(String firstName, String lastName, String phoneNumber) {
        System.out.println("Please enter valid username");
        }     

       @Test(priority=2, dataProvider="getFormTestData")
        public void invalidPassword(String firstName, String lastName, String phoneNumber) {
        System.out.println("Please enter valid Password");
        }    

       @Test(priority=3, dataProvider="getFormTestData")
        public void invalidPhoneNumber(String firstName, String lastName, String phoneNumber) {
        System.out.println("Please enter valid Phone Number");
        }    

I'm reading the excel file by each row and column.

        public Object[][] getFormTestData(){
        Object data[][] = UtilPage.getTestData(sName);
        return data;
    }

Answer 1

You might find this material really useful.

You need to define a mechanism to read your excel file (which is described in the link above)

Try to use project path rather than absolute paths like in the example in case you are looking for CI integration.

Answer 2

You need to pass the below arguments:

(String firstName, String lastName, String phoneNumber) inside your script to make it to read the data from excel.

Ex: driver.findElementByXPath("//input[@title='Search']").sendKeys(firstName);

Answer 3

You can add the expected error message in another column in your excel file like this: #UserName# #Password# #PhoneNumber# #expectedMessage#. Then in your test compare the actual error message with the expected message from your excel file. In that way your test will be executed n times with different data where n= number of rows in the excel file.

@Test(dataProvider="getFormTestData")
public void formTest(String firstName, String lastName, String phoneNumber, 
                     String expectedMessage) {
    populateFormData(firstName,lastName,phoneNumber);
    String actualErrorMesage=getErrorMessage();
    assertEquals(actualErrorMesage,expectedMessage);
}