easyExcel使用实例

最新推荐文章于 2025-05-23 23:16:53 发布

Andy-java

最新推荐文章于 2025-05-23 23:16:53 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： java web 文章标签： easyExcel

本文链接：https://blog.youkuaiyun.com/Admire_an/article/details/91362484

java web 专栏收录该内容

10 篇文章

订阅专栏

这篇博客详细介绍了如何使用easyExcel进行数据解析，通过监听器CorporateActionExcelListener实现每一行的数据处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@Resource
private CorporateActionExcelListener excelListener;
    
public void excel() {
        InputStream inputStream;
        try {
            File source = new File("/Users/yaw/Documents/test.xlsx");
            ByteSource byteSource = Files.asByteSource(source);
            inputStream = byteSource.openStream();//用guava的io流操作，不需要使用者关闭流
        } catch (FileNotFoundException e) {
            return;
        }
        Map<String, String> customContent = Maps.newHashMap();
        customContent.put("market", "HK");//传自定义参数到listener
        ExcelReader excelReader = new ExcelReader(inputStream, customContent, excelListener, true);
        List<Sheet> sheets = excelReader.getSheets();
        for (Sheet sheet : sheets) {
            sheet.setHeadLineMun(1);
            if (sheet.getSheetNo() == 1) {
                sheet.setClazz(CapitalEventsExcelModel.class);
            } else if (sheet.getSheetNo() == 2) {
                sheet.setClazz(DividendsExcelModel.class);
            } 
            excelReader.read(sheet);
        }
    }

每一行的解析工作在listener中进行：
CorporateActionExcelListener：

public class CorporateActionExcelListener extends AnalysisEventListener {
    private List<CapitalEvents> capitalEventsList = new ArrayList<>();
    private List<Dividends> dividendsLists = new ArrayList<>();
    
    public void invoke(Object object, AnalysisContext context) {//每一行的数据解析自动调用这里，这里的解析逻辑开发者自己填充
        Integer currentRowNum = context.getCurrentRowNum();
        if (currentRowNum == 0) {
            return;
        }
        try {
            handleObject(object, context);
        } catch (Exception e) {
        }
    }

    private void handleObject(Object object, AnalysisContext context) {
        Map custom = (Map) context.getCustom();
        Object market = custom.get(StockScheduleConstants.marketKeyName);
        int sheetNo = context.getCurrentSheet().getSheetNo();
        switch (sheetNo) {
            case 1:
                CapitalEventsExcelModel capitalEventsExcelModel = (CapitalEventsExcelModel) object;
                CapitalEvents capitalEvents = new CapitalEvents();
                BeanUtils.copyProperties(capitalEventsExcelModel, capitalEvents);
                if (StringUtils.isNotBlank(capitalEvents.getTicker())) {//过滤非法数据
                    capitalEventsList.add(capitalEvents);
                }
                break;
            case 2:
                DividendsExcelModel dividendsExcelModel = (DividendsExcelModel) object;
                Dividends dividends = new Dividends();
                BeanUtils.copyProperties(dividendsExcelModel, dividends);
                if (StringUtils.isNotBlank(dividends.getTicker())) {//过滤非法数据
                    dividendsLists.add(dividends);
                }
                break;
            default:
                break;
        }
    }

    public void doAfterAllAnalysed(AnalysisContext context) {//每个sheet解析完自动调用这里
        Map custom = (Map) context.getCustom();
        Object market = custom.get(StockScheduleConstants.marketKeyName);
        int sheetNo = context.getCurrentSheet().getSheetNo();
        StopWatch stopWatch = new StopWatch();
        stopWatch.start();
        switch (sheetNo) {
            case 1:
                if (CollectionUtils.isEmpty(capitalEventsList)) {
                    return;
                }
                //处理逻辑
                ...
                 break;
            case 2:
                if (CollectionUtils.isEmpty(dividendsLists)) {
                    return;
                }
                 //处理逻辑
                ...
                break;
            default:
                break;
        }

    }
}