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;
  • Yes you can. you have to use only one test method. it will execute that test method as many rows available in our sheet (in your case you have 3 combination ). so it will execute same test method 3 time
    – NarendraR
    Feb 12, 2018 at 7:25
  • @NarendraR I want to execute each row for each method. Is it possible? I was trying Factory annotation. But I'm getting Can't invoke public java.lang.Object[][] com.form.test.testcases.getFormTestData(). either make it static or add a no-args constructor to your class error. Feb 12, 2018 at 7:32
  • It's possible, but not without a fair amount of extra work. You would need to use the test class initialization to load your data provider. The data provider would need to be static, and you would need to have each test look up the specific row required.
    – Kate Paulk
    Feb 15, 2018 at 12:46

4 Answers 4


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.

  • 1
    The OP already has that part working - they want to know how to use the same data provider and spreadsheet for different test cases.
    – Kate Paulk
    Feb 15, 2018 at 12:35
  • @KatePaulk Hey, I would suggest you write a method to your excel reader class to read another string(column) called filter and then you can specify which test uses which row of data in that method.
    – Jithu Paul
    Feb 15, 2018 at 16:05

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);


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.

public void formTest(String firstName, String lastName, String phoneNumber, 
                     String expectedMessage) {
    String actualErrorMesage=getErrorMessage();

Yes, you can do it using dataProvider in Selenium.
Refer below example:

  public void formTest(String firstName, String lastName, String phoneNumber, 
                 String expectedMessage) {
 /** your code to enter first name */
 /** your code to enter last name */
 /** your code to enter phone number */
 /** your code to click on submit button ''just i guess */

 if(invalidusernameerrormessage != null){
   } else if(invalidPasswordErrorMessage != null){
      assertEquals(invalidPasswordErrorMessage ,expectedMessage);
   }  else if(invalidPhoneNoErrorMessage != null){
      assertEquals(invalidPhoneNoErrorMessage ,expectedMessage);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.