RE: [xml-dev] 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

Liz Andrews

Technical Marketing Manager
Altova, Inc.

www.altova.com

This e-mail and any attachments are intended only for the person/entity to which they are addressed and may contain confidential and/or privileged material. If you received this in error, please notify the sender and delete the message.

From: Oscar Rodriguez [mailto:orodriguez@innoveer.com]
Sent: Thursday, December 18, 2008 1:13 PM
To: xml-dev@lists.xml.org
Subject: [xml-dev] Converting Excel Table to XML document

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