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

Re: Converting Excel Table to XML document

• From: "Anthony B. Coates (XML-Dev)" <abcoatesecure-xmldev@y...>
• To: XML-dev <xml-dev@l...>
• Date: Sat, 27 Dec 2008 13:35:19 -0000

What I've found easiest is to export an Excel sheet as HTML, run that  
through a "tidy" program to convert it into XHTML, then process the XHTML  
with XSLT (or your XML processing tool of choice).

Cheers, Tony.

On Wed, 24 Dec 2008 08:30:53 -0000, Ramkumar Menon  
<ramkumar.menon@g...> wrote:

> You can save the Excel as a csv file and then run an XSLT 2.0
> stylesheet to convert it into an XML.
>
> Take a look at  
> http://ajwelch.blogspot.com/2007/02/csv-to-xml-converter-in-xslt-20.html
>
> Ram
>
> On Fri, Dec 19, 2008 at 6:22 AM, Stefan Vasile <stefan@o...>  
> wrote:
>> Dear Oscar,
>>
>> You may take a look at "Import from Excel files" feature of Oxygen XML
>> Editor
>>
>> http://www.oxygenxml.com/doc/ug-oxygen/import-excel.html
>> http://www.oxygenxml.com/doc/ug-oxygen/import-text.html#figure-import-criteria-dialog-id
>>
>> Best regards,
>> Stefan Vasile
>> http://www.oxygenxml.com
>>>
>>> *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
>>>
>>>
>>
>>
>> _______________________________________________________________________
>>
>> XML-DEV is a publicly archived, unmoderated list hosted by OASIS
>> to support XML implementation and development. To minimize
>> spam in the archives, you must subscribe before posting.
>>
>> [Un]Subscribe/change address: http://www.oasis-open.org/mlmanage/
>> Or unsubscribe: xml-dev-unsubscribe@l...
>> subscribe: xml-dev-subscribe@l...
>> List archive: http://lists.xml.org/archives/xml-dev/
>> List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
>>
>>
>
>
>

-- 
Anthony B. Coates
Director and CTO
Londata Ltd
UK: +44 (20) 8816 7700, US: +1 (239) 344 7700
Mobile/Cell: +44 (79) 0543 9026
Data standards participant: genericode, ISO 20022 (ISO 15022 XML),  
UN/CEFACT, MDDL, FpML, UBL.
http://www.londata.com/

• Follow-Ups:
  • Re: Converting Excel Table to XML document
    • From: Dave Pawson <davep@d...>

• 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...>
  • RE: Converting Excel Table to XML document
    • From: "Liz Andrews" <liz.andrews@a...>
  • Re: Converting Excel Table to XML document
    • From: Stefan Vasile <stefan@o...>
  • Re: Converting Excel Table to XML document
    • From: "Ramkumar Menon" <ramkumar.menon@g...>