<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;
}