Free Version

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Free Version

Postby leighton » Thu Jun 15, 2017 8:00 am

I have downloaded the free version (spire.xls-fe_7.9.zip) and expected it to throw an error when calling "workbook.LoadFromFile(@"file.xls");" as the file contains 10 sheets, with each sheet having 10,000 rows. (note: .xls file)

The file loaded without error, contrary to the stated limitations:

Free version is limited to 5 sheets per workbook and 200 rows per sheet. This limitation is enforced during reading or writing XLS or PDF files. From Free Spire.XLS v7.8, there is no any limitation when loading and saving .xlsx file format


I'm assuming the statement "From Free Spire.XLS v7.8, there is no any limitation when loading and saving .xlsx file format"
also applies to .xls file [/b]format"?
leighton
 
Posts: 1
Joined: Thu Jun 15, 2017 7:05 am

Re: Free Version

Postby Jane.Bai » Thu Jun 15, 2017 8:58 am

Hello,

Thanks for your inquiry.
As a matter of fact, the limitations to .xls do exist. When you load a .xls file which contains more than 5 sheets with more than 200 rows in each sheet, the program will not throw an excaption. However, when you check the .xls file you saved, you will find there are only 5 sheets and 200 rows. This is where the limitation lies.
If there's still any doubt, please feel free to contact us.

Sincerely,
Jane
E-iceblue support team
User avatar
Jane.Bai
 
Posts: 540
Joined: Tue Nov 29, 2016 1:47 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests