[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    =?gb2312?B?tPC4tDogTG9hZGluZy9jbG9zaW5nIGFuIGV4Y2VsIHRvb2sgdG9vIG11Y2gg?= =?gb2312?Q?time?=
From:       Chen Young <niaomingjian () outlook ! com>
Date:       2018-02-06 1:05:18
Message-ID: TY1PR0301MB1280A11DB972675ED3722FABFEFD0 () TY1PR0301MB1280 ! apcprd03 ! prod ! outlook ! com
[Download RAW message or body]

[Attachment #2 (text/plain)]

Hi,

Thank you for your advice.

I only know that time is spent on workbook = new XSSFWorkbook(file);/workbook.close() \
these two statements. How can I use a profiler  to detect where the time is spent \
more in depth?

Young.
________________________________
·¢¼þÈË: Dominik Stadler <dominik.stadler@gmx.at>
·¢ËÍʱ¼ä: 2018Äê2Ô 5ÈÕ 22:09
ÊÕ¼þÈË: POI Users List
Ö÷Ìâ: Re: Loading/closing an excel took too much time

Hi,

You can take a look at a streaming interface, see e.g.
https://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api, however I
cannot guarantee that it will be much faster than the normal open.

Otherwise your best bet is to use a profiler to see where the time is spent
to see if anything can be improved there.

Dominik.

On Mon, Feb 5, 2018 at 11:05 AM, 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?
> 
> 



[prev in list] [next in list] [prev in thread] [next in thread]