Free Spire.XLS Limitations?

[daveb]

Could you clearly explain the limitations to using Free Spire.XLS vs regular Spire.XLS? Free Spire.XLS seems to work fine for me, so why would I purchase a license?

Thanks.

[sweety1]

Hello,

Thanks for your inquiry.
Free version is limited to 5 sheets per workbook and 150 rows per sheet. This limitation is enforced during reading or writing XLSX, XLS, or PDF files. When converting Excel files to PDF files, you can only get the first 3 pages of PDF file. And we only maintain the free version when we have enough time.

Best Regards,
Sweety

E-iceblue support team

[daveb]

OK thanks. I couldn't find anything stating this anywhere on your web site, so this is good to know.

Now, if I can only get the last few things I need to work, a purchase is imminent.

Thank you,

[sweety1]

Hello,

Thanks for your reply.
Our dev team is doing some investigation about your issue. Once the issue is resolved or there are any progress, we will let you know ASAP.
Please feel free to contact us if you have any problems.

Best Regards,
Sweety

E-iceblue support team

[vchuquimia]

Hi, I have downloaded the 8.3 version and it still has the 5 sheets limitation on writing XLS even when the download page states:

"From Free Spire.XLS v7.8, there is no any limitation when loading and saving .xlsx file format. When converting Excel files to PDF files, you can only get the first 3 pages of PDF file"

any suggestion ?

kindly
Victor Ch.

[hogan.tang]

Hi vchuquimia,

Thanks for your post.
Our free Spire.XLS doesn't have any limitation when loading and saving .xlsx file format. But for .xls file format, it indeed has the 5 sheets limitation. When using the code "Workbook workbook = new Workbook();" to create a new file, it would create an Excel file with version 2003 by default. Please use following code to set the version to version 2007 or above.

Code: Select all

Workbook workbook = new Workbook();
//set the version
workbook.Version = ExcelVersion.Version2007;
//your code...
workbook.SaveToFile("result.xlsx",ExcelVersion.Version2007);

If there is still the issue, please feel free to let us know.

[hogan.tang]

Hi vchuquimia,

Has your issue been solved ? Your feedback would be greatly appreciated.

[mj13119]

Hi,

Does free version has limitation on No.of Rows for .xls version?

Regards,
Mudassir

[hogan.tang]

Hi mj13119,

Thanks for your inquiry.
Free version is limited to 150 rows per sheet.

[nyonyosgmm]

<package id="Spire.XLS" version="10.1.8" targetFramework="net452" />
I am using this version. It is nice. There is one sheet Evaluation Warning. That sheet is for Trial Period? If I do not purchase this version when will it be expried?

[Betsy.jiang]

Hi,

Thanks for your inquiry.
The Spire.XLS V10.1.8 is commercial version. So there will always be warning message if you don't purchase and apply the license correctly.
Our sales team has sent you a one-month free license to help you remove the warning message. You could have a better evaluation on our product. Please refer to following guide to apply the license:
https://www.e-iceblue.com/Tutorials/Lic ... nsing.html

Sincerely,
Betsy
E-iceblue support team

[PatriciaSordo]

App vb.net
Net framework 4.8
Spire.xls free 14.2.0.0

Test:
Dim newWorkbook As Workbook = New Workbook()
newWorkbook.Version = ExcelVersion.Version97to2003
dim file as string= "C:\test\a.xls"

newWorkbook .LoadFromFile(file)

newWorkbook.SaveToFile("C:\test\LibroTotal.xls", ExcelVersion.Version97to2003)


If file is xlsx (ExcelVersion.Version2016) ok, but with xls file (ExcelVersion.Version97to2003) is limited to 200 rows.

¿How can I load xsl file without limit rows?

[Doris.Liu]

App vb.net
Net framework 4.8
Spire.xls free 14.2.0.0

Test:
Dim newWorkbook As Workbook = New Workbook()
newWorkbook.Version = ExcelVersion.Version97to2003
dim file as string= "C:\test\a.xls"

newWorkbook .LoadFromFile(file)

newWorkbook.SaveToFile("C:\test\LibroTotal.xls", ExcelVersion.Version97to2003)


If file is xlsx (ExcelVersion.Version2016) ok, but with xls file (ExcelVersion.Version97to2003) is limited to 200 rows.

¿How can I load xsl file without limit rows?

Hi,

Thanks for your message.
200 lines is the limit for our free version of Spire.XLS. If your requirements exceed the limitation, please use our Commercial Edition of Spire.XLS 14.4.7.
We would like to provide one-month free trial license, if you need it, you could click here to apply it.

Sincerely,
Doris
E-iceblue support team