Greetings,

I have been able to reproduce this issue in both 2010.3SR and 2011.1.

The line of code that fails is:

Workbook wb = Workbook.Load(Filename, false);

When attempting to load an Excel 2007 XLSX file that contains a picture linked to an image on the web I receive the error:

Value cannot be null.\r\nParameter name: name

If I remove the image or replace it with a version that is a simple image file pasted in, the import is successful.

I don't care about importing the image. I don't need the pictures from these spreadsheets. I want to import the data from these sheets--but since my end users are not in control of creating these files they will need to be able to process whatever comes there way.

As a side note, there is no problem importing an Excel 2003 XLS file containing this type of image.

Any ideas or help is appreciated.

Stack Trace

   at System.Xml.XmlConvert.VerifyNCName(String name)
   at MS.Internal.IO.Packaging.InternalRelationshipCollection.ThrowIfInvalidXsdId(String id)
   at System.IO.Packaging.PackagePart.GetRelationshipHelper(String id)
   at System.IO.Packaging.PackagePart.GetRelationship(String id)
   at Infragistics.Documents.Excel.PackagePartWrapper.GetRelationship(String id)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.GetRelationshipDataFromActivePart(String relationshipId)
   at Infragistics.Documents.Excel.Serialization.Excel2007.SharedElements.Drawing.BlipElement.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, BeforeLoadElementCallback beforeLoadElementHandler, AfterLoadElementCallback afterLoadElementHandler, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.WorksheetShapeSerializationManager.LoadChildElements(Excel2007WorkbookSerializationManager manager, ExcelXmlNode node, Boolean& isReaderOnNextNode)
   at Infragistics.Documents.Excel.Serialization.Excel2007.SharedElements.Drawing.PicElement.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.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)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPart(IPackagePart part)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPartRelationships(IEnumerable`1 relationships, ContentTypeBase contentType)
   at Infragistics.Documents.Excel.Serialization.Excel2007.Excel2007WorkbookSerializationManager.LoadPart(IPackagePart part)
   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, Boolean verifyExcel2007Xml)
   at DataWarehouseToolkit.VendorLinkFileLoader.loadFile(String Filename, String Format, String WorksheetName, Int32 WorksheetIndex, Int32 MaxSample) in C:\PRISM Toolkit 4.4\Source Code\VendorLinkFileLoader.cs:line 64
   at DataWarehouseToolkit.ConstellationVendorLinkWorksheetUpdateAdd.loadSampleUltraButton_Click(Object sender, EventArgs e) in C:\PRISM Toolkit 4.4\Source Code\VendorLinkWorksheetUpdate.cs:line 385