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
<> 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 <>
> 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:]
>>> *Sent:* Thursday, December 18, 2008 1: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
>>>
>>>
>>
>>
>> _______________________________________________________________________
>>
>> 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:
>> subscribe:
>> 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/
