OOM while convert xls to xlsx

Aspose.Cells Product Family
1

While converting a xls file to xlsx, i met a oom error. I found the problem is about charts, and it happened during saving workbook as xlsx file. Here is the trace stack:
Exception in thread “main” java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Arrays.java:3181)
at java.util.ArrayList.grow(ArrayList.java:265)
at java.util.ArrayList.ensureExplicitCapacity(ArrayList.java:239)
at java.util.ArrayList.ensureCapacityInternal(ArrayList.java:231)
at java.util.ArrayList.add(ArrayList.java:462)
at com.aspose.cells.b.a.a.g17.a(Unknown Source)
at com.aspose.cells.d69.c(Unknown Source)
at com.aspose.cells.d69.a(Unknown Source)
at com.aspose.cells.d69.a(Unknown Source)
at com.aspose.cells.d69.a(Unknown Source)
at com.aspose.cells.d69.b(Unknown Source)
at com.aspose.cells.u71.ao(Unknown Source)
at com.aspose.cells.a82.a(Unknown Source)
at com.aspose.cells.h9e.a(Unknown Source)
at com.aspose.cells.h9e.a(Unknown Source)
at com.aspose.cells.Chart.a(Unknown Source)
at com.aspose.cells.h9.a(Unknown Source)
at com.aspose.cells.h9.g(Unknown Source)
at com.aspose.cells.h9.a(Unknown Source)
at com.aspose.cells.b2d.a(Unknown Source)
at com.aspose.cells.g17.a(Unknown Source)
at com.aspose.cells.g17.d(Unknown Source)
at com.aspose.cells.g17.a_(Unknown Source)
at com.aspose.cells.z0z.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)

2

@wanghq09,

Thanks for the stack trace.

We need your template Excel file to evaluate your issue. Please zip and attach your input XLS file. We will check your issue soon.

3

iAEIAqRmaWx1.xls.zip (44.2 KB)
Thanks for reply, here is the xls file.

4

By the way, could the setMemorySetting setMemorySetting option work for loading xls file?

5

@wanghq09
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45451

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

6

@wanghq09,
Your sample file is not a big data file. It is caused by the bug itself, so setting the memory mode still causes exceptions to occur. We have created a new ticket and will fix it soon. Once there are updates, we will notify you promptly.

7

Hi @wanghq09
This bug will be fixed in Aspose.Cells 23.6.
After fixing the problem, the generated xlsx file is as follows:
output.zip (78.1 KB)

8

The issues you have found earlier (filed as CELLSJAVA-45451) have been fixed in Aspose.Cells for Java 23.6.

9

It works! Thanks a lot.

10

@wanghq09,
You are welcome.