J
JimR
I need to read an XML file and have Excel create a schema for that file (I
have this part working) then I need to link all the data from the XML file
into a spreadsheet. I can do this so long as I know the XPath to each
category of data but since the XML file is an unknown and Excel inferred the
schema, I don't know all the XPaths. I have found that I can get the schema
by accessing the XML Property of the XMLSchema Object but then I am writing a
routine to parse an XML string (the schema that was returned).
I am hoping for a feature that will give me all of the XPaths for an unknown
XML file. This information is very nicely displayed in the XML Source window,
I just need to access it.
have this part working) then I need to link all the data from the XML file
into a spreadsheet. I can do this so long as I know the XPath to each
category of data but since the XML file is an unknown and Excel inferred the
schema, I don't know all the XPaths. I have found that I can get the schema
by accessing the XML Property of the XMLSchema Object but then I am writing a
routine to parse an XML string (the schema that was returned).
I am hoping for a feature that will give me all of the XPaths for an unknown
XML file. This information is very nicely displayed in the XML Source window,
I just need to access it.