最近接到这样的需求:原先excel导出只需要导出一个excel,需求变更为,需要一次导出多个excel文档。但是一个请求只能输出一次,所以无法通过输出流循环将excel导出。转而改为将excel文档全部打包,输出zip文档。
代码如下:
@RequestMapping(params = "exportXlsT")
public void exportXlsT(SeatEntity rowSeat, HttpServletRequest request, HttpServletResponse response,DataGrid dataGrid, ModelMap map) {
String rowSeatId = request.getParameter("id");
String hql = "from SeatResultEntity where 1 = 1 AND ROW_SEAT_ID = ? ";
List<SeatResultEntity> seatResultList = this.systemService.findHql(hql, rowSeatId);
String codedFileName = "模板";
String meetingName = "模板";
try {
File template = new File(this.context.getRealPath("/template"), "template.xls");
List<HSSFWorkbook> hssfWorkbookList = new ArrayList<>();
List<String> xlsNameList = new ArrayL