TestNG Data Provider using Excel
package testng;
import java.util.Hashtable;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
public class testNGParameterizationExcel {
public static ExcelReader excel = null;
@Test(dataProvider = "getData")
public void testData(Hashtable<String, String> data) {
// System.out.println(username + "---------" + password + "------------"
// + is_correct);
System.out.println(data.get("UserName"));
}
@DataProvider
public static Object[][] getData() {
if (excel == null) {
excel = new ExcelReader("C:\\Users\\shaanu\\Desktop\\Java\\Test.xlsx");
}
String sheetName = "new";
int rows = excel.getRowCount(sheetName);
int columns = excel.getColumnCount(sheetName);
Object[][] data = new Object[rows - 1][1];
Hashtable<String, String> table = null;
for (int rowNums = 2; rowNums <= rows; rowNums++) {
table = new Hashtable<String, String>();
for (int colNum = 0; colNum < columns; colNum++) {
// data[rowNums-2][colNum] = excel.getCellData(sheetName,
// colNum, rowNums);
table.put(excel.getCellData(sheetName, colNum, 1), excel.getCellData(sheetName, colNum, rowNums));
data[rowNums - 2][0] = table;
}
}
return data;
}
}
Are there any code examples left?
New code examples in category Other
-
Other 2023-03-27 22:50:10 how to select the whole line in vscode with keyboard shortcut
-
Other 2022-03-27 22:45:24 income of a web developer
-
Other 2022-03-27 22:35:01 \pyrcc_main.py: File does not exist 'resources.qrc'
-
Other 2022-03-27 22:30:45 rick roll embed code
-
Other 2022-03-27 22:20:08 Circuit_04_Potentiometer
-
Other 2022-03-27 22:20:05 iterative power
-
Other 2022-03-27 22:15:11 flutter run all
-
Other 2022-03-27 22:10:05 when is karlson release
-
Other 2022-03-27 22:10:02 wp .htaccess example
-
Other 2022-03-27 22:00:08 bash pause in file read line by line