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

["Ramkumar Menon" <ramkumar.menon@gmail.com>]

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
>
>



-- 
Shift to the left, shift to the right!
Pop up, push down, byte, byte, byte!

-Ramkumar Menon
 A typical Macroprocessor