Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Excel to XML
Hi all,
I need to convert an Excel data into XML structure. Can someone help me with a VBA code? In Excel, the columns a term|t1|t2|id|defn|abbr|trns|usg|src|syn|see|addre ss|phone The XML structure must be as follows (where line=Excel's 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 All suggestions how to do it will be more than welcome! Thanks Ivaylo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
How do I convert a Macintosh version 1 excel file to excel 2003 | Excel Discussion (Misc queries) | |||
How to convert excel Docs to pocket excel on my mobile device | New Users to Excel | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) |