用HttpServletResponse下载exlcel文件

您可以使用以下示例代码来使用HttpServletResponse下载Excel文件：

public void downloadExcel(HttpServletResponse response) throws IOException {
    response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition", "attachment; filename=example.xlsx");
    response.addHeader("Cache-Control", "no-cache");

    Workbook workbook = new XSSFWorkbook();
    // 在此处添加Excel的数据和格式

    OutputStream outputStream = response.getOutputStream();
    workbook.write(outputStream);
    outputStream.flush();
    workbook.close();
    outputStream.close();
}

请注意，您需要根据您的实际情况修改文件名和工作簿的内容。在此示例中，我们使用XSSFWorkbook创建一个新的Excel工作簿，并将其写入HttpServletResponse的OutputStream中，以实现文件下载。然后，我们刷新并关闭OutputStream和Workbook。

希望这可以帮助到您！<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* *2* [(文件下载，预览)inputstream和outputstream的区别](https://blog.csdn.net/y666666y/article/details/84883841)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
- *3* [java POI XSSFWorkbook 给excel加密](https://blog.csdn.net/muyuanjin67/article/details/119545280)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}} ] [.reference_item]
[ .reference_list ]