Selify与TestNG和Java中的数据提供程序不匹配
这里遇到了一些问题,您能告诉我如何解决吗?
下面是我读取Excel的代码
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ReadExcel {
public String unicode;
public String[][] readExcel() throws IOException {
XSSFWorkbook excelObject = new XSSFWorkbook("./data/unicode1.xlsx");
XSSFSheet excelSheet = excelObject.getSheet("Sheet1");
int rows = excelSheet.getLastRowNum();
int columns = excelSheet.getRow(0).getLastCellNum();
String[][] data = new String [rows][columns];
for (int i = 1; i <= rows; i++) {
XSSFRow row = excelSheet.getRow(i);
for (int j = 0; j < columns; j++) {
XSSFCell cell = row.getCell(j);
String cellValue = cell.getStringCellValue();
data[i-1][j] = cellValue;
}
}
return data;
}
}
我的测试用例代码
import java.io.IOException;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
import com.github.javafaker.Faker;
import commonFeatures.CommonThings;
import commonFeatures.ReadExcel;
public class SignUpWithUnicode extends CommonThings{
Faker faker = new Faker();
@Test(dataProvider = "fetchData")
public void signUpWithUnicode(String unicode) throws InterruptedException {
invokeBrowser("chrome", "https://master.signup");
type(locateEle("xpath","//input[@id='first_name-id']"),faker.name().firstName());
type(locateEle("xpath","//input[@id='last_name-id']"),faker.name().lastName());
type(locateEle("xpath","//input[@id='last_name-id']"),faker.name().lastName());
type(locateEle("xpath","//input[@id='client_user_email-id']"),faker.internet().emailAddress());
type(locateEle("xpath", "//input[@id='password-id']"), "12345");
type(locateEle("xpath", "//input[@id='degree-id']"), unicode);
click(locateEle("xpath", "//span[contains(text(),'SUBMIT')]"));
closeBrowser();
}
@DataProvider (name = "fetchData")
public String[][] getData() throws IOException {
ReadExcel excel = new ReadExcel();
return excel.readExcel();
}
}
下面是错误
[RemoteTestNG] detected TestNG version 7.0.0
FAILED: signUpWithUnicode
org.testng.internal.reflect.MethodMatcherException:
[public void testCases.SignUpWithUnicode.signUpWithUnicode(java.lang.String) throws java.lang.InterruptedException] has no parameters defined but was found to be using a data provider (either explicitly specified or inherited from class level annotation).
Data provider mismatch
我在Excel工作表中使用的是Unicode字符,因此我尝试使用Object
而不是String
,但仍然出现此错误。然后,我尝试使用Excel中的字符串来查找错误,但仍未成功。
解决方案
错误为Data provider mismatch
您在ReadExcel
类中以Multi dimensional array
的形式返回数据,但在测试signUpWithUnicode
中以String
的形式传递数据,因此请更改参数类型。
@Test(dataProvider = "fetchData")
public void signUpWithUnicode(String[][] unicode) throws InterruptedException {
//code
}
相关文章