servlet service中写导出excel方法
private void exportExcel(HttpServletRequest request, HttpServletResponse response) {
try {
//设置响应头 attachment:弹出下载对话框 online:直接打开
response.setHeader("Content-disposition",
"attachment; filename=" + new String("用户".getBytes("GB2312"), "8859_1") + ".xls");
response.setHeader("pragma", "no-cache");
response.setContentType("application/msexcel");// mime类型
// 获取输出流对象
ServletOutputStream os = response.getOutputStream();
// 创建一个excel表格对象
WritableWorkbook workbook = Workbook.createWorkbook(os);
// 在excel表格对象中创建一个sheet,索引是0,表示第一个sheet
WritableSheet ws = workbook.createSheet("用户列表", 0);
// 在当前工作簿中写一个单元格
ws.addCell(new Label(0, 0, "100"));
// 输出到终端
workbook.write();
workbook.close();
} catch (Exception e) {
e.printStackTrace();
}
}