Create XML element with a namespace prefix

[Krishna Tulasi via .NET 247]

Hi,

I am having trouble with creation of XML programmaticall y using .NET. Specifically Im trying to create an element which looks like below and insert into an existing xml doc:
<Worksheet ss:Name="TKCShe et1">
</Worksheet>

The existing xml doc is:

<?xml version="1.0"?>
<?mso-application progid="Excel.S heet"?>
<Workbook xmlns="urn:sche mas-microsoft-com:office:spre adsheet"
xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:html="htt p://www.w3.org/TR/REC-html40">

</Workbook>

I had no problem using LoadXml() to read this existing xml into m_XmlDoc.

But the code I am using for creating that Worksheet node (as explained above):

// add new worksheet xml node at the end of the document
XmlElement wsNode = m_XmlDoc.Create Element("Worksh eet");

XmlAttribute wsName = m_XmlDoc.Create Attribute("ss:N ame");
//XmlAttribute wsName = m_XmlDoc.Create Attribute("ss", "Name", XmlNsMgr.Lookup Namespace("ss") ); //- this did not work either :(

wsName.Value = ?TKCSheet1?;
wsNode.Attribut es.Append(wsNam e);
m_XmlDoc.Docume ntElement.Appen dChild(wsNode);
But this code gives me:
<Worksheet Name="TKCSheet1 " xmlns="">
</Worksheet>

I want ss:Name NOT just Name, in my xml and also I do NOT want xmlns="" in that element!

Can somebody please help me out here?

Thanks,
Krishna
PS: I know probably using Excel 2003 .NET libraries might be cleaner, but I have limited to get this thing running.
--------------------------------
From: Krishna Tulasi

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>tq30o75pHke +OTwMr4tQXQ==</Id>

[Derek Harmon]

"Krishna Tulasi via .NET 247" <an*******@dotn et247.com> wrote in message news:OA******** ******@TK2MSFTN GP12.phx.gbl...

// add new worksheet xml node at the end of the document
XmlElement wsNode = m_XmlDoc.Create Element("Worksh eet");
XmlAttribute wsName = m_XmlDoc.Create Attribute("ss:N ame"); : : But this code gives me:
<Worksheet Name="TKCSheet1 " xmlns="">
</Worksheet>

I want ss:Name NOT just Name, in my xml and also I do NOT
want xmlns="" in that element!

XmlElement wsNode = m_XmlDoc.Create Element(
null, // Prefix
"Worksheet" , // Tag name
"urn:schema s-microsoft-com:office:spre adsheet" // Default xmlns URI.
);

When tag prefix is null, you're saying that the QName for this XML
element should assume the default namespace URI. The default
namespace URI for the document is "urn:schema s-microsoft-com:
office:spreadsh eet," fine, but you must also tell CreateElement( )
the namespace URI explicitly. When the namespace URI argument
matches the current default namespace URI, .NET knows it doesn't
have to emit an xml namespace declaration. If you don't specify a
namespace URI, .NET follows your directions: you've told .NET
this element MUST have no tag prefix, the only way CreateElement( )
can reconcile this is by putting a default xml namespace declaration
on the element.
XmlAttribute wsName = m_XmlDoc.Create Attribute(
"ss", // Prefix
"Name", // Local Name
"urn:schema s-microsoft-com:office:spre adsheet" // xmlns URI for ss prefix.
);

Observe here that I tell CreateAttribute ( ) the prefix I want. It's going
to find, that it already knows about this prefix, as long as the namespace
URI you give it matches the namespace URI it knows about for this
prefix.
Derek Harmon

[Derek Harmon]

"Krishna Tulasi via .NET 247" <an*******@dotn et247.com> wrote in message news:OA******** ******@TK2MSFTN GP12.phx.gbl...

// add new worksheet xml node at the end of the document
XmlElement wsNode = m_XmlDoc.Create Element("Worksh eet");
XmlAttribute wsName = m_XmlDoc.Create Attribute("ss:N ame"); : : But this code gives me:
<Worksheet Name="TKCSheet1 " xmlns="">
</Worksheet>

I want ss:Name NOT just Name, in my xml and also I do NOT
want xmlns="" in that element!

XmlElement wsNode = m_XmlDoc.Create Element(
null, // Prefix
"Worksheet" , // Tag name
"urn:schema s-microsoft-com:office:spre adsheet" // Default xmlns URI.
);

When tag prefix is null, you're saying that the QName for this XML
element should assume the default namespace URI. The default
namespace URI for the document is "urn:schema s-microsoft-com:
office:spreadsh eet," fine, but you must also tell CreateElement( )
the namespace URI explicitly. When the namespace URI argument
matches the current default namespace URI, .NET knows it doesn't
have to emit an xml namespace declaration. If you don't specify a
namespace URI, .NET follows your directions: you've told .NET
this element MUST have no tag prefix, the only way CreateElement( )
can reconcile this is by putting a default xml namespace declaration
on the element.
XmlAttribute wsName = m_XmlDoc.Create Attribute(
"ss", // Prefix
"Name", // Local Name
"urn:schema s-microsoft-com:office:spre adsheet" // xmlns URI for ss prefix.
);

