/**
* 使用EasyExcel导出excel
* @param response
* @throws Exception
*/
@GetMapping(value = “/exportExcel”)
public void exportExcel(HttpServletResponse response) throws Exception {
response.setContentType(“multipart/form-data”);
response.setCharacterEncoding(“utf-8”);
response.setContentType(“application/octet-stream;charset=utf-8”);
LocalDate time = LocalDate.now();
String fileName = URLDecoder.decode(“easyExcel导出_” + time, “UTF-8”);
response.setHeader(“Content-Disposition”, “attachment; filename=”" + new String(fileName.getBytes(“gb2312”), “ISO8859-1”) + “.xls” + “”");
OutputStream out = response.getOutputStream();
List data = getData();
Map<Integer,String[]> map = new HashMap<>();
map.put(2,new String[https://win8.com/]{“男”,“女”});//下拉导出
ExcelUtil.exportBySelect(out,data,map);
out.close();
Java导出excel
最新推荐文章于 2024-04-17 14:52:54 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)