List<OpeningEnb> list = openingEnbService.selectOpeningEnbList(openingEnb);
InputStream resourceAsStream = this.getClass().getClassLoader().getResourceAsStream("opening/opening.xlsx");
String fileName = "基站开通信息表.xlsx";
response.setContentType("application/vnd.ms-excel");
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-disposition","attachment;filename="+new String(fileName.getBytes(),"iso-8859-1"));
EasyExcel.write(response.getOutputStream(),OpeningEnbController.class).withTemplate(resourceAsStream).sheet().doFill(list);
直接看代码就是这么简单。(使用的easyexcel填充技术)