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.

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

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: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS