poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jörn Franke <jornfra...@gmail.com>
Subject Re: Loading/closing an excel took too much time
Date Mon, 05 Feb 2018 14:45:10 GMT
Load them in parallel ... multiple cores alone will not help you have to create threads of
which each of them loads one or more files (depending on your use case).

BTW your code does not load linked workbooks or evaluated formulas linked to other workbooks.

> On 5. Feb 2018, at 11:05, Chen Young <chin.youyou@outlook.com> wrote:
> 
> I'm using the following code to load and close an existing excel.
> 
> workbook = new XSSFWorkbook(file);
> workbook.close()
> 
> Creating XSSFWorkbook took almost 200ms and closing it took almost 100ms.
> 
> In this excel, there're some formula cells which refer to other excels. Is this the reason
for slowing?
> I have more than 3000 files to deal with. So it's too slow for me.
> Though multiple-thread doubles the speed, I still want to improve more.
> 
> I just want to read contents from these files and won't make any changes to them.
> Is there a workround to improve loading/closing speed?
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message