2

The Test scenario is - I have one excel Sheet with multiple sheet. I have to use multiple sheet data in one test method. I have created multiple data generators but don't know how to use multiple data generator in same test method.

Data Generator is below:

@DataProvider(name = "Excel")
public static Object[][] testDataGenerator()
        throws Exception {
    ExcelHelper excelManager = new ExcelHelper();
    List<HashMap<String, String>> dataFromFile = excelManager.readSheet(
            TEST_DATA,"Automation");

    Object[][] data = new Object[dataFromFile.size()][1];
    for (int i = 0; i < data.length; i++) {
        data[i][0] = dataFromFile.get(i);
    }       

    return data;
}
@DataProvider(name = "Excel1")
    public static Object[][] testDataGenerator1()
            throws Exception {    
        ExcelHelper excelManager = new ExcelHelper();
        List<HashMap<String, String>> dataFromFile = excelManager.readSheet(
                TEST_DATA,"Automation1");    
        Object[][] data = new Object[dataFromFile.size()][1];
        for (int i = 0; i < data.length; i++) {
            data[i][0] = dataFromFile.get(i);
        }       

        return data;
    }

Test method is below:

  @Test(dataProvider = "Excel", dataProviderClass = DataGenerators.class, priority = 0)
    public void sampleTest(HashMap<String, String> testData){
xyz
}

0 Answers0