POI----基本操作DOME

public class ExcelTest {
    private String excelPath;

    private String data[];

    @Before
    public void setUp(){
        data = new String[10];
        for(int i = 0; i < data.length; i++){
            data[i] = "数据："+ i;
        }
    }


    /**
     * 第一个
     * @throws Exception
     */
    @Test
    public void testPOI1() throws Exception {
        Workbook workbook03 = new HSSFWorkbook();
        Workbook workbook07 = new XSSFWorkbook();//poi-ooxml-schemas-xx.jar

        Sheet sheet = workbook03.createSheet("第一个Sheet");
        int rowNum = 0;
        for(int i = 0; i < data.length; i++){
            Row row = sheet.createRow(rowNum++);
            Cell cell = row.createCell(0);
            cell.setCellValue(data[i]);
        }

        FileOutputStream os = new FileOutputStream("/test.xls");
        workbook03.write(os);

    }

    /**
     * 合并单元格
     * @throws Exception
     */
    @Test
    public void testPOI2() throws Exception {
        Workbook workbook03 = new HSSFWorkbook();
        Workbook workbook07 = new XSSFWorkbook();//poi-ooxml-schemas-xx.jar

        Sheet sheet = workbook03.createSheet("第2个Sheet");
        /*
            sheet.addMergedRegion(new Region(0,(short)0,0,(short)2));
            CellRangeAddress(rowFrom, rowTo, colFrom, colTo)
        */

        //合并0到10列，等于10
        sheet.addMergedRegion(new CellRangeAddress(0, 0, 0 , 10));
        //合并1到10行，等于10
        sheet.addMergedRegion(new CellRangeAddress(1, 10, 0, 0));


        CellStyle style = workbook03.createCellStyle();
        //设置背景色
        //style.setFillBackgroundColor(IndexedColors.RED.getIndex());  //填充背景颜色
        style.setFillForegroundColor(IndexedColors.GREEN.getIndex());
        style.setFillPattern(CellStyle.SOLID_FOREGROUND);       //设置一个cell的前景颜色样式,块填充
        style.setWrapText(true);


        //设置字体颜色
        Font font = workbook03.createFont();
        font.setColor(IndexedColors.RED.getIndex());
        style.setFont(font);

        Row row = sheet.createRow(1);
        Cell cell = row.createCell(0);
        cell.setCellStyle(style);
        cell.setCellValue("feifei--feifeifeifeifeifei菲菲");


        FileOutputStream os = new FileOutputStream("/test.xls");
        workbook03.write(os);

    }


}