XML Import Parsing error



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.



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question