java生成excel

HSSFSheet sheet = wb.createSheet(sheetName); 
  //设置列的宽度
  sheet.setColumnWidth((short)0, (short) 2000);
  sheet.setColumnWidth((short)1, (short) 7000);
  sheet.setColumnWidth((short)2, (short) 4000);
  sheet.setColumnWidth((short)3, (short) 15000);
  sheet.setColumnWidth((short)4, (short) 4000);
  sheet.setColumnWidth((short)5, (short) 5000);
  //表头字体
  HSSFFont fontTitle=wb.createFont();
  fontTitle.setFontName(HSSFFont.FONT_ARIAL);//字体
  fontTitle.setFontHeightInPoints((short) 16);//字号
  fontTitle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//加粗
  fontTitle.setColor(HSSFColor.BLACK.index);//颜色
  fontTitle.setBoldweight((short)50); 
  //表头样式
   HSSFCellStyle centerStyle = wb.createCellStyle();//设置为水平居中 
   centerStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER); 
  centerStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
  centerStyle.setFont(fontTitle);
  //设置表头
  //合并单元格
  Region region=new Region(0, (short)0, 0, (short)5); 
  sheet.addMergedRegion(region);
  HSSFRow rowTitle = sheet.createRow( (0));
  rowTitle.setHeight((short)600);
  HSSFCell cellTitle = rowTitle.createCell((short)0);
  cellTitle.setCellStyle(centerStyle);
  cellTitle.setCellValue("XXXXXXXXXXXXXX表头");

 

 

try {
   HSSFWorkbook wb = importExcelBO.exportTemplet(modelName);
   String filename = "xls名称";
   //为了解决下载文件名中有中文的解决办法
   String tempStr = new String(filename.getBytes("GBK"), "ISO8859_1");
   response.setContentType("application/msexcel");
   // 可以通过设置default file name来确定保存文当时的建议名称。
   response.setHeader("Content-disposition", "attachment; filename="
     + tempStr + ".xls");
   ServletOutputStream os = response.getOutputStream();
   wb.write(os);
   os.flush();
   os.close();
   // 返回到列表页面
   return mapping.findForward("exportsuccess");
  } catch (Exception e) {
   generalError(request, e);
   e.printStackTrace();
   return mapping.findForward(FAIL);
  }