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.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? > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
