We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

"Index and length must refer..." error

Thread ID:

Created:

Updated:

Platform:

Replies:

28836 May 11,2005 03:03 PM UTC May 26,2005 03:11 AM UTC WinForms 1
loading
Tags: XlsIO
Allen Blackmore
Asked On May 11, 2005 03:03 PM UTC

I''m receiving the error "Index and length must refer to a location within the string. Parameter name: length" when calling ExcelUtils.Open(). However, I''m able to copy and paste cells into a new spreadsheet and open that successfully. Are there any common causes of that error message? What can I check about the formatting, formulas, values, etc. of the original spreadsheet that could cause the error? There aren''t any charts, pivot tables, macros, or anything else I''d consider unusual. I''m using the 3.2 release candidate version.

Administrator [Syncfusion]
Replied On May 26, 2005 03:11 AM UTC

Hi Allen, I am not sure what could be causing this problem. This usually occurs when ExcelRW produces some incorrect file structures. Was the file that you are trying to open created using ExcelRW?. If not could you please send us the file through Direc-Trac. Also, please try opening the file using the latest patch which I remember had a similar fix http://www.syncfusion.com/squiffler/patches/v3.2.1.1/syncfusionessentialstudiopatchsetup.exe Thanks, Stephen. >I''m receiving the error "Index and length must refer to a location within the string. Parameter name: length" when calling ExcelUtils.Open(). However, I''m able to copy and paste cells into a new spreadsheet and open that successfully. > >Are there any common causes of that error message? What can I check about the formatting, formulas, values, etc. of the original spreadsheet that could cause the error? There aren''t any charts, pivot tables, macros, or anything else I''d consider unusual. > >I''m using the 3.2 release candidate version.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;