Excel to XML

[santhoshs.oracle]

Hi

I have some XML files (with child attributes). Since there is some errors in this files I have open it in Excel and correct it and again I have to convert as an XML file.

Is it possible to do this??

Regards

Santhosh S
santhoshs.oracle@gmail.com

 

[Andrew Poulsom]

If you've opened it as a text file in excel, you should be able to resave it as a text file.

 

[santhoshs.oracle]

Sorry, your answer is not related to my question. My question is as follows:
I have to convert the Excel file to a XML file (file is having some child attributes).

 

[Andrew Poulsom]

What steps did you take to open and edit the XML file in Excel?

 

[santhoshs.oracle]

xml file -----open with ----Microsoft Office Excel -----As an XML Table-----

then will copy the content of the file and paste it in another excel file as "Paste values". In this file i will do the changes

After the correction I have to do XML Map with original xml file again. Here, if there is child attributes in the xml file, there I am getting the error as follows

It is not exportable because it contains the following: List of lists.

Please update

Thanks

Santhosh

 

[Andrew Poulsom]

Sorry, list of lists is not supported by Excel. Apparently you can use xslt, but don't ask me how:

http://www.excelforum.com/excel-new-users/690990-how-to-map-export-xml-with-list-of-lists.html