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.

Mon Oct 18, 2010 1:53 pm

Hi, while trying to test Spire.XLS using a customer's file I've got a ArgumentOutOfRangeException while loading the workbook.

After a bit of investigation I noticed the worksheet that caused the exception had a freeze pane with 1048576 rows. If I shrink the freeze pane under 64K rows it works fine so I suspect that Spire.XLS is using the old row limit of Excel 97 - 2003 instead of the new 1M rows limit present since Excel 2007.

Is there any chance you will be supporting >64k rows freeze panes (or ranges if the problem is with ranges in general) in some near version release?

Thanks in advance.

darkcamper
 
Posts: 13
Joined: Mon Sep 27, 2010 5:31 pm

Mon Oct 18, 2010 3:39 pm

Hello,

Sorry for the inconvenience.
Could you please send your excel file to us, we need to reproduce the issue and will try to solve it as soon as possible.

Best Regards
User avatar

Flash
 
Posts: 56
Joined: Thu Jun 29, 2006 2:34 pm

Wed Feb 01, 2012 5:53 pm

We are getting the exact same error on populating a workbook using worksheet.Range when the row is > 65536. We are seeing the same row limit as the old Excel 97 - 2003.
Any resolution to this?

qskatz
 
Posts: 1
Joined: Wed Dec 08, 2010 7:35 pm

Thu Feb 02, 2012 2:13 am

Hello qskatz,

Thank you for your feedback and your patience with our support team.

We have tested the issue with the latest hotfix[spire.Xls v6.0.8],you can download at http://www.e-iceblue.com/Download/download-excel-for-net-now/spirexls-for-net-hot-fix608.html ,it supports the largest row 1M. If you want to creat a excel2007 or excel2010 using Spire.Xls, you need to explicitly give the vertion as the default vertion is excel97-2003. We attached you a demo,please have a look.

If you still have this problem,please don't hesitate to contact us at any time.
Have a great day.

Suvi
e-iceblue support team
Attachments
236RowMore65536.zip
(6.25 KiB) Downloaded 602 times
User avatar

Suvi.Wu
 
Posts: 154
Joined: Thu Oct 20, 2011 2:53 am

Thu Oct 17, 2013 5:58 pm

using 7.0.0.7035 still getting same exception (ArguementOutOfRangeException) at row 65537

maiden123
 
Posts: 1
Joined: Mon Aug 05, 2013 8:04 pm

Fri Oct 18, 2013 3:55 am

Hello,

Thanks for your inquiry.

We have tested the issue with the latest hotfix[spire.Xls pack7.10], it works fine. You can download and test it from http://www.e-iceblue.com/Download/downl ... t-now.html.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue Jun 21, 2016 1:30 pm

i ve the same problems. using version 7.10 i got the same exception error and my Spire.xls dll only generate 65536 rows. Is there any solution?

miguelgersolgarcia
 
Posts: 2
Joined: Thu May 07, 2015 11:39 am

Wed Jun 22, 2016 1:31 am

Hi,

Thanks for your posting.
Please set excel version to Excel 2007/Excel 2010/Excel 2013.
Code: Select all
Workbook book = new Workbook();
            book.Version = ExcelVersion.Version2013;
            ........
           
            book.SaveToFile(output);


Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Fri Jun 24, 2016 7:56 am

Hi,

Has your issue been resolved?
Thanks for your feedback in advance.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Thu Jun 30, 2016 7:26 am

Its resolved. Perfect solution

miguelgersolgarcia
 
Posts: 2
Joined: Thu May 07, 2015 11:39 am

Thu Jun 30, 2016 7:50 am

Hi,

Glad to hear that. Welcome to feel free to write to us if you need further assistance.
Have a nice day.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS