import content of a xls file into several xml files

import content of a xls file into several xml files

I have an .xlsx file with the next format:

I need to create files:
/A/value.xml
/B/value.xml
/C/value.xml
/D/value.xml
with the content respectively:
/A/value.xml:
<root name =''1"> a </root>
<root name =''2"> aa </root>
<root name =''3"> aaa </root>
<root name =''4"> aaaa </root>
/B/value.xml:
<root name =''1"> b </root>
<root name =''2"> bb </root>
<root name =''3"> bbb </root>
<root name =''4"> bbbb </root>
and so on...
How to do it?
Thanks in advance.