RE: Converting Excel Table to XML document

Hi Oscar,

Altova MapForce is a powerful data mapping tool that supports a wide variety of data formats including XML, Excel 2007, and flat files.

http://www.altova.com/products/mapforce/excel2007_ooxml_mapping.html

It also supports automation through code generation and the command line.

Best regards,

Liz

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