XLSX performance

Aspose.Cells Product Family
1

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
2

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.
3

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
4

Hi,


Thanks for providing further details.

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

Thank you.
5

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.

6

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.