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
发送时间: 2018年2月5日 22
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?
; Sheet sheet = wb.getSheetAt(0);
> > >
> > > System.out.println(sheet.getRow(0).getCell(0).getCellType());
> > > System.out.println(sheet.getRow(1).getCell(0).getCellType());
> > >
> > > wb.close();
> > > ===
ferent.
In addition, in this excel, the appearance of these two cells are also
different.
There is a green triangle at the top-right corner of A2.
Could anyone explain this for me?
Thanks,
Young
-
To unsubscribe, e-mail: user-u