alibaba/easyexcel

读取大文件耗时很久

Open

#4.041 aberto em 31 de out. de 2024

Ver no GitHub
 (4 comments) (0 reactions) (0 assignees)Java (7.599 forks)batch import
help wanted

Métricas do repositório

Stars
 (33.728 stars)
Métricas de merge de PR
 (Nenhuma PRs mesclada em 30d)

Description

建议先去看文档

快速开始常见问题

异常代码

EasyExcel.read(file, new ReadListener() {
  @Override
  public void invoke(Object data, AnalysisContext context) {
	  System.out.println(data);
	  throw new ExcelAnalysisStopException();
  }
  
  @Override
  public void doAfterAllAnalysed(AnalysisContext context) {
  
  }
}).sheet().doRead();

异常提示

问题描述

就这段代码,读取一个160MB的xlsx,100W行、48列,耗时40秒。我只想读取第一行然后就结束读取,这耗时让我怀疑我是不是用错方式了

Guia do colaborador