java使用poi读取excel

在pom.xml文件中引入

    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>4.0.1</version>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>4.0.1</version>
    </dependency>

主函数

 public static void main(String[] args) {
        try{
            readExcel();
        }catch(Exception e){
            e.getMessage();
        }
    }
    public static void readExcel()throws Exception{
        //创建一个文件对象
        String dirName="D:/test/student.xls";
        //创建文件对象
        File file=new File(dirName);
        //从硬盘中把文件读取到内存中，用FileInputStream
        FileInputStream fileInputStream = new FileInputStream(file);
        HSSFWorkbook workbook=new HSSFWorkbook(fileInputStream);
        HSSFSheet sheet=null;
        //获取每个sheet表
        for(int i=0;i<workbook.getNumberOfSheets();i++){
            sheet=workbook.getSheetAt(i);
            //获取每行
            for(int j=0;j<sheet.getPhysicalNumberOfRows();j++){
                HSSFRow row = sheet.getRow(j);
                //获取单元格
                for(int k=0;k<row.getPhysicalNumberOfCells();k++){
                    System.out.println(row.getCell(k)+"\t");
                }
            }
                System.out.println("sheet表"+i+"处理完毕");
        }
    }