[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Converting Excel Table to XML document
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 > > -- Shift to the left, shift to the right! Pop up, push down, byte, byte, byte! -Ramkumar Menon A typical Macroprocessor
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] |
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|