private static void RemoveCommandBarControls(Application excelApp, XmlNodeList xmlNodes) { foreach (XmlNode childNode in xmlNodes) { if (childNode.Name == "commandBar") { string barName = childNode.Attributes["name"].Value; CommandBar bar = null; for (int i = 1; i <= excelApp.CommandBars.Count; i++) { if (excelApp.CommandBars[i].Name == barName) { bar = excelApp.CommandBars[i]; break; } } if (bar != null) { RemoveControls(bar.Controls, childNode.ChildNodes); if (bar.Controls.Count() == 0) { bar.Delete(); } } } } }
private static void RemoveCommandBarControls(Application excelApp, XmlNodeList xmlNodes) { foreach (XmlNode childNode in xmlNodes) { if (childNode.Name == "commandBar") { string barName; CommandBar bar = GetCommandBarFromIdOrName(excelApp, childNode.Attributes, out barName); if (bar != null) { RemoveControls(bar.Controls, childNode.ChildNodes); if (bar.Controls.Count() == 0) { bar.Delete(); } } } } }