使用 Apache POI读取EXCEL文件

ゞ浴缸里的玫瑰 2022-08-05 05:12 219阅读 0赞

###    添加MAVEN依赖 ###

<table style=""> 
 <tbody style=""> 
  <tr style=""> 
   <td style=""> 
    <div style=""> 
     <div style=""> 
      <code style="">&lt;</code> 
      <code style="">dependency</code> 
      <code style="">&gt;</code> 
     </div> 
     <div style=""> 
      <code style="">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="">&lt;</code> 
      <code style="">groupid</code> 
      <code style="">&gt;org.apache.poi&lt;/</code> 
      <code style="">groupid</code> 
      <code style="">&gt;</code> 
     </div> 
     <div style=""> 
      <code style="">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="">&lt;</code> 
      <code style="">artifactid</code> 
      <code style="">&gt;poi&lt;/</code> 
      <code style="">artifactid</code> 
      <code style="">&gt;</code> 
     </div> 
     <div style=""> 
      <code style="">&nbsp;&nbsp;&nbsp;&nbsp;</code> 
      <code style="">&lt;</code> 
      <code style="">version</code> 
      <code style="">&gt;3.12&lt;/</code> 
      <code style="">version</code> 
      <code style="">&gt;</code> 
     </div> 
     <div style=""> 
      <code style="">&lt;/</code> 
      <code style="">dependency</code> 
      <code style="">&gt;</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

###    读取EXCEL文件 ###

比如：

test.xls  
![java read excel file][]

try {
                 
                FileInputStream file = new FileInputStream(new File("C:\\test.xls"));
                 
                //Get the workbook instance for XLS file 
                HSSFWorkbook workbook = new HSSFWorkbook(file);
     
                //Get first sheet from the workbook
                HSSFSheet sheet = workbook.getSheetAt(0);
                 
                //Iterate through each rows from first sheet
                Iterator<row> rowIterator = sheet.iterator();
                while(rowIterator.hasNext()) {
                    Row row = rowIterator.next();
                     
                    //For each row, iterate through each columns
                    Iterator<cell> cellIterator = row.cellIterator();
                    while(cellIterator.hasNext()) {
                         
                        Cell cell = cellIterator.next();
                         
                        switch(cell.getCellType()) {
                            case Cell.CELL_TYPE_BOOLEAN:
                                System.out.print(cell.getBooleanCellValue() + "\t\t");
                                break;
                            case Cell.CELL_TYPE_NUMERIC:
                                System.out.print(cell.getNumericCellValue() + "\t\t");
                                break;
                            case Cell.CELL_TYPE_STRING:
                                System.out.print(cell.getStringCellValue() + "\t\t");
                                break;
                        }
                    }
                    System.out.println("");
                }
                file.close();
                FileOutputStream out = 
                    new FileOutputStream(new File("C:\\test.xls"));
                workbook.write(out);
                out.close();
                 
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            }
    </cell></row>

输出：

`Emp Id      Name        Salary     `

`1.0     John        2000000.0      `

`2.0     Dean        420000.0       `

`3.0     Sam     280000.0       `

`4.0     Cass        6000000.0  `

[java read excel file]: http://img.viralpatel.net/2012/11/excel-file.png