Aspose Cells XSLB file issue in Excel 2013

Aspose.Cells Product Family
1

Hi,


I am using Aspose.Cells version 7.7.2.0 dll version to generate reports in my application. I am currently generating the files in XLSX format but now my requirement is to generate the reports in XLSB format. So i changed my filename to abc.xlsb and I am saving the workbook object like this:-

myWorkbook.Save(tempFilePath, SaveFormat.Xlsb);

When I am trying to open the report I am getting the attached error in excel 2013. Can you please help me with this?

I am not sure why it is not showing the attachment but here is the error message:-

"We found a problem in some content in abc.xlsb. Do you want us to try to recover as much as we can?"

Thanks,
Rahul


2

Hi,


Thanks for providing us some details.

Since you are using some older version of the product for which I am not sure if it is a bug or something else in the older version that you are using. Also, you did not attach the screenshot of the error or provide error description.

We recommend you to kindly try our latest version/fix: Aspose.Cells for .NET v8.8.0.4 if it makes any difference.

If you still find the issue with v8.8.0.x, kindly create a simple sample console application with v8.8.0.4, zip it and post us here to reproduce the issue on our end, we will check it soon. Also provide your template files (input and output, etc.). This will help us to evaluate your issue precisely to consequently figure it out soon.

Please note, if the issue occured in your older version, I am afraid, we cannot include fixes to older versions. The fixes are only based on latest APIs set.

Thank you.

3

Hi Amjad,


Thanks for the quick response. I have updated the error message. Also, I will try it out with latest dll version. Can you tell me is there anything I need to do extra for xlsb format? My report has lots of formatting.
4

Hi,


Thanks for the sharing the error message.

Well, your line of code is fine and you do not need to do extra to resave the workbook to XLSB file format. Please do as directed in my previous reply:
https://forum.aspose.com/t/31406

Thank you.