easypoi导出csv文件，wps打开正常，excel2016打开乱码解决方案

追梦混球

已于 2023-05-26 09:15:31 修改

阅读量1.3k

点赞数 1

文章标签： java servlet 开发语言 easypoi excel

于 2022-09-26 22:40:56 首次发布

本文链接：https://blog.csdn.net/Troub_cy/article/details/127062551

版权

/**
     * csv 导出
     */
    public static<T> void exportCsvFile(HttpServletResponse response, List<T> list) throws Exception{
        response.setHeader("content-Type", "text/csv");
        response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode("测试" + ".csv", "utf-8"));
        //导出csv乱码，设置
        ServletOutputStream outputStream = response.getOutputStream();
        outputStream.write(new byte[]{(byte)0xEF, (byte)0xBB, (byte)0xBF});
        CsvExportParams csvExportParams = new CsvExportParams();
        csvExportParams.setEncoding("utf-8");
        outputStream.flush();
        CsvExportUtil.exportCsv(csvExportParams, User.class,list, outputStream);
    }