Help me to convert Excel to XML
Hi all,
I need to convert data stored in MS Excel into a .xml file. Can you help me to create a macro which transforms the following Excel structure into xml: 1. term|t1|t2|id|defn|abbr|trns|usg|src|syn|see|addre ss|phone 2. term|T|TE|20|definition|abbreviation|translation|u sage|sou rce|synonym|see also|address|phone whe 1. is the header row 2. is a single record "|" marks the table colums I need to convert the above structure like this (where "line" coresponds to a row): <?xml version="1.0" encoding="UTF-8" ? - <glossword - <line <term t1="T" t2="TE" id="20"term</term <trsptranscription</trsp - <defn <abbrabbreviation</abbr <trnstranslation</trns definition <usgusage</usg <srcsource</src <synsynonym</syn <seesee also</see <addressaddress</address <phonephone number</phone </defn </line </glossword Thank you for all your help Regards, Ivaylo |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com