public static Office.CustomXMLNode GetCustomXmlNode(Excel.Workbook workbook, string xNameSpace,
string xPath)
{
Office.CustomXMLParts ps = workbook.CustomXMLParts;
ps = ps.SelectByNamespace(xNameSpace);
for (int i = 1; i <= ps.Count; i++)
{
Office.CustomXMLPart p = ps[i];
var nsmgr = p.NamespaceManager;
nsmgr.AddNamespace("x", xNameSpace);
Office.CustomXMLNode node = p.SelectSingleNode(xPath);
if (node != null)
{
return(node);
}
}
return(null);
}
public static int CountXmlNamespace(Excel.Workbook workbook, string xNameSpace)
{
Office.CustomXMLParts ps = workbook.CustomXMLParts;
ps = ps.SelectByNamespace(xNameSpace);
return(ps.Count);
}