ccherry13
asked on
Converting XML to Microsoft Excel
Is anyone familiar with a readily available object, driver or other means of converting XML to Microsoft .xls format?
Any help would be greatly appreciated?
Any help would be greatly appreciated?
There's also an article on how to do this. Check out http://www.xmlmag.com/upload/free/features/xml/1999/01win99/kc1win99/kc1win99.asp.
--Mark Johnson
--Mark Johnson
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use XML Spy and have it export / import data from datasources.
Hi again,
How did it go??
trying or got some figured out already?
:O)Bruintje
How did it go??
trying or got some figured out already?
:O)Bruintje
and?
ASKER
Comment accepted as answer
ASKER
Excellent, concise answer
You can downlaod the reference for Office2k since it's native HTML/XML
http://msdn.microsoft.com/library/officedev/ofxml2k/ofxml2k.htm
All the sample code you need and a complete guide to the seperate Office components with their respective xml tree's
a few sample pieces from that reference
"
Example
This example shows XML document property elements specifying the authors, the company, the version, and when the document was created, printed, and saved.
><xml>
<o:DocumentProperties>
<o:Author>Nancy Davolio</o:Author>
<o:LastAuthor>Robert King</o:LastAuthor>
<o:LastPrinted>1999-05-13T
<o:Created>1999-05-13T01:3
<o:LastSaved>1999-05-14T21
<o:Company>Microsoft Corp.</o:Company>
<o:Version>9.2720</o:Versi
</o:DocumentProperties>
</xml>
This example shows the contents of the filelist.xml file. It lists the main file, print.htm, and its two supporting files, img001.png and filelist.xml.
<xml xmlns:o="urn:schemas-micro
<o:MainFile HRef="../print.htm"/>
<o:File HRef="img001.png"/>
<o:File HRef="filelist.xml"/>
</xml>
The following example shows the XML element in a cachedata.xml file. Five namespaces are specified: dt, rs, s, x, and z.
<xml xmlns:x="urn:schemas-micro
xmlns:dt="uuid:C2F41010-65
xmlns:s="uuid:BDC6E3F0-6DA
xmlns:rs="urn:schemas-micr
....
</xml>
"
HTH:O)Bruintje