Java导出excel

/**
* 使用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();
}

//封装导出数据
private List<Student> getData() {
    List<Student> list = new ArrayList<>();
    for (int i = 0; i < 10; i++) {
        Student student = new Student();
        student.setName("测试学生姓名-" + i);
        student.setAge(i);
        student.setSex(i % 2 == 1 ? "男" : "女");
        student.setNum(111111L);
        student.setAddress("追晨始梦优快云博客");
        list.add(student);
    }
    return list;
}