Spring导出Excel跨浏览器兼容问题求助（仅Firefox可用）

问题根源分析 #

从报错信息和代码来看，问题集中在三个方面：

1. Content-Disposition头部解析失败：文件名包含逗号且未做特殊处理，导致部分浏览器解析时生成重复的响应头，触发ERR_RESPONSE_HEADERS_MULTIPLE_CONTENT_DISPOSITION
2. 输出流重复调用：流的关闭时机错误，引发getOutputStream() has already been called for this response
3. Workbook资源未正确释放：Workbook关闭逻辑错误，导致Excel文件结构写入不完整，触发/docProps/core.xml failed to be saved

具体修复方案 #

1. 修复Content-Disposition头部（解决跨浏览器文件名问题） #

文件名包含特殊字符（如逗号）时，必须用双引号包裹，同时对文件名进行URL编码，确保所有浏览器都能正确解析：

String fileName = "CPE, " + mainProiect.getBuilding().getTitular() + currentDateTime + ".xlsx";
// 编码文件名兼容不同浏览器
String encodedFileName = URLEncoder.encode(fileName, StandardCharsets.UTF_8.name());
// 用双引号包裹文件名，避免特殊字符导致的头部解析错误
String headerValue = String.format("attachment; filename=\"%s\"; filename*=UTF-8''%s", fileName, encodedFileName);
response.setHeader(headerKey, headerValue);

2. 修正Controller的流处理逻辑 #

将Controller方法返回类型改为ResponseEntity<Void>，避免Spring视图解析器介入，同时使用更精确的xlsx文件MIME类型：

@Controller
@RequestMapping("/show")
public class ShowCPEController {
    CPE cpe;

    @Autowired
    private CpeService cpeService;

    @GetMapping("/export-to-excel")
    public ResponseEntity<Void> exportIntoExcelFile(HttpServletResponse response) throws IOException {
        // 使用xlsx标准MIME类型
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        DateFormat dateFormatter = new SimpleDateFormat("yyyy-MM-dd_HH:mm:ss");
        String currentDateTime = dateFormatter.format(new Date());

        String headerKey = "Content-Disposition";
        String fileName = "CPE, " + mainProiect.getBuilding().getTitular() + currentDateTime + ".xlsx";
        String encodedFileName = URLEncoder.encode(fileName, StandardCharsets.UTF_8.name());
        String headerValue = String.format("attachment; filename=\"%s\"; filename*=UTF-8''%s", fileName, encodedFileName);
        response.setHeader(headerKey, headerValue);

        List<CPE> listOfCpe = cpeService.findAll();
        cpe = cpeService.findByProject(mainProiect.getProjectId());
        mainProiect.setCpe(cpe);

        CPEtoExcelGenerator generator = new CPEtoExcelGenerator();
        generator.generateExcelFile(response);

        return ResponseEntity.ok().build();
    }
}

3. 修正Excel生成类的资源释放逻辑 #

利用try-with-resources自动管理Workbook和输出流，避免手动关闭导致的资源冲突：

public class CPEtoExcelGenerator {
    private XSSFWorkbook workbook;

    public CPEtoExcelGenerator(){
        workbook = new XSSFWorkbook();
    }

    public void generateExcelFile(HttpServletResponse response) throws IOException {
        DefineSheet();
        Line1_2();
        Line5();
        Line2127(23, "A", 2, A);
        Line59();
        Line62();
        DrawHomeplate();

        setBorders(CellRangeAddress.valueOf("B4:Ap6"), BorderStyle.THIN);
        setBorders(CellRangeAddress.valueOf("B8:Ap8"), BorderStyle.THIN);
        setBorders(CellRangeAddress.valueOf("A1:AP61"), BorderStyle.MEDIUM);

        // 用try-with-resources自动关闭Workbook和输出流
        try (ServletOutputStream outputStream = response.getOutputStream();
             XSSFWorkbook wb = workbook) {
            wb.write(outputStream);
            outputStream.flush();
        } catch (IOException e) {
            logger.log(Level.SEVERE, "excel output err: ", e);
        }
    }

    // 自定义方法（DefineSheet、Line1_2等）省略...
}

4. 额外注意事项 #

• 确保mainProiect变量已正确初始化，避免空指针异常
• 检查Line2127方法中的变量A是否已定义，避免未定义变量错误

内容的提问来源于stack exchange，提问作者danciplus