POI 火狐下载文件-中文文件名乱码

最新推荐文章于 2023-04-16 10:15:31 发布

馥钰

最新推荐文章于 2023-04-16 10:15:31 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： jsp spring mvc 文章标签： poi 乱码

本文链接：https://blog.youkuaiyun.com/liyanlei5858/article/details/51191195

jsp 同时被 2 个专栏收录

27 篇文章

订阅专栏

spring mvc

11 篇文章

订阅专栏

本文介绍了解决在导出Excel文件时遇到的中文文件名显示乱码的问题。通过使用UTF-8编码转换为ISO8859-1，确保了文件名在不同浏览器和系统中正确显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

fileName = new String((fileName).getBytes("UTF-8"), "ISO8859_1")+Dates.formatDateTime_New(new Date());

response.setContentType("application/vnd.ms-excel");

response.setHeader("Content-disposition", "attachment;filename=" + fileName.replace(" ", "_") + ".xls");

UTF-8文件名正常显示，gb2312中文乱码，所以要用UTF-8

以下两种代码都是可以的


	private void initResponseHeader(HttpServletResponse response) throws UnsupportedEncodingException {
		StringBuilder stringBuilder = new StringBuilder();
		stringBuilder.append("办赛申请");
		stringBuilder.append("_");
		stringBuilder.append(DateUtil.formatByPattern(Instant.now().toEpochMilli(), DateUtil.DATE_FORMAT));
		stringBuilder.append("_");
		stringBuilder.append(UUIDUtil.getUUID());
		stringBuilder.append(".xlsx");

        //解决中文文件名不显示
        String fileName = new String(stringBuilder.toString().getBytes("UTF-8"), "iso8859-1") ;

        //设置Http响应头告诉浏览器下载这个附件
        response.setHeader("Content-disposition", "attachment; filename=" + fileName);
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("UTF-8");
	}

private void initResponseHeader(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException {
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.append("企业用户");
        stringBuilder.append("_");
        stringBuilder.append(DateUtil.formatByPattern(Instant.now().toEpochMilli(), DateUtil.DATE_FORMAT));
        stringBuilder.append("_");
        stringBuilder.append(UUIDUtil.getUUID());
        stringBuilder.append(".xlsx");

        //解决中文文件名不显示
        String fileName = new String(stringBuilder.toString().getBytes("UTF-8"), "iso8859-1") ;

        response.setContentType("application/octet-stream");
        response.setContentType("application/x-download");

        //设置Http响应头告诉浏览器下载这个附件
        response.setHeader("Content-disposition", "attachment; filename=" + fileName);
        response.setCharacterEncoding("UTF-8");

    }