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); }