POI的常用方法分享

这篇文章主要讲解了“POI的常用方法分享”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“POI的常用方法分享”吧！

1. public static void main(String[] args) throws ioException {
   

2.         Workbook workbook = new HSSFWorkbook();
   

3.         
   

5.         
   

7.         
   

9.         
   

11.         //根据index取得sheet对象
    

12.         Sheet sheet = workbook.getSheetAt(0);
    

13.         //取得有效的行数
    

14.         int count = sheet.getLastRowNum();
    

15.         //取得一行有效的单元格个数
    

16.         Row row = sheet.getRow(0);
    

17.         row.getLastCellNum();
    

18.         //单元格类型的读写
    

19.         Cell cell = row.getCell(0);
    

20.         cell.setCellType(CellType.STRING);//设置单元格为String类型
    

21.         cell.getNumericCellValue();//读取数值类型的单元格内容
    

23.         //设置列宽 行高
    

24.         sheet.setColumnWidth(100, 100);
    

25.         row.setHeight((short)100);
    

27.         //添加区域 合并单元格
    

28.         sheet.addMergedRegion(new CellRangeAddress(0,3,0,0));
    

29.         Row row1 = sheet.createRow(0);
    

30.         row1.createCell(0).setCellValue("0");
    

31.         row1.createCell(1).setCellValue("1");
    

32.         row1.createCell(2).setCellValue("2");
    

33.         row1.createCell(3).setCellValue("3");
    

35.         //保存excel文件
    

36.         String path = "C:/a.xls";
    

37.         FileOutputStream fileOutputStream = new FileOutputStream(path);
    

38.         workbook.write(fileOutputStream);
    

40.         //常用单元格边框格式
    

41.         CellStyle style = workbook.createCellStyle();
    

42.         style.setBorderTop(CellStyle.BORDER_DOTTED);//上边框
    

43.         style.setBorderBottom(CellStyle.BORDER_DOTTED);//下边框
    

44.         style.setBorderLeft(CellStyle.BORDER_THIN);//左边框
    

45.         style.setBorderRight(CellStyle.BORDER_DOTTED);//右边框
    

47.         //设置字体
    

48.         Font font = workbook.createFont();
    

49.         font.setFontHeightInPoints((short)11);//设置字体
    

50.         font.setBoldweight(Font.BOLDWEIGHT_NORMAL);//加粗
    

52.         //设置位置
    

53.         style.setFont(font);
    

54.         style.setAlignment(CellStyle.ALIGN_CENTER);//左右居中
    

55.         style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);//上下居中
    

56.         style.setRotation((short)10);//单元格内容的旋转的角度
    

58.         //设置
    

59.         DataFormat dataFormat = workbook.createDataFormat();
    

60.         style.setDataFormat(dataFormat.getFormat("0.00%"));//设置单元格数据格式
    

61.         cell.setCellFormula("");//给单元格设置公式
    

63.         //插入图片
    

64.         ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
    

65.         BufferedImage bufferedImage = ImageIO.read(new File("a.jpg"));
    

66.         ImageIO.write(bufferedImage, "jpg", byteArrayOutputStream);
    

68.         //自定义颜色
    

69.         Font font1 = workbook.createFont();
    

70.         font1.setColor(HSSFColor.RED.index);
    

71.         style.setFont(font1);
    

72.         cell.setCellStyle(style);
    

74.     }

点击(此处)折叠或打开

1. 
   

2.     public String getCellStringValue(Cell cell){
   

3.         String cellValue = "";
   

4.         switch (CellType.forInt(cell.getCellType())){
   

5.             case _NONE:
   

6.                 break;
   

7.             case NUMERIC:
   

8.                 cellValue = String.valueOf(cell.getNumericCellValue());
   

9.                 break;
   

10.             case STRING:
    

11.                 cellValue = cell.getStrinGCellValue();
    

12.                 if (cellValue.trim().equals("") || cellValue.trim().length() <= 0){
    

13.                     cellValue = "";
    

14.                 }
    

15.                 break;
    

16.             case FORMULA:
    

17.                 cell.setCellType(CellType.NUMERIC);
    

18.                 cellValue = String.valueOf(cell.getNumericCellValue());
    

19.                 break;
    

20.             case BLANK:
    

21.                 cellValue = "";
    

22.                 break;
    

23.             case BOOLEAN:
    

24.                 break;
    

25.             case ERROR:
    

26.                 break;
    

27.         }
    

28.         return cellValue;
    

29.     }
    

30.     

感谢各位的阅读，以上就是“POI的常用方法分享”的内容了，经过本文的学习后，相信大家对POI的常用方法分享这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是编程网，小编将为大家推送更多相关知识点的文章，欢迎关注！