1,添加Bean Shell PostProcessor元件
2,编写Bean Shell脚本——将导出的excel保存到本地
脚本内容:
String resPonseCode = prev.getResponseCode();
if(resPonseCode.equals("200")){
ResponseData = prev.getResponseData();
String ResponseDataType = ResponseData.getClass().getName();
if(ResponseDataType.equals("[B")){
//获取当前请求返回的数据,prev获取上个请求返回数据
byte[] result = ResponseData;
log.warn(result.getClass()+"");
//存放文件的位置和文件名
String file_path = "C:/Users/Administrator/Desktop/ExcelExportDoc/excel_${__time(yyMMddHHmmss,)}.xlsx";
File file = new File(file_path);
FileOutputStream out = new FileOutputStream(file);
out.write(result);
out.close();
if(file.exists()){
//导出文件内容验证须到本地file_path查看,判断文件是否存在
prev.setResponseData("导出成功","UTF-8");
log.warn("导出成功");
}
else{
prev.setResponseData("导出失败","UTF-8");
log.warn("导出失败");
}
}
}