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