rendy jaya

rendy jaya

  • NA
  • 15
  • 0

merge xml file with excel file

Jul 2 2012 11:19 AM
Hi,


i want to ask how to merge xml file with some colums in excel file.
let say i have a xml file like this 

<create>

                <student>

                                <student name="name" value="rrrr" />

                                <student name="address" value="planet xy" />

                                <student name="phone" value="00000" />

                </student>

</create>



and in my excel file i have some colums, for example 

course score
math 1
science 2


now i want to combine my xml file with this excel file, notice for the excel file i just want to take colums course 

the result that i want like this. 


<create>

                <student>

                                <student name="name" value="rrrr" />

                                <student name="address" value="planet xy" />

                                <student name="phone" value="00000" />

                                <student name="score" value="math" />

                </student>

</create>



can somebody help me? i really need help for this.

and notice i want to do it in C# .net. 



thank you very much.


Answers (5)