使用poi生成Excel文件

1. public ActionForward action(ActionMapping mapping, ActionForm form,
2.             HttpServletRequest request, HttpServletResponse response)
3.             throws Exception {
5.         response.setContentType("application/vnd.ms-excel");
6.         response.addHeader("Content-Disposition", "attachment;filename=xsmd");
8.         HSSFWorkbook wb = new HSSFWorkbook();
9.         HSSFSheet sheet = wb.createSheet("new sheet");
11.         HSSFRow row = sheet.createRow(0);
12.         HSSFCell cell = row.createCell((short) 0);
13.         cell.setCellValue("id");
14.         cell = row.createCell((short) 1);
15.         cell.setCellValue("name");
16.         cell = row.createCell((short) 2);
17.         cell.setCellValue("age");
19.         ServletOutputStream os = response.getOutputStream();
21.         wb.write(os);
23.         os.flush();
25.         return null;
26.     }