View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default XML Import Parsing error

I should have used htmlentities() only on the data between the xml tags,
rather than try to use it on the entire string, including the xml tags.

"Jeff" wrote:

I have created an xml file, and some elements contain weblinks w/parameters.

Excel hiccups when it encounters the &.

How can I make it where Excel's XML import will preserve these special
characters and still open the file?

The method by which I create the XML is through php. I accumulate along
string and then, write it to a file, "test.xml."

I have tried using $allthexml=htmlentities($allthexml);
It didn't work.

I tried including <![CDATA[ before the innerhtml of the tag and ]] after
it. That did not work, either.

Thanks.
html