Hi,
We have a performance issue with Aspose.Cells for Java: when opening an XLSX file, just opening the workbook takes a very long time in case the XLSX file is quite big.
After investigation, it turned out that Aspose is reading the ZIP structure a lot of times:
Below is a list per file in the ZIP, and how many times this file is read:
Total time (ms): 14237
29 times: [Content_Types].xml
28 times: _rels/.rels
27 times: xl/diagrams/drawing3.xml
26 times: xl/charts/chart6.xml
23 times: xl/charts/chart5.xml
20 times: xl/worksheets/sheet1.xml
19 times: xl/worksheets/_rels/sheet3.xml.rels
18 times: xl/diagrams/drawing2.xml
17 times: xl/charts/chart2.xml
14 times: xl/charts/chart1.xml
11 times: xl/drawings/drawing1.xml
10 times: xl/worksheets/sheet4.xml
9 times: xl/charts/chart4.xml
6 times: xl/drawings/drawing2.xml
5 times: xl/charts/chart3.xml
2 times: xl/pivotCache/pivotCacheDefinition1.xml
1 times: STZhongsong_Bold, Italic.diff
0 times: KaiTi_Regular.diff
I’ve attached a sample project (including test.xlsx) to reproduce the issue.
In our case, we just need to open a XLSX file to verify that certain sheetnames are present. This is currently taking a lot of time.
Is there anything we can do to improve this ?
Thanks,
Barry Lagerweij