java学习-批量查看多个文件夹下多个xls格式的excel文件

windows下目录展示执行命令：dir /B/S

E:\rs\2017
E:\rs\2018
E:\rs\2019
E:\rs\2017\已支付_201701.xls
E:\rs\2017\已支付_201702.xls
E:\rs\2017\已支付_201703.xls
E:\rs\2017\已支付_201704.xls
E:\rs\2017\已支付_201705.xls
E:\rs\2017\已支付_201706.xls
E:\rs\2017\已支付_201707.xls
E:\rs\2017\已支付_201708.xls
E:\rs\2017\已支付_201709.xls
E:\rs\2017\已支付_201710.xls
E:\rs\2017\已支付_201711.xls
E:\rs\2017\已支付_201712.xls
E:\rs\2018\已支付_201801.xls
E:\rs\2018\已支付_201802.xls
E:\rs\2018\已支付_201803.xls
E:\rs\2018\已支付_201804.xls
E:\rs\2018\已支付_201805.xls
E:\rs\2019\已支付_201901.xls
E:\rs\2019\已支付_201902.xls
E:\rs\2019\已支付_201903.xls
E:\rs\2019\已支付_201904.xls
E:\rs\2019\已支付_201905.xls
E:\rs\2019\已支付_201906.xls

对应pom.xml文件：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>project03</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>
    <dependencies>
        <!--核心jar包-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.17</version>
        </dependency>
        <!--支持xlsx读取-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml-schemas</artifactId>
            <version>3.17</version>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.6</version>
        </dependency>
    </dependencies>

</project>

执行的java语句

package excel;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.File;
import java.io.IOException;
import java.util.List;

import org.apache.commons.io.FileUtils;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.sl.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

//使用POI获取excel的行数和列数
public class Test2 {
    public static void main(String[] args) throws IOException {
        int suma=0;
        List<String>  msgs=FileUtils.readLines(new File("E:\\bbb.txt"),"utf-8");
        for (String string : msgs) {
            //System.out.println(string);
            try {
                FileInputStream fis = new FileInputStream(string);
                //XSSFWorkbook workbook =  new XSSFWorkbook(fis);
                HSSFWorkbook workbook = new HSSFWorkbook(fis);
                HSSFSheet sheet = workbook.getSheetAt(0);
               // int firstRowNum = sheet.getFirstRowNum();
                int lastRowNum = sheet.getLastRowNum();
                suma=lastRowNum+suma;
                //Row firstRow = sheet.getRow(firstRowNum);
                //int firstCellNum = firstRow.getFirstCellNum();
               // int lastCellNum = firstRow.getLastCellNum();
                //System.out.println("第一行行号：" + firstRowNum);
                System.out.println(suma+","+lastRowNum+","+string );
                //System.out.println("第一列列号：" + firstCellNum);
                //System.out.println("最后一列列号：" + lastCellNum);

            } catch (FileNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }



    }
}

执行结果：
每个excel记录数相加结果，每个excel记录数，文件路径名称

2818,2818,E:\rs\已支付_201704.xls
5702,2884,E:\rs\已支付_201705.xls
8639,2937,E:\rs\已支付_201706.xls
11565,2926,E:\rs\已支付_201707.xls
14485,2920,E:\rs\已支付_201708.xls
17424,2939,E:\rs\已支付_201709.xls
20370,2946,E:\rs\已支付_201710.xls
23310,2940,E:\rs\已支付_201711.xls
26269,2959,E:\rs\已支付_201712.xls
29174,2905,E:\rs\已支付_201801.xls
32282,3108,E:\rs\已支付_201802.xls
35756,3474,E:\rs\已支付_201803.xls
39180,3424,E:\rs\已支付_201804.xls
42571,3391,E:\rs\已支付_201805.xls
45910,3339,E:\rs\已支付_201806.xls
49184,3274,E:\rs\已支付_201807.xls
52442,3258,E:\rs\已支付_201808.xls
55688,3246,E:\rs\已支付_201809.xls
58895,3207,E:\rs\已支付_201810.xls
62057,3162,E:\rs\已支付_201811.xls
65237,3180,E:\rs\已支付_201812.xls
68541,3304,E:\rs\已支付_201901.xls
71969,3428,E:\rs\已支付_201902.xls
75310,3341,E:\rs\已支付_201903.xls
78649,3339,E:\rs\已支付_201904.xls
81953,3304,E:\rs\已支付_201905.xls
85238,3285,E:\rs\已支付_201906.xls
88617,3379,E:\rs\已支付_201907.xls
91984,3367,E:\rs\已支付_201908.xls
95342,3358,E:\rs\已支付_201909.xls
98962,3620,E:\rs\已支付_201910.xls
102909,3947,E:\rs\已支付_201911.xls
106863,3954,E:\rs\已支付_201912.xls