Apache POI - Java Excel 学习笔记二

5、poi-excel的第五个例子，利用CellStyle实现对字体的控制

        Workbook wb=new HSSFWorkbook();
        Sheet sheet = wb.createSheet("第一个sheet页");
        Row row = sheet.createRow(2);
        row.setHeightInPoints(20);
        HSSFFont font=(HSSFFont) wb.createFont();
        font.setColor(HSSFFont.COLOR_RED);
        CellStyle cellStyle = wb.createCellStyle();
        cellStyle.setFont(font);
        Cell cell = row.createCell(0);
        cell.setCellStyle(cellStyle);
        cell.setCellValue("你好啊");
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\my.xls");
        wb.write(fileOutputStream);
        fileOutputStream.close();
        wb.close();
        System.out.println(123);

6、poi-excel的第六个例子，合并单元格

        Workbook wb=new HSSFWorkbook();
        Sheet sheet = wb.createSheet("第一个sheet页");
        Row row = sheet.createRow(1);
        Cell cell = row.createCell(1);
        cell.setCellValue("单元合并测试");
        sheet.addMergedRegion(new CellRangeAddress(
                1,//起始行
                2,//结束行
                1,//起始列
                2//结束列
                ));
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\my.xls");
        wb.write(fileOutputStream);
        fileOutputStream.close();
        wb.close();
        System.out.println(123);

7、poi-excel的第七个例子，利用CellStyle控制字体的样式（二）

        Workbook wb=new HSSFWorkbook();
        Sheet sheet = wb.createSheet("第一个sheet页");
        Row row = sheet.createRow(1);
        Font font = wb.createFont();
        font.setFontHeightInPoints((short) 25);
        font.setFontName("Courier New");
        font.setItalic(true);
        font.setStrikeout(true);
        CellStyle cellStyle = wb.createCellStyle();
        cellStyle.setFont(font);
        Cell cell = row.createCell(1);
        cell.setCellStyle(cellStyle);
        cell.setCellValue("我是王明远");
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\my.xls");
        wb.write(fileOutputStream);
        fileOutputStream.close();
        wb.close();
        System.out.println(123);

8、poi-excel的第八个例子，从excel表中获取数据经过加工导出

        InputStream is=new FileInputStream("C:\\Users\\Administrator\\Desktop\\my.xls");
        POIFSFileSystem fs=new POIFSFileSystem(is);
        Workbook wb=new HSSFWorkbook(fs);
        Sheet sheet = wb.getSheetAt(0);
        Row row = sheet.getRow(0);
        Cell cell = row.getCell(0);
        if(cell==null)
        {
         cell = row.createCell(15);

        }
        cell.setCellType(CellType.STRING);
        cell.setCellValue("测试单元格");
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\my1.xls");
        wb.write(fileOutputStream);
        fileOutputStream.close();
        wb.close();
        System.out.println(123);

9、poi-excel的第九个例子，换行的实现

        Workbook wb=new HSSFWorkbook();
        Sheet sheet = wb.createSheet("第一个sheet页");
        Row row = sheet.createRow(2);
        Cell cell = row.createCell(2);
        cell.setCellValue("我换行\n成功了吗？");
        CellStyle cellStyle=wb.createCellStyle();
        //设置为可以换行
        cellStyle.setWrapText(true);
        cell.setCellStyle(cellStyle);
        //调整下行的高度
        row.setHeightInPoints(2*sheet.getDefaultRowHeightInPoints());
        //调整单元格的宽度
        sheet.autoSizeColumn(2);
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\my1.xls");
        wb.write(fileOutputStream);
        fileOutputStream.close();
        wb.close();
        System.out.println(123);

10、poi-excel的第十个例子，整型格式的控制

        Workbook wb=new HSSFWorkbook();
        Sheet sheet = wb.createSheet("第一个sheet页");
        CellStyle cellStyle;
        DataFormat format=wb.createDataFormat();
        Row row;
        Cell cell;
        short rowNum=0;
        short colNum=0;

        row=sheet.createRow(rowNum++);
        cell=row.createCell(colNum);
        cell.setCellValue(111111.25);
        cellStyle=wb.createCellStyle();
        cellStyle.setDataFormat(format.getFormat("0.0"));
        cell.setCellStyle(cellStyle);
        row=sheet.createRow(rowNum++);
        cell = row.createCell(colNum);
        cell.setCellValue(111111.25);
        cellStyle=wb.createCellStyle();
        cellStyle.setDataFormat(format.getFormat("#,##0.000"));
        cell.setCellStyle(cellStyle);
        FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator\\Desktop\\my1.xls");
        wb.write(fileOutputStream);
        fileOutputStream.close();
        wb.close();
        System.out.println(123);