Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do matrix operation with complex number elements in Excel | Excel Worksheet Functions | |||
Matrix operations with complex numbers | Excel Discussion (Misc queries) | |||
Complex situation, expert needed... | Links and Linking in Excel | |||
Excel: Can I use Fill_Color Attribs to count elements? | Excel Worksheet Functions | |||
Importing text file | Excel Discussion (Misc queries) |