Converting Excel to XML -

i have hierchical data stored in spreadsheet converting xml using groovy script.

col   col b          a1         a2         a2 b         b1 b         b1 b         b2 

this needs follows in xml format:

<a>  <a1></a1>  <a2></a2> </a> <b>  <b1></b1>  <b2></b2> </b> 

i have managed read off xls , write xml.i having trouble associating a1 , a2 single element output looks

<a>  <a1></a1> </a> <a>  <a2></a2> </a> <b>  <b1></b1> </b> <b>  <b2></b2> 

what programmatic way read excel?

turned out simple using hash in groovy