step 1: open MS Excel 2007 or any version
First create root tag and child tag |
use the formula =b2&c2&d2 like that <Root><parent><child>child node</child></parent></Root> |
=B2&A2
=B3&D3&A3&E3 (Drage and drop untill the last child node
=C3&C2
the next cell assign the root tag or child tag name in the next cell and the drag and place the cell which
Then copy the final output and paste it in the notepad and save as filename.xml
and then open the xml file from your browser it will show in the format of xml.
Xml file for the about excel file..
xml file generated |
Wow...its a nice post..
ReplyDeleteI was looking for this information through this net...
Atlast i got it.. Now it will be useful for me..
Thanks a lot