Generating XML from Excel

T

Ted Clifton

Hello,

I have a question about how to use the XML export
functionality in Excel 2003. I have a schema that I am
using to map to colmns in Excel. That works great and I
can export in a basic test. The problem comes in when I
try to add in columns that should be child nodes of the
existing row. I am not sure if I am using all the correct
terminology.

Here is an example. If you have a spreadsheet as follows:
Name ID Hair Color CName VName CName VName
Ted 1 Brown Level Mgr Area 12

I need the XML to map to:
<user>
<name>Ted</name>
<ID>1</ID>
<Hair Color>Brown</Hair Color>
<user_demographic>
<CName>Level</CName>
<VName>Mgr</VName>
</user_demographic>
<user_demographic>
<CName>Area</CName>
<VName>12</VName>
</user_demographic>
</user>

Is there a way to do this? Is there other information
that I could provide that would help answer this question?

Any help would be greatly appreciated.

Thanks,
Ted
 
Top