Observe here that I tell CreateAttribute ( ) the prefix I want. It's going
to find, that it already knows about this prefix, as long as the namespace
URI you give it matches the namespace URI it knows about for this
prefix.
Derek Harmon

[Dino Chiesa [Microsoft]]

the CreateAttribute (string,string) method takes
a qualified name and a namespace URI.

http://msdn.microsoft.com/library/en...buteTopic2.asp

NOT a prefix.
in other words, THIS

XmlAttribute wsName =
m_XmlDoc.Create Attribute("Name ",
"urn:schema s-microsoft-com:office:spre adsheet");

NOT THIS:

m_XmlDoc.Create Attribute("Name ", "ss");
-Dino
"Krishna Tulasi via .NET 247" <an*******@dotn et247.com> wrote in message
news:OA******** ******@TK2MSFTN GP12.phx.gbl...

Hi,

I am having trouble with creation of XML programmaticall y using .NET. Specifically Im trying to create an element which looks like below and
insert into an existing xml doc: <Worksheet ss:Name="TKCShe et1">
</Worksheet>

The existing xml doc is:

<?xml version="1.0"?>
<?mso-application progid="Excel.S heet"?>
<Workbook xmlns="urn:sche mas-microsoft-com:office:spre adsheet"
xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:html="htt p://www.w3.org/TR/REC-html40">

</Workbook>

I had no problem using LoadXml() to read this existing xml into m_XmlDoc.

But the code I am using for creating that Worksheet node (as explained above):
// add new worksheet xml node at the end of the document
XmlElement wsNode = m_XmlDoc.Create Element("Worksh eet");

XmlAttribute wsName = m_XmlDoc.Create Attribute("ss:N ame");
//XmlAttribute wsName = m_XmlDoc.Create Attribute("ss", "Name", XmlNsMgr.Lookup Namespace("ss") ); //- this did not work either :(
wsName.Value = ?TKCSheet1?;
wsNode.Attribut es.Append(wsNam e);
m_XmlDoc.Docume ntElement.Appen dChild(wsNode);
But this code gives me:
<Worksheet Name="TKCSheet1 " xmlns="">
</Worksheet>

I want ss:Name NOT just Name, in my xml and also I do NOT want xmlns="" in that element!
Can somebody please help me out here?

Thanks,
Krishna
PS: I know probably using Excel 2003 .NET libraries might be cleaner, but I have limited to get this thing running.

--------------------------------
From: Krishna Tulasi

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>tq30o75pHke +OTwMr4tQXQ==</Id>

[Dino Chiesa [Microsoft]]

the CreateAttribute (string,string) method takes
a qualified name and a namespace URI.

http://msdn.microsoft.com/library/en...buteTopic2.asp

NOT a prefix.
in other words, THIS

XmlAttribute wsName =
m_XmlDoc.Create Attribute("Name ",
"urn:schema s-microsoft-com:office:spre adsheet");

NOT THIS:

m_XmlDoc.Create Attribute("Name ", "ss");
-Dino
"Krishna Tulasi via .NET 247" <an*******@dotn et247.com> wrote in message
news:OA******** ******@TK2MSFTN GP12.phx.gbl...

Hi,

I am having trouble with creation of XML programmaticall y using .NET. Specifically Im trying to create an element which looks like below and
insert into an existing xml doc: <Worksheet ss:Name="TKCShe et1">
</Worksheet>

The existing xml doc is:

<?xml version="1.0"?>
<?mso-application progid="Excel.S heet"?>
<Workbook xmlns="urn:sche mas-microsoft-com:office:spre adsheet"
xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:html="htt p://www.w3.org/TR/REC-html40">

</Workbook>

I had no problem using LoadXml() to read this existing xml into m_XmlDoc.

But the code I am using for creating that Worksheet node (as explained above):
// add new worksheet xml node at the end of the document
XmlElement wsNode = m_XmlDoc.Create Element("Worksh eet");

XmlAttribute wsName = m_XmlDoc.Create Attribute("ss:N ame");
//XmlAttribute wsName = m_XmlDoc.Create Attribute("ss", "Name", XmlNsMgr.Lookup Namespace("ss") ); //- this did not work either :(
wsName.Value = ?TKCSheet1?;
wsNode.Attribut es.Append(wsNam e);
m_XmlDoc.Docume ntElement.Appen dChild(wsNode);
But this code gives me:
<Worksheet Name="TKCSheet1 " xmlns="">
</Worksheet>

I want ss:Name NOT just Name, in my xml and also I do NOT want xmlns="" in that element!
Can somebody please help me out here?

Thanks,
Krishna
PS: I know probably using Excel 2003 .NET libraries might be cleaner, but I have limited to get this thing running.

--------------------------------
From: Krishna Tulasi

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>tq30o75pHke +OTwMr4tQXQ==</Id>