View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Todd J Todd J is offline
external usenet poster
 
Posts: 1
Default Excel to XML; export parses CDATA

I'm having a problem with the Excel to XML extension parsing my CDATA when it
exports to XML.

After importing an XML data sheet with a CDATA node, the XML-export parses
the CDATA code as it would with normal XML code; rewriting the greater-than
and less-than symbols. This interferes with any HTML that users wish to
include in their XML pages.

Is there an option so that the XML export won't change code in my CDATA
column?