Need to read an excel file and print it as an xml
I have a requirement in my project for which i need some guidance.I have an excel sheet something similar to this .Please note that in the first 2 rows the columns "id" and "Name" have the same values but hobbies are different.
id Name Hobbies
1 Xxx Reading
1 Xxx Movies
2 Yyy Singing
3 Zzz Stamp collection
3 Zzz Sports
Now i want this to be converted to an xml which would look something similar to this:
I want the id and Name to be taken only once but the hobbies(which is repeated in the excel) should be repeated in the xml for that particular id.
Can someone tell me how to achieve this in Java?