Convert excel spreadsheet data to xml

J

Jaishree Knauff

Hi:
I have a spreadsheet that I'm trying to convert into XML data. I've
associated a map to it and mapped the xml attributes to cells on the
spreadsheet.
But it only converts one row into xml data. I want to convert the entire
spreadsheet into repeating elments of XML.

e.g. Manufacturer definition is
<Manufacturer>
<Name>ACEEE</Name>
<URL>http://www.aceee.com</URL>
<EMail>[email protected]</EMail>
<Description />
<DisplayOrder>1</DisplayOrder>
<ColWidth>4</ColWidth>
<SEKeywords>ACEEE Products, ACEEE Parts</SEKeywords>
<SEDescription>Find ACEEE Products and ACEEE Parts at Conservation
Mart</SEDescription>
<SETitle>ACEEE Products at Conservation Mart</SETitle>
</Manufacturer>

I want to convert the entire spreadsheet into repeating Manufacturer
elments. How do I do this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top