View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaishree Knauff Jaishree Knauff is offline
external usenet poster
 
Posts: 1
Default 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.