Max rows for excel 2010

[frostholm]

Is there really an limitation to 65535 rows using free.xls and creating/writing an excel2010 format document ?

I try this and only get 65535 rows out of around 85000

best regards
Michael F

[sweety1]

Hello,

Thanks for your inquiry.
Yes, the free version of Spire.XLS has the feature limitation. I recommend you use the commercial version（ The latest version is Spire.XLS Pack Hotfix Version:7.8.26 ) which has no any limitations.

Best Regards,
Sweety
E-iceblue support team

[frostholm]

Hi.

Thank you for your reply. I would say that this is very bad news for me. I choose this addon to do my excel export because it was free and it did not have any limitations, read here from your description on you website :

Friendly Reminder:
Free version is limited to 5 sheets per workbook and 150 rows per sheet. This limitation is enforced during reading or writing XLS or PDF files. Free Spire.XLS v7.8 has no any limitatin 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. Upgrade to Commercial Edition of Spire.XLS

I have used 2 weeks to convert our excel engine and a lot of reports, and then i fall over this when i try to make a report containing 82000 records.

We are a company which are small and dont have money to just bye the pro licence, so i would say this is more than sad news for me, and not a reason i would recommend this product to others (and thats sad because i really love your product.)

Best regards
Michael

[frostholm]

I have bought a pro oem version (but have not yet recieved serial number), i have installed the pro version 7.8.26 from nuget, but i still only get 65535 rows ??? And a evaluation warning. It is very critical i get the licence and get no limits in row, we should launch tomorrow to our customer.

What should i do ?

Regards
Michael

[Betsy]

Dear Michael,

I have tested your license and Spire.XLS pro version: 7.8.26. And everthing is ok.Kindly note
1) make sure if the Spire.XLS pro version you were using is 7.8.26.
2) you need to apply the license file,and we suggest you apply the license by key, there is method to apply the license for your reference.
3) please use following code when creating a new file:

Code: Select all

Workbook wb = new Workbook();
wb.Version = ExcelVersion.Version2010;

If i missing something, please let me know.

Sincerely,
Betsy
E-iceblue support team

[frostholm]

Thanks for you answer, i got it to work.

I was the line "wb.Version = ExcelVersion.Version2010;" that solved my problem, but just tu state i works i both free and pro version

[Betsy]

Dear Michael,

Thanks for your response. If there is any question, welcome to get it back to us.

Best Regards,
Betsy
E-iceblue support team