Issue with .xlsb excel format (can't read xlsb for 2007)

shakeel.faiz · December 17, 2014, 3:49am

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.

poncc · December 17, 2014, 4:11am

Hi team,

Thanks your reply.

I use Aspose.Cells for Java v8.3.1.1 for XLSB2007TestNewS.xlsb,it’s still mistake.

XLSB2007TestNewS.xlsb still can’t load and keeps increasing memory consumption.

Error Message：

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

shakeel.faiz · December 17, 2014, 10:22am

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.

shakeel.faiz · December 17, 2014, 9:15pm

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.

poncc · December 18, 2014, 4:16am

Hi Team,

Thanks you reply.

If I add ‘setMemorySetting’ , I can load and save.

OS：win7/32

RAM：4G

JDK：1.6

I can’t found tfhe xms and xmx settings, if I found it, I will answer you.

I testing how can read xlsm for sheet data, if I have some question,I well ask you.

I use you code,and I add “initialize()” to release memory.

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”);

workbook.initialize();

Thank you~

shakeel.faiz · December 18, 2014, 11:55am

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.

shakeel.faiz · December 18, 2014, 8:07pm

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.

poncc · December 18, 2014, 8:08pm

Hi team,

I am upload this file(XLSB2007TestNewS.rar) in the top article for oldest.

And I found xms and xmx settings inside the idea.exe.vmoptions file.

setting is：

-Xms128m

-Xmx512m

I release memory using : workbook = null;

But I using WorkSheetCollection, and using worksheet.clear to release memory .

Else it will happen memory error.

1.If I using workbook.initialize, I can release memory for workbook and worksheet.

2.And I can release memory for workbook = null and worksheet.clear.

If I have some question I will ask you.

Thank you.

poncc · December 18, 2014, 8:13pm

Hi team,

What’s the “minor version of JDK 1.6” ?

My JDK version is 1.6 ,but I don’t know what “minor version of JDK 1.6”.

Thank you.

shakeel.faiz · December 18, 2014, 8:45pm

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.

shakeel.faiz · December 18, 2014, 9:23pm

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.

poncc · December 18, 2014, 11:13pm

Hi team,

Thanks your reply.

My jdk is jdk1.6.0_43

I found two files.

idea.exe.vmoptions:

-Xms128m

-Xmx512m

idea64.exe.vmoptions:

-Xms128m

-Xmx750m

Which I setting?

poncc · December 19, 2014, 2:06am

Hi team,

These are my tests.

Case 1:

idea.exe.vmoptions:

-Xms512m

-Xmx1024m

idea64.exe.vmoptions:

-Xms128m

-Xmx750m

Case 2:

idea.exe.vmoptions:

-Xms128m

-Xmx512m

idea64.exe.vmoptions:

-Xms512m

-Xmx1024m

Case 3:

idea.exe.vmoptions:

-Xms512m

-Xmx1024m

idea64.exe.vmoptions:

-Xms512m

-Xmx1024m

Case 1、Case 2 and Case 3:

If I remove “workbook = null” and “worksheets.clear()”.

Then it do not cause memory issues.

If I remove “option.setMemorySetting(MemorySetting.MEMORY_PREFERENCE)”.

Then it still has memory issues.

thank you.

shakeel.faiz · December 19, 2014, 7:06am

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.

poncc · December 20, 2014, 10:16am

Hi team,

I read xlsb for Ecplise.

And it’s not use “setMemorySetting”.

It’s work!! No memory issue.

xms and xmx set for ecplise.ini

-Xms40m

-Xmx768m

thank you!!

babar.raza · December 21, 2014, 12:27am

Hi Peng,

Thank you for the confirmation. It is good to know that you are up & running again, Please feel free to contact us back in case you need our further assistance with Aspose APIs.

amjad.sahi · December 24, 2014, 4:02am

Hi,

Please try our latest version/ fix: Aspose.Cells for Java v8.3.1.2

We have fixed your issue “CELLSJAVA-41131” now.

We have tested with the new fix v8.3.1.2, now, your file can be converted to PDF in about 10 min or so, It has 49570 pages.

Thank you.

poncc · December 25, 2014, 1:53am

Hi team,

I have tested your library for xlsb to output pdf about 20 min.

It’s OK.

Thank you.

babar.raza · December 25, 2014, 2:06am

Hi Peng,

It’s is good to know that the results are acceptable to you. Please feel free to contact us back in case you need our further assistance with Aspose APIs.

aspose.notifier · January 23, 2015, 3:23am

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

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