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

["Anthony B. Coates (XML-Dev)" <abcoatesecure-xmldev@yahoo.co.uk>]

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@gmail.com> 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@oxygenxml.com>  
> 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@innoveer.com]
>>> *Sent:* Thursday, December 18, 2008 1: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
>>>
>>>
>>
>>
>> _______________________________________________________________________
>>
>> 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@lists.xml.org
>> subscribe: xml-dev-subscribe@lists.xml.org
>> 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/