poi读取excel数据

依赖包

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

示例

    public void test() {
        try {
            System.out.println("==================" + jdbcTemplate);
            String path = "C:\\Users\\xxx\\Desktop\\基线\\xxxx.xlsx";
            XSSFWorkbook wb = new XSSFWorkbook(new File(path));
            XSSFSheet sheet = wb.getSheetAt(0);
            int rowNum = sheet.getLastRowNum();//获取总行数,获取的是最后一行的编号（编号从0开始）
            int cellMaxNum = sheet.getRow(0).getLastCellNum();//是获取最后一个不为空的列是第几个。
            for (int i = 0; i <= rowNum; i++) {
                XSSFRow row = sheet.getRow(i);
                for (int j = 0; j < cellMaxNum; j++) {
                    String stringCellValue = row.getCell(j).getStringCellValue();
                    System.out.print(stringCellValue + " ");
                }
                System.out.println();
            }
        } catch (Exception e) {
            log.error(e.getMessage(), e);
        }
    }