后端代码
@RequestMapping(value = "/exporExcel", method = RequestMethod.GET)
public void exporExcel(HttpServletResponse response) {
ExcelWriter writer = null;
OutputStream outputStream = null;
try {
outputStream = response.getOutputStream();
} catch (IOException e) {
e.printStackTrace();
}
try {
//添加响应头信息
response.setHeader("Content-disposition", "attachment; filename=" + "catagory.xls");
response.setContentType("application/msexcel;charset=UTF-8");//设置类型
response.setHeader("Pragma", "No-cache");//设置头
response.setHeader("Cache-Control", "no-cache");//设置头
response.setDateHeader("Expires", 0);//设置日期头
//实例化 ExcelWriter
writer = new ExcelWriter(outputStream, ExcelTypeEnum.XLS, true);
//实例化表单
Sheet sheet = new Sheet(1, 0, Catagory.class);
sheet.setSheetName("目录");
//获取数据
List<Catagory> catagoryList = new ArrayList<>();
for (int i = 0 ; i < 10; i++){
Catagory catagory = new Catagory();
catagory.setId(1);
catagory.setName("11");
catagoryList.add(catagory);
}
//输出
writer.write(catagoryList, sheet);
writer.finish();
outputStream.flush();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
response.getOutputStream().close();
} catch (IOException e) {
e.printStackTrace();
}
}
// return "index";
}
前段: --不能用ajax请求
atest(row){
location.href=“http://localhost:8080/terminal/exporExcel”;
},