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" <>
Sent: Thursday, December 18, 2008 6:13 PM
To: <>
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
>
>
>
