xml to excel

[teradam]

I have an xml card which is an import file to one application. I want to convert this xml to xls including all its logic. I tried several xml->xls converters but the reason is always different and I guess it does not shows the real structure because if I convert back this excel to xml it differs from original one. Does anybody have any idea how could be this problem solved.
You can check this xml:http://tripx.uw.hu/testxml/colour.zip
Thanks, Adam

[dorinbogdan]

Hi,

Did you solve the problem? or still need the answer.

If you convert the XML into HTML, and view in Internet Explorer as table format, is not it fine?
Or it's required in Excel format?

Thanks,
Dorin.

[teradam]

Hi, thanks for the response but unfortunately your idea does not solve my problem. The problem is that I have to edit document in excel so I must see the real structure of sheets and tables to be able add new data to excel file and convert it back to xml, and finally import it to the application. Thanks, Adam

[dorinbogdan]

I think the best solution is to write a macro in Excel that will read the XML file using Microsoft.XMLDOM (or MSXML) object and fill the sheet as desired.
Small tip:

Set xmldoc = CreateObject("Microsoft.XMLDOM")
xmldoc.Load "c:\xmldoc.xml"
Set doc = xmldoc.documentElement 
 
For Each node In doc.childNodes
       'put some values in some cells
Next 

On export, need a reversed method.
See Export Excel to XML.

[Badrimahesh]

hi
i am Badri, i want a script (.sh or .pl ) that convert .csv file into xml
could you pls help me

for example:
Pls find the .csv file below

N,2380539,B, 34100.00,56.5503,MXN,0040415010,0040415515,MXN,1.0 0,MXN,05022007,05072007,1928365.23,5785.10,0,19341 50.33,1
928365.23,420, , ,13212200114000,13212200114001,
,N,B0P72G5,B, 90000.00,40.3994,BRL,6206736693,0040415515,BRL,1.0 0,BRL,05022007,05072007,3635946.00,9271.66,1272.58 ,364649

[dorinbogdan]

It seems that you need scripting help, so please post your question to the forum that matches your language.

Thanks,
DOrin.

[Badrimahesh]

It seems that you need scripting help, so please post your question to the forum that matches your language.

Thanks,
DOrin.

hi dorinbogdan,

i don't want any script,
i want like how to convert .csv file to xml,
Is there any commands or any syntax to convert .csv file to xml
pls do the need full