|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 22nd, 2004, 05:20 PM
|
||||
|
||||
|
XML to Excel how to - please help!
Can someone tell me how to convert an xml file to an excel file.....I have an xml database and cannot do anything with it until I convert it to excel.
Any help would be greatly appreciated.
|
|
#2
July 23rd, 2004, 10:13 AM
|
||||
|
||||
|
what version of excel?
I just clicked opened an xml file into excel and it did a fairly decent job of doing it. I opened it just like a normal excel file. w/o providing excel with my stylesheet. edit: I just opened it up with applying my stylesheet and it did a fairly good job as well. -Teflon
__________________
Teflon - The Black <desc>Mark This Up</desc>
|
|
#3
August 2nd, 2004, 09:08 AM
|
|||
|
|||
|
XML to Excel
Yes I can second that!
I have opened up an XML file into Excel just by using the instructions in excel for opening an XML file. Excel also has good features for converting .xls files to XML files. Your problem could be that the XML file is not valid / strict XML and in that case it is not recognised. XML is a very strict standard. Get it validated - or upload it in text form here and I can check it for you. It is also possible to write a program that picks out the data in the XML file and converts it to a tab or comma deliminated file - using PHP. This may work with your version of excel (if it is an old version.) Hope you have some luck! Trev
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > XML Programming > XML to Excel how to - please help! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
