CODEWITHSUNDEEP
xmlexcelexport-to-xmlvba
jz22
jz22

Reputation: 2658

Export Excel to XML with added string

I have an Excel file that contains the column persons. In order to export this Excel sheet to XML I provided an XML schema that looks like this:

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

If I export it to XML afterwards the XML looks like the following:

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

Since since Bob is the only one in my table persons it means that everything worked. However I want the XML to look like this:

<members>
    <person><![CDATA[Bob]]></person>
</members>

I could adjust the output myself by running a macro before the export but I'm looking for a way to make the output XML look like that automatically. How can I archieve that? Thanks.

Upvotes: 0

Views: 87

Answers (0)

Related Questions