POI excel处理

1、excel标题样式

 /**   * @desc 标题样式：边框 + 字体上下左右居中 + 背景颜色
       * @param workbook
       * @param color 前景颜色
       * @return   */  public static CellStyle getCenterTitleStyle(Workbook workbook,short color) {
          CellStyle style = workbook.createCellStyle();
          Font font = workbook.createFont();
          font.setFontHeightInPoints((short) 9);
          style.setVerticalAlignment(VerticalAlignment.CENTER);
          style.setAlignment(HorizontalAlignment.CENTER);
          style.setFont(font);
          style.setBorderBottom(BorderStyle.THIN);
          style.setBorderLeft(BorderStyle.THIN);
          style.setBorderRight(BorderStyle.THIN);
          style.setBorderTop(BorderStyle.THIN);          //style.setFillForegroundColor(IndexedColors.RED.getIndex());          style.setFillForegroundColor(IndexedColors.RED.getIndex());
          style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
          style.setWrapText(true);          return style;
      }