Convert excel spreadsheet data to xml
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
<NameACEEE</Name
<URLhttp://www.aceee.com</URL
</EMail
<Description /
<DisplayOrder1</DisplayOrder
<ColWidth4</ColWidth
<SEKeywordsACEEE Products, ACEEE Parts</SEKeywords
<SEDescriptionFind ACEEE Products and ACEEE Parts at Conservation
Mart</SEDescription
<SETitleACEEE Products at Conservation Mart</SETitle
</Manufacturer
I want to convert the entire spreadsheet into repeating Manufacturer
elments. How do I do this.
|