Setting the namespace when doing a SaveAsXMLData

[jeffbanjo]

It seems that Excel picks
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance as the namespace when
saving mapped cells to a datafile. How do you set this to something
different or not have a xmlns attribute in the root at all?

Thanks!

 

[Joel]

Try checking you setting in DOS. I'm not sure if excel is one of the following

1) Excel Menu - Tools - Option - General - Default file Location

2) A mapped Netwrok drive

3) An environmental variable

START - Run - cmd.exe (Opens DOS window). The in DOS type SET. This
returns the environmental variables.

 

[jeffbanjo]

Thanks - I looked in your suggestions and still didn't find the setting.
They must have it somewhere, but I haven't found it documented! Is there a
way to do this by setting the xmlns:xsi attribute for the root element?
I've seen the setAttribute function for an xml element but don't know how to
get the element object for the root element in a mapped xml app (I don't use
a loaded xmldoc object -My app maps cells to xml elements using an xmlmap and
then writes the sheet back out in xml). Somewhere in the xmlMap object?
I'm kinda new to xml programming in Excel - a few examples in the
documentation but not real good coverage.
Thanks,
Jeff

 

[Joel]

Check in the microsoft office directory

C:\Program Files\Microsoft Office

There is a XLSTART and a HTML where you may be able to set the defaults.

You can use the Window Expl;orer search on this directory and see if you
find the string http://www.w3.org/2001/XMLSchema-instance .

 

[jeffbanjo]

I only found it in a VisualC template header. Not in the registery either.
I guess I'll just live with it at this point. Probably hiding in some
option setting somewhere.... Thanks for the ideas - let me know if you
stumble on anything else.
Thanks!