Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I map multiple XML elements in excel?
Hi, I'm trying to map a single XML element to multiple columns in 2003 Pro
Excel and I'm having a bit of trouble. I've mapped my XML schema to XML Source... and I'm trying to map a child element to multiple cells.... My schema looks like this: <?xml version="1.0" encoding="utf-8" ? <schema xmlns="http://www.w3.org/2001/XMLSchema" <element name="Root" <complexType <sequence <element name="Distribution" maxOccurs="unbounded" <complexType <sequence <element name="town" type="positiveInteger" / <element name="species" type="positiveInteger" / </sequence </complexType </element </sequence </complexType </element </schema and I want to map species to a bunch of columns... however, I get the message: This element is aleady mapped, an element cannot be mapped more than once. I read in the troubleshooting section you need to change the ancestor element... but I'm not sure what to do. Can anyone help? Thanks! |
#2
|
|||
|
|||
I'm sorry... here is the schema again... ?xml version="1.0" encoding="utf-8" ? schema xmlns="http://www.w3.org/2001/XMLSchema" element name="Root" complexType sequence element name="Distribution" maxOccurs="unbounded" complexType sequence element name="town" type="positiveInteger" / element name="species" type="positiveInteger" / /sequence /complexType /element /sequence /complexType /element /schema |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple worksheets open on starting Excel. | Excel Discussion (Misc queries) | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
Excel - printing multiple worksheets on one page | Excel Discussion (Misc queries) | |||
Excel should support multiple monitors better (like Word does) | Excel Worksheet Functions |