【坑】自动化测试之Excel表格
参考一位大神的博客项目架构,把元素和数据都参数化,但是总是被excel表格坑
1.无法下拉
动作列通过下拉列表来控制,点击下拉列表无反应
解决方案:不知道是不是中间动了什么,因为Excel版本的问题,一直在调整,所以重新设置一遍
先设为任何值,之后再引入来源设为序列,下拉列表重新赋值
2.运行代码最后一行报空指针
解决方案:有时候表格会有隐藏数据,所以直接断点查看了总行数,发现有11行,多了一条数据,所以直接删除即可
3.找不到文件 2.xlsx
然而我项目中并没有这个文件
所以,推测是数据问题,断点查看,神坑,
输入框有个空格,获取不到值,取的是序号的值,去掉成功了
4.版本问题
不管是一开始的驱动版本,还是现在的Excel版本,都调了好久,因为是自己调,所以花费了很长时间,所以把目前完整的pom文件记录下来
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
1 <?xml version="1.0" encoding="UTF-8"?> 2 <project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 3 xmlns="http://maven.apache.org/POM/4.0.0" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <modelVersion>4.0.0</modelVersion> 6 7 <groupId>com.meiyunji.gogoMall</groupId> 8 <artifactId>gogoMall</artifactId> 9 <version>1.0-SNAPSHOT</version> 10 <properties> 11 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> 12 <allure.version>1.4.23</allure.version> 13 <aspectj.version>1.8.5</aspectj.version> 14 </properties> 15 <!-- https://mvnrepository.com/artifact/org.seleniumhq.selenium/selenium-java web应用程序测试工具--> 16 <dependencies> 17 <dependency> 18 <groupId>org.seleniumhq.selenium</groupId> 19 <artifactId>selenium-java</artifactId> 20 <version>LATEST</version> 21 </dependency> 22 <!-- https://mvnrepository.com/artifact/org.testng/testng 开源自动化测试框架--> 23 <dependency> 24 <groupId>org.testng</groupId> 25 <artifactId>testng</artifactId> 26 <version>6.9.5</version> 27 </dependency> 28 <!-- https://mvnrepository.com/artifact/log4j/log4j 日志--> 29 <dependency> 30 <groupId>log4j</groupId> 31 <artifactId>log4j</artifactId> 32 <version>1.2.16</version> 33 <scope>provided</scope> 34 </dependency> 35 <!-- https://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl 用java操作excel文件--> 36 <dependency> 37 <groupId>net.sourceforge.jexcelapi</groupId> 38 <artifactId>jxl</artifactId> 39 <version>2.6.12</version> 40 </dependency> 41 <!-- https://mvnrepository.com/artifact/com.google.code.gson/gson --> 42 <dependency> 43 <groupId>com.google.code.gson</groupId> 44 <artifactId>gson</artifactId> 45 <version>2.8.2</version> 46 </dependency> 47 <!-- https://mvnrepository.com/artifact/javax.mail/mail 发送邮件--> 48 <dependency> 49 <groupId>javax.mail</groupId> 50 <artifactId>mail</artifactId> 51 <version>1.5.0-b01</version> 52 </dependency> 53 <dependency> 54 <groupId>com.codeborne</groupId> 55 <artifactId>phantomjsdriver</artifactId> 56 <version>1.2.1</version> 57 </dependency> 58 <dependency> 59 <groupId>commons-configuration</groupId> 60 <artifactId>commons-configuration</artifactId> 61 <version>1.9</version> 62 </dependency> 63 <!--解析java源代码--> 64 <dependency> 65 <groupId>com.thoughtworks.qdox</groupId> 66 <artifactId>qdox</artifactId> 67 <version>1.12.1</version> 68 <scope>compile</scope> 69 </dependency> 70 <dependency> 71 <groupId>org.seleniumhq.selenium</groupId> 72 <artifactId>selenium-remote-driver</artifactId> 73 <version>LATEST</version> 74 </dependency> 75 <dependency> 76 <groupId>commons-io</groupId> 77 <artifactId>commons-io</artifactId> 78 <version>2.5</version> 79 </dependency> 80 <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml --> 81 <dependency> 82 <groupId>org.apache.poi</groupId> 83 <artifactId>poi-ooxml</artifactId> 84 <version>3.10-FINAL</version> 85 </dependency> 86 <!-- https://mvnrepository.com/artifact/org.apache.poi/ooxml-schemas --> 87 <dependency> 88 <groupId>org.apache.poi</groupId> 89 <artifactId>ooxml-schemas</artifactId> 90 <version>1.3</version> 91 </dependency> 92 </dependencies> 93 <!--构建项目需要的信息--> 94 <build> 95 <!--使用的插件列表--> 96 <plugins> 97 <plugin> 98 <!--指定项目源码的jdk版本--> 99 <groupId>org.apache.maven.plugins</groupId> 100 <version>3.1</version> 101 <artifactId>maven-compiler-plugin</artifactId> 102 <configuration> 103 <source>1.8</source> 104 <target>1.8</target> 105 </configuration> 106 </plugin> 107 </plugins> 108 </build> 109 110 </project>
银河不清不浊,一城便可