其实各种Excel组件都有可以读取特定sheet的API。
下面是"GcExcel" (https://link.segmentfault.com/?enc=i1%2BjvKtQMzOzsRlwc2o1wg%3D%3D.%2FC%2BB4uI0deZZ9wYlUmcVFUwWyfKw%2FtPXJa%2BLFxPxMFgb6hmPBwrNGL7P1Rc5VUKbz3kpKiYkWS2C52VOHD9yhKftPfnmfQ2zZXp%2FuLUyRxQ%3D)读取特定sheet的代码,可以参考一下:
public void ReadSpecificSheet() {
ArrayList fileList = new ArrayList();
fileList.add("a.xlsx");
fileList.add("b.xlsx");
fileList.add("c.xlsx");
for (String filepath : fileList) {
Workbook wb = new Workbook();
wb.open(filepath);
IWorksheet sheet = wb.getWorksheets().get("SheetName");
//获取到 sheet 对象后,可以添加后续逻辑
}
}