By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,330 Members | 1,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,330 IT Pros & Developers. It's quick & easy.

Excel ListObject XPath error "...syntax is not correct or is not supported by Excel"

P: n/a
I am having a problem with an Excel ListObject in my C# .NET
application. I am trying to map an XML schema to a ListObject, and
continue to get the error "The XPath is not valid because either the
XPath syntax is incorrect or not supported by Excel." No matter what
crazy things I try, I can not either get it to work, or get a
different, more interesting error message. :-)

I have created my ListObject, and added a schema to my XmlMaps.

The xml which is created by the schema looks something like
<Document xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xsi:noNamespaceSchemaLocation="H:\CurrentProjects\ RPM\WuPM\Untitled4.xsd">
<Row Time="2001-12-17T09:30:47-05:00">
<Id.c72103dc-fba1-4743-a58e-ac53a6181058 Days_On_Stream="3.14159"/>
Then I have a statement resembling
ListObject.ListColumns[n].XPath.SetValue(myXmlMap, xpath_string,
null, true)
It seems that no matter what I pass as xpath_string, it is rejected.
I've tried
and what feels like an endless combination of others. The only success
I've had is with the Time attribute, where this path

I'm not having a lot of luck finding resources on the web that help me
identify what I'm doing wrong. Anybody have any advice?!


May 17 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.