Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export xml source mapping
I would like to export my excel worksheet to xml. For example, my
excel data looks like this. Color Grade Red A Blue C Green B And I would like the XML to look like this: <?xml version="1.0" encoding="UTF-8" standalone="yes"? <colorGradeTable xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" <color <valueRed</value </color <grade <valueA</value </grade <color <valueBlue</value </color <grade <valueC</value </grade <color <valueGreen</value </color <grade <valueB</value </grade </colorGradeTable But, when I try to map the worksheet data to the source file it will only map the single items, not a list of items. For example, I can get example for Red A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
Export Data to CSV without closing source workbook | Excel Programming | |||
How change link source in long formula when source moved | Excel Programming | |||
Using Excel's XML mapping/export with data organized in columns | Excel Worksheet Functions | |||
Mapping Tables.Fields from a data source to my MS Access Table Structure | Excel Programming |