Convert Excel to XML file
843834Aug 6 2008 — edited Jan 27 2010Hi Guys,
I need to generate the XML from Excel file. The XML file will have the definition like this:
<people_list>
<name>Fred Bloggs</name>
<birthdate>27/11/2008</birthdate>
<gender>Male</gender>
</people_list>
The Excel file will look like this:
A B C
1 Fred Bloggs 10/21/2008 Male
2 ABC 12/23/2008 Female
3 XYZ 07/16/2008 Male
All the values in name,birthdaye,gender will come from the Excel file. I am having 100 rows in the Excel file with the data and I want to parse this excel file and create the XML file with the above template.
Any ideas how to do this?
Thanks,
Mahesh