java easyexcel 写入数据到excel中的多个sheet中

最新推荐文章于 2025-09-26 16:59:34 发布

原创

最新推荐文章于 2025-09-26 16:59:34 发布 · 8.3k 阅读

17 ·

CC 4.0 BY-SA版权

文章标签：

#java

本文介绍了如何使用EasyExcel在Spring MVC控制器中实现批量下载上传结果的功能，涉及了HTTP请求处理、参数校验、Excel文件生成及定制单元格写入策略。服务类详细展示了如何通过EasyExcel操作数据并设置列宽，以及CustomCellWriteHandler用于处理Excel样式。

controller方法：

@ApiOperation("下载导入结果")
    @RequestMapping(value = "/downloadUploadResut", method = RequestMethod.POST)
    public void batchDownload(HttpServletRequest request,
                              HttpServletResponse response,
                              @RequestBody  DownloadAssetResultDto  downloadAssetResultDto) throws Exception {

        if(downloadAssetResultDto==null || downloadAssetResultDto.getUploadId()==null){
            throw  new RRException("上传数据ID为空，请先上传数据");
        }

        request.setCharacterEncoding("UTF-8");
        String prefix=".xlsx";
        String fileName="uploadResult";
        String userAgent = request.getHeader("User-Agent");
        String     downLoadPath = URLDecoder.decode(fileName, "UTF-8");
        System.out.println(downLoadPath);
        try {

            response.setContentType("application/vnd.ms-excel");
            fileName = URLEncoder.encode(fileName, "ISO8859-1");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
            response.setHeader("filename",fileName);
            Integer uploadId = downloadAssetResultDto.getUploadId();
            downloadAssetService.downloadUploadResut(response,uploadId);


        } catch (Exception e) {
            e.printStackTrace();
        }

    }

service业务类实现方法：

@Override
    public void downloadUploadResut(HttpServletResponse response,Integer  uploadId) {
        ExcelWriter excelWriter = null;
        try {
            CustomCellWriteHandl