R
rcmail14872
I would like to export my excel worksheet to xml. For example, my
excel data looks like this.
Color Grade
Red A
Blue C
Green B
And I would like the XML to look like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<colorGradeTable xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<color> <value>Red</value> </color>
<grade> <value>A</value> </grade>
<color> <value>Blue</value> </color>
<grade> <value>C</value> </grade>
<color> <value>Green</value> </color>
<grade> <value>B</value> </grade>
</colorGradeTable>
But, when I try to map the worksheet data to the source file it will
only map the single items, not a list of items. For example, I can get
example for Red A.
excel data looks like this.
Color Grade
Red A
Blue C
Green B
And I would like the XML to look like this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<colorGradeTable xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<color> <value>Red</value> </color>
<grade> <value>A</value> </grade>
<color> <value>Blue</value> </color>
<grade> <value>C</value> </grade>
<color> <value>Green</value> </color>
<grade> <value>B</value> </grade>
</colorGradeTable>
But, when I try to map the worksheet data to the source file it will
only map the single items, not a list of items. For example, I can get
example for Red A.