seleniumWebDriver自动化测试框架_03TestNG和ApachePOIExcel文件数据驱动测试
1.遇到的问题
a.报错信息:FAILED: f
java.lang.NoClassDefFoundError: org/w3c/dom/ElementTraversal
解决方法:maven项目的pom.xml中引入如下依赖包
<dependency>
<groupId>xml-apis</groupId>
<artifactId>xml-apis</artifactId>
<version>1.4.01</version>
</dependency>
b.报错信息:FAILED: f
java.lang.IllegalStateException: Cannotget a text value from a numeric cell
解决办法:此异常常见于类似如下代码中:row.getCell(0).getStringCellValue();
解决办法:先设置Cell的类型,然后就可以把纯数字作为String类型读进来了:
if(row.getCell(0)!=null){
row.getCell(0).setCellType(Cell.CELL_TYPE_STRING);
stuUser.setPhone(row.getCell(0).getStringCellValue());
}
============================
操作步骤:
1.maven项目中引入apache poi的jar包:
<dependencies>
<dependency>
<groupId>org.seleniumhq.selenium</groupId>
<artifactId>selenium-java</artifactId>
<version>2.44.0</version>
</dependency>
<dependency>
<groupId>org.jsoup</groupId>
<artifactId>jsoup</artifactId>
<version>1.8.3</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.9</version>
</dependency>
<dependency>
<groupId>xml-apis</groupId>
<artifactId>xml-apis</artifactId>
<version>1.4.01</version>
</dep