Pivot Table Memory Error

Aspose.Cells Product Family
1

Error: Error running instance method\njava.lang.OutOfMemoryError: Java heap space\n\tat com.aspose.cells.u2x.a(Unknown Source)\n\tat com.aspose.cells.Row.a(Unknown Source)\n\tat com.aspose.cells.Row.a(Unknown Source)\n\tat com.aspose.cells.RowCollection.a(Unknown Source)\n\tat com.aspose.cells.Cells.a(Unknown Source)\n\tat com.aspose.cells.m3n.d(Unknown Source)\n\tat com.aspose.cells.m3n.f(Unknown Source)\n\tat com.aspose.cells.m3n.a(Unknown Source)\n\tat com.aspose.cells.PivotTable.calculateData(Unknown Source)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)\n\tat java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.base/java.lang.reflect.Method.invoke(Method.java:569)\n\tat node.MethodCallBaton.invokeMethod9(MethodCallBaton.java:25)\n "

pivotTable.calculateData();
return workBook;

How to resolve ?

2

@vinaybabu,

Thanks for the error trace.

Could you please share your sample Java program or any runnable code along with template Excel files (please zip the files prior attaching here). This will help us reproduce the issue on our end, and we’ll look into it promptly.

3

Hi, I ve added all the files, the atached csv is loaded into aspose workbook
aspose.zip (364.1 KB)

Let me know if any additional information needed

4

@vinaybabu
What version are you using? Is it Aspose.Cells for Node.js via Java version? Also, would you like to provide complete and executable test code? We will check it soon.