Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the namespace when doing a SaveAsXMLData
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the namespace when doing a SaveAsXMLData
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" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the namespace when doing a SaveAsXMLData
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" wrote: 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" wrote: 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the namespace when doing a SaveAsXMLData
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" wrote: 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" wrote: 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" wrote: 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the namespace when doing a SaveAsXMLData
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! "Joel" wrote: 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" wrote: 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" wrote: 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" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening the xls file which creates a Temp Folder inside Temp | Excel Discussion (Misc queries) | |||
CreateObject - Namespace variable | Excel Programming | |||
namespace.pickfolder | Excel Programming | |||
Macro looking to Outlook for namespace. | Excel Programming | |||
Automation Adding XmlMaps & SaveAsXMLData in Excel | Excel Programming |