Large Range ArgumentOutOfRange Exception

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Large Range ArgumentOutOfRange Exception

Postby darkcamper » 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

Re: Large Range ArgumentOutOfRange Exception

Postby Flash » 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

Re: Large Range ArgumentOutOfRange Exception

Postby qskatz » 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

Re: Large Range ArgumentOutOfRange Exception

Postby Suvi.Wu » 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 316 times
User avatar
Suvi.Wu
 
Posts: 156
Joined: Thu Oct 20, 2011 2:53 am

Re: Large Range ArgumentOutOfRange Exception

Postby maiden123 » 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

Re: Large Range ArgumentOutOfRange Exception

Postby Gary.zhang » 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: 1390
Joined: Thu Apr 04, 2013 1:30 am

Re: Large Range ArgumentOutOfRange Exception

Postby miguelgersolgarcia » 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

Re: Large Range ArgumentOutOfRange Exception

Postby amy.zhao » 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: 2256
Joined: Wed Jun 27, 2012 8:50 am

Re: Large Range ArgumentOutOfRange Exception

Postby amy.zhao » 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: 2256
Joined: Wed Jun 27, 2012 8:50 am

Re: Large Range ArgumentOutOfRange Exception

Postby miguelgersolgarcia » Thu Jun 30, 2016 7:26 am

Its resolved. Perfect solution
miguelgersolgarcia
 
Posts: 2
Joined: Thu May 07, 2015 11:39 am

Re: Large Range ArgumentOutOfRange Exception

Postby amy.zhao » 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: 2256
Joined: Wed Jun 27, 2012 8:50 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests