ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing XML containing Complex Elements (https://www.excelbanter.com/excel-discussion-misc-queries/47804-importing-xml-containing-complex-elements.html)

troy

Importing XML containing Complex Elements
 
I am attempting to manipulate XML with Excel and am having a problem. The
XML contains a complex element (an element with subelements). When the
import executes, Excel treats the element as a single list, not a series of
lists. And when I try to export it back out I receive the following
messages: Map is not exportable because it contains the following:
Denormalized data; A mapped element's relationship with other elements cannot
be preserved.

The XML file has an underlying XSD defining the complex element.

Sample XML with complex elements:
<Parents
<Parent
<Name</Name
<DOB</DOB
<Children
<Child
<Name</Name
<DOB</DOB
</Child
</Children
</Parent
</Parents

Can someone point me to some doco on how to handle complex xml elements?


All times are GMT +1. The time now is 11:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com