Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Feb 06, 2019 12:10 am

Hi,

I have an application that already imports XLSX files without issue, however my users are more and more commonly using XLSB to reduce file size. I need a component which can convert XLSB to XLSX.

Is this something I can use your component suite for? what level of licence do I need to be able do this?

aussiealf
 
Posts: 1
Joined: Wed Feb 06, 2019 12:04 am

Wed Feb 06, 2019 6:23 am

Hi,

Thanks for your inquiry.
Spire.XLS supports converting XLSB to XLSX, below is sample code for your reference:
Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("sample.xlsb");
            workbook.SaveToFile("result.xlsx", ExcelVersion.Version2010);


There are two main factors will effect on the license subscription choose:
1. How many developers use our product
2. How many geography locations that the applications will be deployed to
You could check the details information as below:
https://www.e-iceblue.com/Misc/purchase-policies.html
https://www.e-iceblue.com/Buy/Spire.XLS.html

More questions about purchase, please contact our sales team(sales@e-iceblue.com)

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Feb 13, 2019 12:31 am

I have purchased the Pro subscription, and now when we try to load the XLSB I get an exception

sprᭆ: 'Invalid workbook setting in the xlsb workbook.'
at spr⇩.ᜇ()

I assume your code is obfuscated so it doesn't give meaningful errors.

I can't attached the file to this forum as it is a public forum, if you can provide an email or some way to communicate privately I am happy to provide the file which is causing me this exception.

At this stage I am looking to cancel or subscription as the only function I need from your library is to load the XLSB and save an XLSX to stream.

TBSD
 
Posts: 2
Joined: Tue Feb 12, 2019 11:17 pm

Wed Feb 13, 2019 12:32 am

Also this file opens fine within Excel 2013 and Excel 2016. And functions with all macros etc.

So the file isn't corrupt

TBSD
 
Posts: 2
Joined: Tue Feb 12, 2019 11:17 pm

Wed Feb 13, 2019 3:30 am

Hi TBSD,

Thanks for your information.
After testing your case with the latest Spire.XLS Pack(Hotfix) Version:9.1.22, I didn’t encounter the issue you mentioned. Below is my testing code:
Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(FilePath + @"POB_ENTSIP_131218.xlsb");
MemoryStream stream = new MemoryStream();
workbook.SaveToStream(stream, FileFormat.Version2016);

Please try to use the latest version.

Best wishes,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS