所以我有一个 Spring 控制器,我想创建一个 Excel 文件并返回它,以便浏览器下载它。
我正在使用 JEXcelApi。
这是我的控制器代码
@RequestMapping(value="/excel/cols/{colString}/rows/{rowString}/", method = RequestMethod.GET)
@ResponseBody
public ResponseEntity<String> exportExcel(HttpServletResponse response,
@PathVariable List<String> colString,
@PathVariable List<String> 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的抽象Excel视图类,但是有没有更简单的方法?
您需要设置Content-Disposition
header.
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();
上面的内容比较老了。你可以构造一个ResponseEntity
with FileSystemResource now. A ResourceHttpMessageConverter然后将按照我上面的建议为您复制字节。 Spring MVC 让您变得更简单,而不是让您与 Servlet 规范中的接口进行交互。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)