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? > >
