使用java生成excel功能实现

 

1.jsp页面

发送请求地址：s9p67_createExcel.do

2.服务器端

public String createExcel() {
  try {
   HttpServletResponse response = ServletActionContext.getResponse();
   OutputStream os = response.getOutputStream();
   response.reset();
   response.setContentType("application/msexcel;charset=gbk");  //设置响应格式

//设置响应头，即报表头
   response.setHeader("Content-disposition", "attachment;filename=" + new String("业务受理量统计报表".getBytes(), "iso-8859-1") + ".xls");

   HSSFWorkbook hwb = new HSSFWorkbook();
   HSSFSheet sheet = hwb.createSheet("new Sheet");
   hwb.setSheetName(0, "业务受理量统计");

   HSSFRow row = sheet.createRow((short) 0);
   sheet.createFreezePane(0, 1);//设置第一行显示内容
   createCell(hwb, row, (short) 0, "业务类型");
   createCell(hwb, row, (short) 1, "操作名称");
   createCell(hwb, row, (short) 2, "数量");
   createCell(hwb, row, (short) 3, "收取金额");
   createCell(hwb, row, (short) 4, "工号");

//busBeans列表，为要显示的数据

for (int i = 1; i <= busBeans.size(); i++) {
    HSSFRow row1 = sheet.createRow((short) i);
    for (int j = 0; j < 5; j++) {
     if (j == 0) {
      createCell(hwb, row1, (short) j, busBeans.get(i - 1).getStatName());
     } else if (j == 1) {
      createCell(hwb, row1, (short) j, busBeans.get(i - 1).getFunName());
     } else if (j == 2) {
      createCell(hwb, row1, (short) j, busBeans.get(i - 1).getCountNum());
     } else if (j == 3) {
      createCell(hwb, row1, (short) j, busBeans.get(i - 1).getMoney());
     } else if (j == 4) {
      createCell(hwb, row1, (short) j, busBeans.get(i - 1).getLoginNo());
     }
    }
   hwb.write(os);
   os.close();
   return "createSuccess";
  } catch (Throwable e) {
   e.printStackTrace();
   this.forwardError(e.getMessage());
  }
  return "fail";
 }

 public void createCell(HSSFWorkbook wb, HSSFRow row, short col, String val) {
  HSSFCell cell = row.createCell(col);
  cell.setCellValue(val);
  HSSFCellStyle cellStyle = wb.createCellStyle();
  cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER_SELECTION);
  cell.setCellStyle(cellStyle);
 }

3.效果如图所示