Export Excel to XML with added string -

i have excel file contains column persons. in order export excel sheet xml provided xml schema looks this:

<members>     <person></person> </members> 

if export xml afterwards xml looks following:

<members>     <person>bob</person> </members> 

since since bob 1 in table persons means worked. want xml this:

<members>     <person><![cdata[bob]]></person> </members> 

i adjust output myself running macro before export i'm looking way make output xml automatically. how can archieve that? thanks.