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

Aspose.Cells Product Family
21

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.

22

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

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

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.

25

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.

26

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?


27

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.

28

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.

29

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!!
30

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

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.

32

Hi team,


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

It’s OK.

Thank you.
33

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

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.