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
}