前提:引入jxl-2.6.jar
import cn.waner.resolverule.demol.ResolveRule;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import java.io.*;
import java.util.ArrayList;
import java.util.List;
public class GetExcelInfo {
public static void main(String[] args){
GetExcelInfo obj = new GetExcelInfo();
// 此处为我创建Excel路径:E:\b.xls下
File file = new File("E:\\b.xls");
List<ResolveRule> resolveRuleList = obj.readExcel(file);
}
// 去读Excel的方法readExcel,该方法的入口参数为一个File对象
public List<ResolveRule> readExcel(File file) {
List<ResolveRule> assetIdentifierList = new ArrayList<>();
try {
// 创建输入流,读取Excel
InputStream is = new FileInputStream(file.getAbsolutePath());
// jxl提供的Workbook类
Workbook wb = Workbook.getWorkbook(is);
// Excel的页签数量
int sheet_size = wb.getNumberOfSheets();
for (int index = 0; index < sheet_size; index++) {
ResolveRule resolveRule = new ResolveRule();
// 每个页签创建一个Sheet对象
Sheet sheet = wb.getSheet(index);
// sheet.getRows()返回该页的总行数
for (int i = 1; i < sheet.getRows(); i++) {
// sheet.getColumns()返回该页的总列数
for (int j = 0; j < sheet.getColumns(); j++) {
var cellinfo = sheet.getCell(j, i).getContents();
System.out.println(cellinfo);
}
}
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return assetIdentifierList;
}
}