java讀寫excel 需要引入一下jar包

compile group: 'org.apache.poi', name: 'poi-ooxml', version: '4.0.1'
compile group: 'org.apache.poi', name: 'poi', version: '4.0.1'

讀取excel表格

 Workbook workbook= WorkbookFactory.create(new FileInputStream("C:\\Users\\Administrator\\Desktop\\新建 XLSX 工作表.xlsx"));
    for(int i=0;i<workbook.getNumberOfSheets();i++){ 
        //getNumberOfSheets()獲取sheet的數(shù)量
        Sheet hssfSheet=workbook.getSheetAt(i);
        if(hssfSheet.getPhysicalNumberOfRows()==0){
            //getPhysicalNumberOfRows獲取有效的行總數(shù)空行不算
            continue;
        }
        Row headRow=hssfSheet.getRow(hssfSheet.getFirstRowNum());
        //表頭必填所有數(shù)據(jù)以表頭為準(zhǔn)getFirstRowNum()獲取有數(shù)據(jù)的行號(hào)有可能數(shù)據(jù)從第2行開始
        for(int row=hssfSheet.getFirstRowNum();row<=hssfSheet.getLastRowNum();row++){
            // getLastRowNum為最后一行的下標(biāo) 
            Row rowData=hssfSheet.getRow(row);
            if(rowData!=null) {
                if(rowData.getPhysicalNumberOfCells()==0){
                    continue;
                     }
                for (int cell = headRow.getFirstCellNum(); cell < headRow.getLastCellNum(); cell++) {
                    //以表頭的列數(shù)為準(zhǔn)，超出表頭的數(shù)據(jù)忽略，具體表具體分析這里采用標(biāo)準(zhǔn) getLastCellNum 最后該行該列的下標(biāo)+1
                    Cell cellData = rowData.getCell(cell);
                    if (cellData == null) {
                        //這里以表頭的的下標(biāo)來(lái)取值有可能 該行該列沒有值
                        continue;
                    }
                    CellType cellType=cellData.getCellType();
                    if(cellType.compareTo(CellType.NUMERIC)==0){
                        if(HSSFDateUtil.isCellDateFormatted(cellData)){
                            //判斷是否是時(shí)間
                            System.out.print(cellData.getDateCellValue() + " "); 
                        }else{
                            double doubleValue=cellData.getNumericCellValue();
                            long longValue=(long)doubleValue;
                            if(longValue==doubleValue){
                                System.out.print(longValue + " ");  
                                //去除后面小數(shù)點(diǎn)0
                            }else{
                                System.out.print(doubleValue);
                            }
                        }

                    }else if(cellType.compareTo(CellType.STRING)==0){
                        System.out.print(cellData.getStringCellValue() + " ");  
                    }else if(cellType.compareTo(CellType.BOOLEAN)==0){
                        System.out.print(cellData.getBooleanCellValue());
                    }else if(cellType.compareTo(CellType.FORMULA)==0){
                    }else {

                    }



                }
                System.out.println("");

            }
  
        }

excel源文件

執(zhí)行結(jié)果