使用java poi解析表格

   @Test
    public void poi() throws Exception {
        InputStream inputStream=new FileInputStream("C:\\Users\\Administrator.SKY-20170602BKZ\\Desktop\\111.xlsx");
        //整个excel文件
        XSSFWorkbook xssfSheets = new XSSFWorkbook(inputStream);
        //每行的数据存一个list,然后每页的数据存到一个list
        List<List<String>> result=new ArrayList<List<String>>();
        //遍历XSSFWorkbook是否有多个sheet
        for (XSSFSheet xss:xssfSheets){
            //如果当前sheet为空则开始下一次循环
            if (xss==null)
                continue;
            //循环当前页 获取每一行
            for (int rowNum=1;rowNum<=xss.getLastRowNum();rowNum++){
                ArrayList<String> rowlist= new ArrayList<String>();
                XSSFRow row = xss.getRow(rowNum);
                short firstCellNum = row.getFirstCellNum();
                short lastCellNum = row.getLastCellNum();
                //获取每一个单元格
                Iterator<Cell> cellIterator = row.cellIterator();
                while (cellIterator.hasNext()){
                    Cell next = cellIterator.next();
                    next.setCellType(Cell.CELL_TYPE_STRING);
                    rowlist.add(next.getStringCellValue());
                }
                result.add(rowlist);
            }


        }
        System.out.println(result);




    }