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.stad...@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.you...@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? > >
