在写好的excel结构之后,添加如下代码
//通过Response把数据以Excel格式保存
response.reset();
response.setContentType("application/msexcel;charset=UTF-8");
response.setCharacterEncoding("UTF-8");
try {
response.addHeader("Content-Disposition", "attachment;filename=\""
+ new String(("test" + ".xls").getBytes("UTF-8"),
"ISO8859-1") + "\"");
OutputStream out = response.getOutputStream();
hssfWorkbook.write(out);
out.flush();
out.close();
hssfWorkbook.close();
} catch (Exception e) {
e.printStackTrace();
}