Java jxl读取Excel数据

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;
    }

}

 

转载于:https://www.cnblogs.com/lihai1020/p/10026743.html