XML Export Weirdness?

G

gglave

Hi,

I'm trying to use Excel 2003 to create some XML. I'm almost there,
however I'm encountering some weirdness. Specifically, in the XML I
use to create my map I've got some tags that looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<enterprise>
<extension>
<WEBCREDENTIAL xmlns="http://www.webct.com/IMS">abc123</WEBCREDENTIAL>
</extension>
</enterprise>

However, when I export it from excel as XML it looks like this:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<enterprise xmlns:ns1="http://www.webct.com/IMS"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<extension>
<ns1:WEBCREDENTIAL>abc123</ns1:WEBCREDENTIAL>
</extension>
</enterprise>

(XML somewhat snipped for clarity - That's the root of the problem)

How can I get rid of the ns1: namespaces business and all that other
stuff and just get my raw XML out?

Cheers,
Geoff Glave
Vancouver, Canada
 
Top