View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jamesdafydd jamesdafydd is offline
external usenet poster
 
Posts: 1
Default XML export with <![CDATA[text]]

Hi,

I have successfully exported data from Excel to XML but I need the text
inside the nodes to be contained inside CDATA tags.

I'm getting this
<titlesome text here</title

but want this
<title<![CDATA[some text here]]</title

if i manually add the CDATA tag it treats it as html and returns the following
<title<![CDATA[some text here]]</title

Not sure if this is possible to do

Cheers