Java--Excel--poi 边框、单元格换行、 背景色、合并单元格相关

import com.google.common.collect.Maps;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.*;

import java.io.File;
import java.io.FileOutputStream;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

public class programTestmmm {
    static final float PIXEL = 30.2f;
    static Map<Byte, Short> headerWidth = Maps.newHashMap();
    static {
        headerWidth.put((byte)0, (short)(PIXEL * 50));
        headerWidth.put((byte)1, (short)(PIXEL * 50));
        headerWidth.put((byte)2, (short)(PIXEL * 50));
        headerWidth.put((byte)3, (short)(PIXEL * 50));
        headerWidth.put((byte)4, (short)(PIXEL * 150));
        headerWidth.put((byte)5, (short)(PIXEL * 150));
        headerWidth.put((byte)6, (short)(PIXEL * 130));
        headerWidth.put((byte)7, (short)(PIXEL * 130));
        headerWidth.put((byte)8, (short)(PIXEL * 130));
    }

    public static void createHeader4Excel(Workbook wb, Sheet sheet, String number) {
        Row row = sheet.createRow((short)0);
        row.setHeight((short)512);
        String numStr = "newline
（II：" + number + "）";
        String[] headers = { "序号", "AA", "BB", "CC", "DD", numStr, "EE", "FF", "GG" };
        createHeader(wb, sheet, row, headers);

        for( int i = 0; i < headers.length; i++ )
            sheet.setColumnWidth((short)i, (short) headerWidth.get(Byte.valueOf((byte) i)));
    }

    private static void createHeader(Workbook wb, Sheet sheet, Row row, String[] headers) {
        for( int i = 0; i < headers.length; i++ ){
            Cell cell = row.createCell(i);
            CellStyle cellStyle = wb.createCellStyle();
            cellStyle.setAlignment(CellStyle.ALIGN_CENTER);//左右居中
            cellStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);//上下居中
            cellStyle.setWrapText(true);//先设置为自动换行

            //设置边框
            cellStyle.setBorderBottom(CellStyle.BORDER_THIN); // 底部边框
            cellStyle.setBorderLeft(CellStyle.BORDER_THIN);  // 左边边框
            cellStyle.setBorderRight(CellStyle.BORDER_THIN); // 右边边框
            cellStyle.setBorderTop(CellStyle.BORDER_MEDIUM_DASHED); // 上边边框

            //背景色
            cellStyle.setFillForegroundColor(IndexedColors.GREY_40_PERCENT.index);
            cellStyle.setFillBackgroundColor(IndexedColors.GREY_40_PERCENT.index);
            cellStyle.setFillPattern(CellStyle.FINE_DOTS);

            cell.setCellStyle(cellStyle);
            cell.setCellValue(headers[i]);

            if(i == 5)
                cell.setCellValue(new HSSFRichTextString(headers[i]));
        }
    }

    private static void fillRecords(Workbook wb, Sheet sheet, List<String> records) {
        for( int i = 0; i < records.size(); i++ ){
            Row row = sheet.createRow((short)i+1);

            setCellValue( wb, row.createCell(0), records.get(i));
            setCellValue( wb, row.createCell(1), records.get(i) );
            setCellValue( wb, row.createCell(2), records.get(i) );
            setCellValue( wb, row.createCell(3), records.get(i));
            setCellValue( wb, row.createCell(4), records.get(i) );
            setCellValue( wb, row.createCell(5), records.get(i) );
        }
    }

    // Excel最多支持4000个style
    private static void setCellValue( Workbook wb, Cell cell, String value ){
        //CellStyle cellStyle = wb.createCellStyle();
        //cell.setCellStyle(cellStyle);
        cell.setCellValue(value);
        cell.setCellType(Cell.CELL_TYPE_STRING);
    }

    public static void main(String[] args) {
        File file = new File("C://Documents//createExcel.xls");
        OutputStream os = null;
        try {
            os = new FileOutputStream(file, true);
            Workbook wb = new HSSFWorkbook();
            Sheet sheet = wb.createSheet();

            //合并单元格，参数说明：1：开始行 2：结束行  3：开始列 4：结束列
//            sheet.addMergedRegion(new CellRangeAddress(0,0,2,3));

            createHeader4Excel( wb, sheet, "150" );

            List<String> records = new ArrayList<String>();
            records.add("11");
            records.add("22");
            records.add("33");
            records.add("44");
            records.add("55");
            records.add("66");
            fillRecords( wb, sheet, records );
　　　　　　　wb.setSheetName(0, "first sheet");//设置sheet名字
            wb.write(os);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}