1.需要引入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; }
}