java excel api 下载文件_java – 从Spring返回Excel可下载文件

所以我有一个Spring控制器,我想创建一个Excel文件并将其返回,以便浏览器下载它.

我正在使用JEXcelApi.

这是我的控制器代码

@RequestMapping(value="/excel/cols/{colString}/rows/{rowString}/", method = RequestMethod.GET)

@ResponseBody

public ResponseEntity exportExcel(HttpServletResponse response,

@PathVariable List colString,

@PathVariable List rowString) throws JSONException, IOException, WriteException {

WritableWorkbook workbook = Workbook.createWorkbook(new File("exported.xls"));

WritableSheet sheet = workbook.createSheet("Exported",0);

String[] cols = colString.get(0).split(",");

String[] rows = rowString.get(0).split(",");

for(int i = 0; i < cols.length;i++){

Label label = new Label(i,0, cols[i]);

sheet.addCell(label);

}

int excelCol = 0;

int excelRow = 1;

for(int i = 0; i < rows.length;i++){

Label label = new Label(excelCol,excelRow, rows[i]);

sheet.addCell(label);

excelCol++;

if((i+1) % cols.length == 0){

excelCol = 0;

excelRow++;

}

}

workbook.write();

workbook.close();

return null;

}

我怎么做？我怀疑我可以设置一些内容标题.我知道一种方法是使用Spring的Abstract Excel视图类,但是有一个更简单的方法吗？

解决方法:

您需要设置Content-Disposition标头.

response.setHeader("Content-disposition","attachment; filename=" + yourFileName);

并将您的字节直接写入响应OutputStream.

File xls = new File("exported.xls"); // or whatever your file is

FileInputStream in = new FileInputStream(xls);

OutputStream out = response.getOutputStream();

byte[] buffer= new byte[8192]; // use bigger if you want

int length = 0;

while ((length = in.read(buffer)) > 0){

out.write(buffer, 0, length);

}

in.close();

out.close();

以上是相对陈旧的.您现在可以使用FileSystemResource构建ResponseEntity.然后,ResourceHttpMessageConverter将为您复制字节,如上所述. Spring MVC使您更简单,而不是让您与Servlet规范中的接口进行交互.

标签：java,spring,excel,spring-mvc

来源： https://codeday.me/bug/20191006/1858191.html