java - 读取 excel 的内容并在我的 Robotium 测试用例中使用这些值

Question

我正在尝试编写一个代码，其中我正在读取 excel 的内容，我必须使用 excel 中的值并将其传递给我的 Robotium 测试用例。

这是我的代码:

ReadExcel 类://读取第 3 列第 2 行以及第 4 列和第 2 行的值

公共(public)课 ReadExcel {

private String user,pass;
public void read() throws BiffException, IOException
{
     Workbook wrk1 =  Workbook.getWorkbook(new File("D:/Robo/Book1.xls"));
     Sheet sheet1 = wrk1.getSheet(0);

     Cell username = sheet1.getCell(2,1);  // the username from the excel
     Cell password = sheet1.getCell(3,1);  // the password from the excel

     setUser(username.getContents());
     setPass(password.getContents()); 
}
public void setUser(String user) {
    this.user = user;
}
public String getUser() {
    return user;
}
public void setPass(String pass) {
    this.pass = pass;
}
public String getPass() {
    return pass;
}

这是使用Robotium的测试脚本

导入android.test.ActivityInstrumentationTestCase2；导入com.ifs.banking.fiid5015.test.ReadExcel;

导入 com.robotium.solo.Solo;

@SuppressWarnings("原始类型")公共(public)类 FSBTest 扩展 ActivityInstrumentationTestCase2 {

private Solo solo;
private String user,pass;
private static final String TARGET_PACKAGE_ID = "com.ifs.banking.fiid5015";
private static final String LAUNCHER_ACTIVITY_FULL_CLASSNAME = "com.banking.activities.LoginActivity"; 
private static Class<?> launcherActivityClass;
static {
    try {
        launcherActivityClass = Class
        .forName(LAUNCHER_ACTIVITY_FULL_CLASSNAME);
    } catch (ClassNotFoundException e) {

        throw new RuntimeException(e);
    }
}

@SuppressWarnings({ "deprecation", "unchecked" })
public FSBTest() throws ClassNotFoundException {
    super(TARGET_PACKAGE_ID, launcherActivityClass);
}

@Override
protected void setUp() throws Exception {
    solo = new Solo(getInstrumentation(), getActivity());
}
public void testApp() {

    ReadExcel rd= new ReadExcel(); // creating the object for Read excel class
             rd.read();
    user = rd.getUser(); //passing the username
    pass = rd.getPass(); //passing the password

    // Login to the application
    solo.enterText(0,user); // Enter user name
    solo.sleep(1000); 
    solo.enterText(1, "dsf");
    solo.sleep(1000);
    solo.clickOnButton(1); // Try Login! (bad login)
    solo.sleep(10000);
    solo.clickOnButton("OK");
    solo.sleep(5000);

    solo.enterText(1,pass); // Enter Password (authentic password)
    solo.sleep(5000);
    solo.clickOnButton(1); // Try Login! (Valid login)
    solo.sleep(10000);

    // MFA
    solo.clickOnButton(0); // choose Text Me (xxx-xxx-3576)
    solo.sleep(20000);

    solo.clickOnButton(0);
    solo.sleep(20000);
}

@Override
public void tearDown() throws Exception {
    try {
        solo.finalize();
    } catch (Throwable e) {
        e.printStackTrace();
    }
    getActivity().finish();
    super.tearDown();
}

当我尝试运行我的项目时，我遇到了 java.lang.FileNotFoundException 并且我似乎无法从 excel 中获取值。基本上我被困在这里。请帮忙!

谢谢!

Answer 1

您必须将文件放入设备。您可以使用例如 sdcard。

String baseDir = Environment.getExternalStorageDirectory().getAbsolutePath();
String fileName = "Book1.xls";

File f = new File(String.format("%s%s%s", baseDir, File.separator, fileName));