XLSX performance

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

Hi,


Thanks for the sample file and project.

After an initial test, I can notice the issue, it takes more time to read the template file by Aspose.Cells for JAVA than it should. However, if we use a good 64-bit machine with sufficient RAM, it takes little time to load the file though. Anyways, we will check if we could look into it to enhance it a bit. The template files has data, smart arts, shapes and images etc.

I have logged a ticket with an id “CELLSJAVA-40500” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.

The provided file is just a test-file, the actual file which we use is larger, and takes about a factor 4 longer to load. The fact that the sheetN.xml files are read over 20 times is concerning us.


Thanks for looking into this.

Barry

Hi,


Thanks for providing further details.

We will surely take this into account while evaluating your issue to figure it out.

Thank you.

Hi,


Please try the new fix/version: Aspose.Cells for Java v7.4.3.5. We have made an improvement in the performance of reading large XLSX template file with many entries.


Thank you.

The issues you have found earlier (filed as CELLSJAVA-40500) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.