View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rcmail14872@yahoo.com is offline
external usenet poster
 
Posts: 13
Default export xml source mapping

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 <valueRed</value </color
<grade <valueA</value </grade
<color <valueBlue</value </color
<grade <valueC</value </grade
<color <valueGreen</value </color
<grade <valueB</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.