@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);

    }