'ss' is an undeclared namespace."

[ashishkumarrai]

I am trying to insert a node (Row) in excel xml file. While trying to create a node and assign it to XMLDocumentFragment object it throws an error " 'ss' is an undeclared namespace." to me.

XmlDocumentFragment docFrag = this.document.CreateDocumentFragment();

docFrag.InnerXml = @" <Row ss:AutoFitHeight=""0"" ss:Height=""127.5"">
<Cell ss:StyleID=""s31""><Data ss:Type=""String"">COA</Data><NamedCell
ss:Name=""_FilterDatabase""/><NamedCell ss:Name=""Print_Area""/></Cell>
</Row>";

I have tried to do the following but this doesn't seems to help:

XmlNamespaceManager ns = new XmlNamespaceManager(document.NameTable);
ns.AddNamespace(String.Empty, "urn:schemas-microsoft-com:office:spreadsheet");
ns.AddNamespace("ss", "urn:schemas-microsoft-com:office:spreadsheet");

What can be the way out of this problem?

Thanks in advance..

Ashish

[jkmyoung]

You won't be just able to set the InnerXML property because it needs the context of the Namespace Manager. Unfortunately MSDN is down at the moment. However, I would recommend using a function that builds the DocumentFragment from a string, and takes the Namespace Manager as the 2nd argument. Hopefully you can find the function from an autosuggest feature in your development tool.

[sbdavis]

I have the same problem. Please post sample code that will build a DocumentFragment using the Namespace Manager. I am working with VisualStudio, presentationml, and C#.

[jkmyoung]

I do not blame you for being confused. The implementation is horribly, horribly obfuscated.

NameTable nameTable = new NameTable();
 
XmlNamespaceManager namespaceManager = new XmlNamespaceManager(nameTable);
 
namespaceManager.AddNamespace("ss", "Excelsomethingsomething");
 
String xmlString = "<Row ss:AutoFitHeight=""0"" ss:Height=""127.5"">
<Cell ss:StyleID=""s31""><Data ss:Type=""String"">COA</Data><NamedCell
ss:Name=""_FilterDatabase""/><NamedCell ss:Name=""Print_Area""/></Cell>
</Row>"
XmlReaderSettings readerSettings = new XmlReaderSettings();
 
readerSettings.ConformanceLevel = ConformanceLevel.Fragment;
 
XmlParserContext parserContext = new XmlParserContext(nameTable, namespaceManager, writer.XmlLang, writer.XmlSpace);
 
XmlReader reader = XmlReader.Create(new StringReader(xmlString), readerSettings, parserContext))
 

Then use XMLDocument.Load(XMLReader)
http://msdn.microsoft.com/en-us/libr...v=VS.100).aspx