I know this is an old issue, but i got the same error with a Excel 2007 file.

Infragistics for WinForms Version 12.2.2012.2.2027, Visual Studio 2012, VB.NET Framework 4 on Windows 7 64

StackTrace:

System.ArgumentException: The name is not a valid named reference name.
Parameter name: value
   at Infragistics.Documents.Excel.NamedReferenceBase.SetNameInternal(String value, String paramName, WorkbookFormat currentFormat, Boolean validateName)
   at Infragistics.Documents.Excel.NamedReferenceBase.SetNameInternal(String value, String paramName, WorkbookFormat currentFormat)
   at Infragistics.Documents.Excel.NamedReferenceBase.set_Name(String value)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XLSX.Elements.DefinedNameElement.Load(Excel2007WorkbookSerializationManager manager, ExcelXmlElement element, String value, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, ExcelXmlDocument document, XmlReader reader, ElementDataCache elementCache, List`1 elementCacheCollection, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, ExcelXmlDocument document, XmlReader reader, ElementDataCache elementCache, List`1 elementCacheCollection, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, ExcelXmlDocument document, XmlReader reader, ElementDataCache elementCache, List`1 elementCacheCollection, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XmlElementBase.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.XmlContentTypeBase.Load(Excel2007WorkbookSerializationManager manager, Stream contentTypeStream)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPart(IPackagePart part)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPartRelationships(IEnumerable`1 relationships, ContentTypeBase contentType, Boolean isPostLoad)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPartRelationships(IEnumerable`1 relationships, ContentTypeBase contentType)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadWorkbookContents()
   at Infragistics.Documents.Excel.Serialization.WorkbookSerializationManager.Load()
   at Infragistics.Documents.Excel.Workbook.LoadXLSXFile(Workbook workbook, Stream stream, IPackageFactory packageFactory, Boolean verifyExcel2007Xml)
   at Infragistics.Documents.Excel.Workbook.LoadHelper(Stream stream, WorkbookFormat format, String parameterName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml)
   at Infragistics.Documents.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory, Boolean verifyExcel2007Xml)
   at Infragistics.Documents.Excel.Workbook.Load(String fileName, IPackageFactory packageFactory)
   at Infragistics.Documents.Excel.Workbook.Load(String fileName)

added a file which causes the error

kind regards,

AK

Table support, including the ability to parse formulas referencing columns in tables, was added in version 12.1. Which version of the product are you using? If it is older than 12.1, you will need to upgrade to a newer version.

I have similar issue while loading the excel into workbook. This worked perfectly fine till we have to make change in excel file. We have namedreference formula which is throwing following error.

"The formula has extra expressions after the end of it.Portion with error: [Counterparty Name]

formula value = "=Table_Power_CP_List_1[Counterparty Name]"

if (dialog.ShowDialog() == true)

{

using (Stream stream = dialog.File.OpenRead())

{

dataWorkbook = Workbook.Load(stream);

}

}

I want to attach the excel file but not sure how to do it. What can be the issue? 

Please help me. Thanks in advance.

Thanks,

Swathi

Dear Mike,

I have downloaded the latest service release and now it works perfect.
Thank you very much for that quick help and I am very glad that
the Infragistics team is absolutely excellent.


Best regards
Frank

@kunze, I was able to reproduce your issue. This is a bug in the code which recognizes named reference names. It was only allowing digit characters of 0-9. It is not allowing for Unicode digit characters. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.

@oxygenating, your issue has been reported and fixed already (bug id 128383). If you download the latest SR for the version you are using, it should be fixed.

Dear community,

I do have quiet have the same problem with Infragistics.Documents.Excel.Workbook.Load();
Infragistics4.Documents.Excel.v12.2 Runtime Version v4.0.30319 Version 12.2.20122.1006

The attached file "ListData.xls" throws an exception if I load it:

In German: "Der Index lag außerhalb des Bereichs.Er muss nicht negativ und kleiner als die Auflistung sein.\r\nParametername: index"

Translated: "The index was out of range. It must not be negtive or smaller as the listing."

Then I looked with the debugger at the StackTrace:

StackTrace = "   bei System.ThrowHelper.ThrowArgumentOutOfRangeException()\r\n  
bei System.Collections.Generic.List`1.set_Item(Int32 index, T value)\r\n  bei Infragistics.Documents.Excel.Serialization.BIFF8.BiffRecords.STYLEEXTRecord.LoadHelper(BIFF8WorkbookSerializat...

It looks like that an index is either negative or out of range.

I have saved the "ListData.xls" as "ListData.xlsx" in Excel and the *.xlsx copy can be loaded normally with Infragistics.Documents.Excel.Workbook.Load();

Both files are attached in ListData.zip

In my opinion we need inside Infragistics4.Documents.Excel.v12.2 something like this: 

if( nIndex >= 0 && nIndex <= nMaxIndex )
   {
   ......
   }   
 
Thank you very much for any help and have a nice day.

Best regards
Frank