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.
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.