excel批量回写
在pojo包下新建一个批量回写实体类WriteBackData
用来存放回写相关的元素,往excel中哪个sheet页回写,在第几行回写,第几个单元格回写,回写什么内容,和其他实体类一样标准写法
public class WriteBackData {
//回写sheet页
private int sheetIndex;
//回写行号
private int rowNum;
//回写单元格
private int cellNum;
//回写内容
private String content;
//省略了空参、有参构造函数、get、set方法、toString方法重写的代码
}
ExcelUtils类增加excel回写方法
// excel回写内容保存到一个list集合里要存起来
public static List<WriteBackData> wbdList = new ArrayList<WriteBackData>();
// excel批量回写方法
public static void batchWrite() {
FileInputStream fis = null;
FileOutputStream fos = null;
try {
fis = new FileInputStream(Constants.EXCEL_PATH);
Workbook workbook = WorkbookFactory.create(fis);
for (WriteBackData wbd : wbdList) {
Sheet sheet = workbook.getSheetAt(wbd.getSheetIndex());
Row row = sheet.getRow(wbd.getRowNum());
Cell cell = row.getCell(wbd.getCellNum(), MissingCellPolicy.CREATE_NULL_AS_BLANK);
cell.setCellType(CellType.STRING);
//设置回写内容
cell.setCellValue(wbd.getContent());
}
//往excel回写需要输出流
fos = new FileOutputStream(Constants.EXCEL_PATH);
workbook.write(fos);
} catch (Exception e) {
e.printStackTrace();
}finally {
//关流
closeStream(fis);
closeStream(fos);
}
}
//关流方法,输入输出流父类方法不一样,但是父类方法都实现了Closeable接口,所以参数直接使用Closeable接口,多态的好处
public static void closeStream(Closeable stream) {
if(stream != null) {
try {
stream.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
BaseCase类新增增加回写内容到回写集合的方法
public void addWriteBackData(int sheetIndex,int rowNum,int cellNum, String content) {
WriteBackData wbd = new WriteBackData(sheetIndex, rowNum, cellNum, content);
ExcelUtils.wbdList.add(wbd);
}
case类@test方法中增加调用回写集合方法
//回写测试接口对应的案例实际响应结果
addWriteBackData(1, c.getCaseId(), Constants.EXCEL_RESPONSE_COLUMN, body);
//回写到excel那一列可以定义在常量类中Constants.EXCEL_RESPONSE_COLUMN
最后在所有案例执行结束后利用@AfterSuite注解,进行excel批量回写
@AfterSuite
public void finish() {
System.out.println("=======================案例执行完毕excel批量回写============================");
ExcelUtils.batchWrite();
}
【未解决】遗留问题:把 @BeforeSuite和 @AfterSuite移动到BaseCase中运行,就会报错程序执行失败;放在任何一个case类中,能正常运行程序,回写成功