2019.03.25日记，poi工具类的封装，以及数据同步方式

先上原码

//创建HSSFWorkbook对象
        HSSFWorkbook wb = new HSSFWorkbook();
        //创建HSSFSheet对象
        HSSFSheet sheet = wb.createSheet("sheet0");

        //创建样式
        HSSFCellStyle cellStyleFont=wb.createCellStyle();
        //文字居中
        cellStyleFont.setAlignment(HorizontalAlignment.CENTER);
        //背景色
        cellStyleFont.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        cellStyleFont.setFillForegroundColor(HSSFColor.LIGHT_ORANGE.index);
        cellStyleFont.setBorderBottom(BorderStyle.THIN);
        cellStyleFont.setBorderLeft(BorderStyle.THIN);
        cellStyleFont.setBorderRight(BorderStyle.THIN);
        cellStyleFont.setBorderTop(BorderStyle.THIN);
        HSSFCellStyle cellStyle=wb.createCellStyle();
        cellStyle.setBorderBottom(BorderStyle.THIN);
        cellStyle.setBorderLeft(BorderStyle.THIN);
        cellStyle.setBorderRight(BorderStyle.THIN);
        cellStyle.setBorderTop(BorderStyle.THIN);
        //文字居中
        cellStyle.setAlignment(HorizontalAlignment.CENTER);
//        cellStyleFont.getFont(wb).setBold(true);
        HSSFFont font =  wb.createFont();
        font.setBold(true);
        cellStyleFont.setFont(font);

        HSSFCellStyle cellStyleFontTemp =wb.createCellStyle();

        //第一行
        HSSFRow row0 = sheet.createRow(0);

        row0.createCell(0).setCellValue("表1");
        HSSFCell row0cell1 =  row0.createCell(1);
        row0cell1.setCellValue("借款信息");
        row0cell1.setCellStyle(cellStyleFont);
        //合并单元格
        CellRangeAddress CellRangeAddress1 = new CellRangeAddress(0,0,1,13);
        sheet.addMergedRegion(CellRangeAddress1);
        RegionUtil.setBorderBottom(1, CellRangeAddress1, sheet);
        RegionUtil.setBorderLeft(1, CellRangeAddress1, sheet);
        RegionUtil.setBorderRight(1, CellRangeAddress1, sheet);
        RegionUtil.setBorderTop(1, CellRangeAddress1, sheet);

        //第二行
        HSSFRow row1 = sheet.createRow(1);
        HSSFCell row1cell1 = row1.createCell(1);
        row1cell1.setCellValue("借款利率及费率/年");
        row1cell1.setCellStyle(cellStyle);
        CellRangeAddress CellRangeAddress2 = new CellRangeAddress(1,1,1,8);
        sheet.addMergedRegion(CellRangeAddress2);
        RegionUtil.setBorderBottom(1, CellRangeAddress2, sheet);
        RegionUtil.setBorderLeft(1, CellRangeAddress2, sheet);
        RegionUtil.setBorderRight(1, CellRangeAddress2, sheet);
        RegionUtil.setBorderTop(1, CellRangeAddress2, sheet);

        HSSFCell row1cell9 = row1.createCell(9);
        row1cell9.setCellValue("逾期费率/天");
        row1cell9.setCellStyle(cellStyle);
        CellRangeAddress CellRangeAddress3 = new CellRangeAddress(1,1,9,11);
        sheet.