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