POI的常用方法分享

這篇文章主要講解了“POI的常用方法分享”，文中的講解內(nèi)容簡(jiǎn)單清晰，易于學(xué)習(xí)與理解，下面請(qǐng)大家跟著小編的思路慢慢深入，一起來研究和學(xué)習(xí)“POI的常用方法分享”吧！

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

2.         Workbook workbook = new HSSFWorkbook();
   

3.         /*==========獲取常用對(duì)象======begin===========
   

4.         //讀取文件
   

5.         POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("C:/a.xls"));
   

6.         //得到Excel工作簿對(duì)象
   

7.         Workbook workbook = new HSSFWorkbook(fs);
   

8.         //得到工作表對(duì)象
   

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

10.         //得到工作表的行
    

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

12.         //得到指定行的單元格
    

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

14.         //得到單元格樣式
    

15.         CellType cellType = CellType.forInt(cell.getCellType());
    

16.         =========獲取常用對(duì)象=========end===========*/
    

17. 
    

18.         /*=============建立常用對(duì)象=======begin=======
    

19.         //創(chuàng)建工作簿
    

20.         Workbook workbook = new HSSFWorkbook();
    

21.         //創(chuàng)建工作表
    

22.         Sheet sheet= workbook.createSheet("new Sheet");
    

23.         //創(chuàng)建行
    

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

25.         //創(chuàng)建單元格樣式
    

26.         CellStyle cellStyle = workbook.createCellStyle();
    

27.         //在指定行創(chuàng)建指定樣式的單元格
    

28.         row.createCell(0).setCellStyle(cellStyle);
    

29.         //在指定行創(chuàng)建含有指定值的單元格
    

30.         row.createCell(0).setCellValue(1);
    

31.         ===============建立常用對(duì)象=======end========*/
    

32. 
    

33.         /*============設(shè)置sheet名稱和單元格內(nèi)容======begin======
    

34.         Workbook workbook = new HSSFWorkbook();
    

35.         workbook.setSheetName(1, "第一張工作表");
    

36.         Cell cell = workbook.createSheet().createRow(0).createCell(0);
    

37.         cell.setCellValue("單元格內(nèi)容");
    

38.         ============設(shè)置sheet名稱和單元格內(nèi)容=======end======*/
    

39. 
    

40.         /*============取得sheet的數(shù)量========begin====
    

41.         Workbook workbook = new HSSFWorkbook();
    

42.         workbook.getNumberOfSheets();
    

43.         ============取得sheet的數(shù)量========end====*/
    

44. 
    

45.         //根據(jù)index取得sheet對(duì)象
    

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

47.         //取得有效的行數(shù)
    

48.         int count = sheet.getLastRowNum();
    

49.         //取得一行有效的單元格個(gè)數(shù)
    

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

51.         row.getLastCellNum();
    

52.         //單元格類型的讀寫
    

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

54.         cell.setCellType(CellType.STRING);//設(shè)置單元格為String類型
    

55.         cell.getNumericCellValue();//讀取數(shù)值類型的單元格內(nèi)容
    

56. 
    

57.         //設(shè)置列寬 行高
    

58.         sheet.setColumnWidth(100, 100);
    

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

60. 
    

61.         //添加區(qū)域 合并單元格
    

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

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

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

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

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

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

68. 
    

69.         //保存Excel文件
    

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

71.         FileOutputStream fileOutputStream = new FileOutputStream(path);
    

72.         workbook.write(fileOutputStream);
    

73. 
    

74.         //常用單元格邊框格式
    

75.         CellStyle style = workbook.createCellStyle();
    

76.         style.setBorderTop(CellStyle.BORDER_DOTTED);//上邊框
    

77.         style.setBorderBottom(CellStyle.BORDER_DOTTED);//下邊框
    

78.         style.setBorderLeft(CellStyle.BORDER_THIN);//左邊框
    

79.         style.setBorderRight(CellStyle.BORDER_DOTTED);//右邊框
    

80. 
    

81.         //設(shè)置字體
    

82.         Font font = workbook.createFont();
    

83.         font.setFontHeightInPoints((short)11);//設(shè)置字體
    

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

85. 
    

86.         //設(shè)置位置
    

87.         style.setFont(font);
    

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

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

90.         style.setRotation((short)10);//單元格內(nèi)容的旋轉(zhuǎn)的角度
    

91. 
    

92.         //設(shè)置
    

93.         DataFormat dataFormat = workbook.createDataFormat();
    

94.         style.setDataFormat(dataFormat.getFormat("0.00%"));//設(shè)置單元格數(shù)據(jù)格式
    

95.         cell.setCellFormula("");//給單元格設(shè)置公式
    

96. 
    

97.         //插入圖片
    

98.         ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
    

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

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

101. 
     

102.         //自定義顏色
     

103.         Font font1 = workbook.createFont();
     

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

105.         style.setFont(font1);
     

106.         cell.setCellStyle(style);
     

107. 
     

108.     }

點(diǎn)擊(此處)折疊或打開

1. /*=================根據(jù)單元不同屬性返回字符串?dāng)?shù)值========begin============*/
   

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.     /*=================根據(jù)單元不同屬性返回字符串?dāng)?shù)值========end============*/

感謝各位的閱讀，以上就是“POI的常用方法分享”的內(nèi)容了，經(jīng)過本文的學(xué)習(xí)后，相信大家對(duì)POI的常用方法分享這一問題有了更深刻的體會(huì)，具體使用情況還需要大家實(shí)踐驗(yàn)證。這里是億速云，小編將為大家推送更多相關(guān)知識(shí)點(diǎn)的文章，歡迎關(guān)注！