Hi Peng,
Thanks for your posting and using Aspose.Cells.
Actually, there is some issue of Aspose.Cells with your provided XLSB file. We have therefore logged an issue relating to it. Please spare us some time and let us investigate and fix this issue. Once, the issue is resolved, you will be able to run your code and get the string from your xlsb file.
Hi team,
Hi Peng,
Thanks for providing the new file and using Aspose.Cells.
XLSB2007TestNewS.xlsb does not load and keeps increasing memory consumption. We have tested this issue with the following sample code using the latest version: Aspose.Cells for Java 8.3.1.
We have also logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSJAVA-41134 - XLSB2007TestNewS.xlsb does not load and keeps increasing memory consumption.
Java
String filePath = “F:\Shak-Data-RW\Downloads\XLSB2007TestNewS.xlsb”;
Workbook workbook = new Workbook(filePath);
System.out.println(“loaded”);
Hi team,
Hi,
Thanks for using Aspose.Cells for Java.
We have fixed this issue.
- CELLSJAVA-41134 - XLSB2007TestNewS.xlsb does not load and keeps increasing memory consumption
Please download and try this fix: Aspose.Cells for Java v8.3.1.1 and let us know your feedback.
Hi team,
java.lang.OutOfMemoryError: Java heap space
at com.aspose.cells.zbpx.a(Unknown Source)
at com.aspose.cells.zbpx.b(Unknown Source)
at com.aspose.cells.zbpx.a(Unknown Source)
at com.aspose.cells.zbpx.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)
at _jsp._test._test__jsp._jspService(_test__jsp.java:209)
at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
at com.caucho.jsp.Page.pageservice(Page.java:570)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:179)
at com.nineder.web.filter.MDCInsertingServletFilter.doFilter(MDCInsertingServletFilter.java:43)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:514)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
at java.lang.Thread.run(Thread.java:662)
thank you
Hi Peng,
Thanks for your feedback and using Aspose.Cells.
You are right. We were able to generate this exception with the latest version 8.3.1.1.We have reopened this issue CELLSJAVA-41134 and logged your comments against it.
Hi Peng,
Thanks for using Aspose.Cells.
Please use memory preference as used in the the following code to get rid of the out of memory error.
Java
String filePath = “F:\Shak-Data-RW\Downloads\”;
LoadOptions options = new LoadOptions();
options.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);
Workbook workbook = new Workbook(filePath + “XLSB2007TestNewS.xlsb”,
options);
workbook.save(filePath + “out_java.xlsb”);
Also let us know your System Environment. OS, 32/64-bit, JDK etc. Please also let us know the xms and xmx settings found in your Eclipse.ini file.
Hi Team,
LoadOptions options = new LoadOptions();
options.setMemorySetting(MemorySetting.MEMORY_PREFERENCE);
Workbook workbook = new Workbook(filePath + “XLSB2007TestNewS.xlsb”,options);
workbook.save(filePath + “out_java.xlsb”);
Hi Peng,
Thanks for your feedback and using Aspose.Cells.
It is good to know that you are now able to load and save using memory preference setting.
You will find xms and xmx settings inside the Eclipse.ini file like this
-Xms512m
-Xmx1024m
Thanks for letting us know your System Environment, we have logged it in our database. It will help us fix this issue.
If you want to release the memory, then just destroy the workbook object by setting all references to your workbook object with null. e.g
workbook = null;
It will release the memory consumed by workbook object.
Hi Peng,
Thanks for using Aspose.Cells.
We are unable to replicate this issue on our development machines.
Please let us know the minor version of JDK 1.6 so that we could replicate this issue at our end and fix this issue.
Hi team,
Hi team,
Hi Peng,
Thanks for your posting and using Aspose.Cells.
Please check your Java folder and find JDK version from there.
Please see this screenshot for your reference.
Hi Peng,
Thanks for using Aspose.Cells.
Please set the xms and xmx settings in your idea.exe.vmoptions file as
-Xms512m
-Xmx1024m
and let us know your test results.
Hi team,
Hi team,
Hi Peng,
Thanks for your feedback and using Aspose.Cells.
Could you please also try it with Eclipse instead of Intelli J Idea and see what are your results?
We have also logged your feedback in our database against this issue. We will look into it and update you asap. Once, there is some news for you, we will let you know.
Hi team,
Hi Peng,