Re: [xml-dev] Converting Excel Table to XML document

["Joe Fawcett" <joefawcett@hotmail.com>]

If it's Excel 2003/2007 you can attach a schema describing the output XML 
and map the columns. Then export as XML.
If it's Excel in a lower version you can open it using COM object model and 
create the XML "by hand".


Joe Fawcett
http://joe.fawcett.name

--------------------------------------------------
From: "Oscar Rodriguez" <orodriguez@innoveer.com>
Sent: Thursday, December 18, 2008 6: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
>
>
>