- 导入maven坐标依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>4.0.0</version>
</dependency>
- 创建映射实体类
/**
* easyPOI映射实体类,类中的属性需要和Excel表头保持一致
*/
@Data
public class CaseInfo {
@Excel(name="序号(caseId)")
private int caseId;
@Excel(name="接口模块(interface)")
private String interfaceName;
@Excel(name = "用例标题(title)")
private String title;
@Excel(name = "请求头(requestHeader)")
private String requestHeader;
@Excel(name = "请求方式(method)")
private String method;
@Excel(name="接口地址(url)")
private String url;
@Excel(name="参数输入(inputParams)")
private String inputParams;
@Excel(name="期望返回结果(expected)")
private String expected;
@Excel(name = "数据库校验(checkSql)")
private String checkSql;
}
- 读取数据
/**
* 从Excel读取所需的用例数据
* @param index sheet的索引,从0开始的
* @return caseinfo实体对象集合
*/
public List<CaseInfo> getCaseDataFromExcel(int index) {
ImportParams importParams = new ImportParams();
//设置工作簿索引
importParams.setStartSheetIndex(index);
//设置第一列为主键,跳过空行
importParams.setKeyIndex(0);
//设置要读取的文件路径
//Constants.EXCEL_PATH="src\\test\\resources\\api_testcases.xls"
File excelFile = new File(Constants.EXCEL_PATH);
//读取文件返回数据,列表中每一个对象存储excel表的一列数据
List<CaseInfo> list = ExcelImportUtil.importExcel(excelFile, CaseInfo.class, importParams);
return list;
}