Article - CS155221

"The XPath is not valid because either the XPath syntax is incorrect or not supported by Excel." error when using the Excel 2003 integration for Integrity

Modified: 13-Jan-2014   


Applies To

  • Integrity 2009, all service packs
  • Integrity 10.0-10.4
  • Excel Integration for Excel 2003/2007/2010

Description

  • When using the Excel (2003) Integration, the synchronize operation fails to complete, returning the following error to the user:
Error creating list/applying schema: The XPath is not valid because either the XPath syntax is incorrect or not supported by Excel.
  • The excelint.log file located in the User's temporary directory, reports the following error
Error creating list/applying schema: The XPath is not valid because either the XPath syntax is incorrect or not supported by Excel.
   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   at Microsoft.Office.Interop.Excel.XPath.SetValue(XmlMap Map, String XPath, Object SelectionNamespace, Object Repeating)
   at ExcelIntegration.Connect.createList(Range rng, XmlMap map)

 
This is a printer-friendly version of Article 155221 and may be out of date. For the latest version click CS155221