[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Converting Excel Table to XML document

• From: "Joe Fawcett" <joefawcett@h...>
• To: <xml-dev@l...>
• Date: Fri, 19 Dec 2008 09:19:04 -0000

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@i...>
Sent: Thursday, December 18, 2008 6: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
>
>
> 

• References:
  • Re: XML Schema: "Best used with the ______ tool"
    • From: Boris Kolpackov <boris@c...>
  • Re: XML Schema: "Best used with the ______ tool"
    • From: "Andrew Welch" <andrew.j.welch@g...>
  • Re: XML Schema: "Best used with the ______ tool"
    • From: "Andrew Welch" <andrew.j.welch@g...>
  • Converting Excel Table to XML document
    • From: "Oscar Rodriguez" <orodriguez@i...>