如何发送新创建的 excel 文件作为响应而不将其保存在硬盘上

Question

    List<String> headerRow = Arrays.asList("col1", "col2", "col3","col4","col5"); 
    // Creates a xlsx workbook !!
    XSSFWorkbook wb = ExcelHelper.writeToXlsxExcelFile(headerRow,EjbHelper.getAccountEJb().getCustomersByscPartyNumber("9B7W5")); 
    //Creating a file to dump xlsx
    String fileLocation = "d://try.xlsx";
    FileOutputStream fout = new FileOutputStream(fileLocation);
    workbook.write(fout);
    //Want to Create a Webservice to send response without saving file to hard-disk 
    ResponseBuilder response = Response.ok((Object)fout);
    response.header("Content-Disposition","attachment; filename=" + "ResourceInformation.xlsx");
    return response.build();

上面的代码片段创建一个 xlsx 文件，然后通过响应发送它。我想知道有没有办法直接发送xlsx文件而无需在硬盘上创建文件？

Answer 1

我想

更简单的方法是直接使用HttpServletResponse：

 public void yourMethod(@Context HttpServletResponse httpServletResponse) {
    List<String> headerRow = Arrays.asList("col1", "col2", "col3","col4","col5"); 
    Workbook wb = ExcelHelper.writeToXlsxExcelFile(headerRow,EjbHelper.getAccountEJb().getCustomersByscPartyNumber("9B7W5"));
    response.setHeader("Content-Disposition","attachment; filename=" + "ResourceInformation.xlsx");
    wb.write(response.getOutputStream());
    response.flushBuffer();
}