xml to excel

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

re: xml to excel

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.

re: xml to excel

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

re: xml to excel

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:
On export, need a reversed method.
See Export Excel to XML.

re: xml to excel

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

re: xml to excel

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

Thanks,
DOrin.

re: xml to excel

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