java实现导出excel

@PostMapping("excel")
    @ControllerEndpoint(exceptionMessage = "导出Excel失败")
    @ApiOperation(value = "导出评估的房源列表", notes = "只传评估编号即可")
    public void export(QueryRequest queryRequest, Appraisal appraisal, HttpServletResponse response) throws IOException {
        List houses = this.appraisalService.findAppraisalHouses(queryRequest, appraisal).getRecords();

        String fileName = URLEncoder.encode("测试导入导出数据.xlsx", "UTF-8");
        response.setContentType("application/octet-stream");
        response.setCharacterEncoding("utf-8");
        response.setHeader("Content-disposition", "attachment;filename=" + fileName);
        EasyExcel.write(response.getOutputStream(), AppraisalHouseExcelDTO.class)
                .sheet()
                .doWrite(houses);
    }