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@i...]
Sent: Thursday, December 18, 2008 1:13 PM
To: xml-dev@l...
Subject: 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
Cart
