• From: "Oscar Rodriguez" <orodriguez@i...>
• To: <xml-dev@l...>
• Date: Thu, 18 Dec 2008 13:13:23 -0500

Hi - I have the following reference table in Excel

SourceApp    TargetApp

Competitor   Commercial
Partner        Business Partner
...

Does anyone know an easy way to convert the above table to an XML that looks as follows?

<?xml version="1.0" encoding="UTF-8"?>
<dvm name="Customer" isNew="null">
  <description>DVM description</description>
  <columns>
     <column name="SourceApp"/>
     <column name="TargetApp"/>
  </columns>
  <rows>
    <row>
      <cell>Competitor</cell>
      <cell>COMMERICAL</cell>
    </row>
  </rows>
</dvm>

Thanks in advance
- Oscar

• Follow-Ups:
  • Re: Converting Excel Table to XML document
    • From: "Joe Fawcett" <joefawcett@h...>
  • Re: Converting Excel Table to XML document
    • From: Chin Chee-Kai <cheekai@s...>
  • RE: Converting Excel Table to XML document
    • From: "Liz Andrews" <liz.andrews@a...>

• References:
  • Re: XML Schema: "Best used with the ______ tool"
    • From: Boris Kolpackov <boris@c...>
  • Re: XML Schema: "Best used with the ______ tool"
    • From: "Andrew Welch" <andrew.j.welch@g...>
  • Re: XML Schema: "Best used with the ______ tool"
    • From: "Andrew Welch" <andrew.j.welch@g...>