[alibaba/easyexcel]web 导出excel 内容乱码

2024-06-20 112 views
6

锟斤5铮碉5铮碉5铮碉5铮碉5铮碉5铮碉5铮碉5铮碉5铮 之类 乱码 ![Uploading image.png…]()

回答

5
            request.setCharacterEncoding("GBK");
            response.setCharacterEncoding("GBK");
            response.setHeader("Content-Type", "application/vnd.ms-excel");
            response.setHeader("Content-Disposition",
                    "attachment;filename=" + URLEncoder.encode(filename + ".xls", "GBK"));
            ServletOutputStream out = response.getOutputStream();
            ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLS);
            Sheet sheet = new Sheet(1, 0, RandomCheckExcelDateModel.class);
            sheet.setSheetName("randDomCheck");
            writer.write(data, sheet);
            writer.finish();
            out.flush();
7

问题结局了吗?我也遇到了同样的问题,前端用的ant design pro

7

代码没有问题 之前 是我导出用的方式有问题 如果用swagger 调用接口导出Excel swagger 会导致excel 乱码 解决方式: 直接在浏览器中 输入导出对应访问url 就可以了!! swagger 有点坑 在excel 导出这块