Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 <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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
convert excel spreadsheet to a calendar? | Excel Worksheet Functions | |||
how do I convert an excel spreadsheet to cif format? | Excel Discussion (Misc queries) | |||
How do I convert an excel spreadsheet into a pdf? | Excel Discussion (Misc queries) | |||
Convert excel files to works 8 spreadsheet | Excel Discussion (Misc queries) |