Wednesday, June 29, 2016

Create XML using EXCEL

Many a time I have got question about how to create XML with excel, So I decided to add this into my blog. Hope this will help the readers.

step 1:
Create one schema file (A template that we will use to generate the xml).
Eg. (Save following lines in dataSchema.xml file)

















Step 2:
Open your excel file containing the data.
CountryID CountryName
1 India
2 Pak
3 Srilanka
4 China
5 Koria


Step 3:
Go to the Developer TAB, if it is not on the top then you need to enable it from (File > Option )

Step 4:
Click "Source" under XML.
It will open XML source panel, having two buttons at the bottom. Click "XML Maps...".

Step 5:
Click "Add" to the XML Maps window.

Step 6:
Select "dataSchema.xml" file that we created in Step 1
Click OK twice

Step 7:
In XML Source you can now see the TREE VIEW of your columns.

Step 8:
Drag and Drop each column to the first row of your data.

Step 9.
Click "Export" button in Developers > XML tab.

Step 10:
You can now save this file as XML and that's it. Done.




No comments:

Post a Comment

Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.