/**
* 导出EXCEL
*
* @throws FileNotFoundException
*/
@RequestMapping("/excel")
public void excel(HttpServletRequest request, HttpServletResponse response) throws Exception {
ExcelWriter writer = null;
OutputStream outputStream = response.getOutputStream();
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, QInformationModel.class);
sheet.setSheetName("客户信息管理");
//获取数据
// PageUtils page = qInformationService.queryPage(params);
List<QInformationModel> list = qInformationService.queryAll();
//输出
writer.write(list, sheet);
writer.finish();
outputStream.flush();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
response.getOutputStream().close();
} catch (IOException e) {
e.printStackTrace();
}
}
}