获取Excel中Undo按钮的项目

最新推荐文章于 2021-04-27 14:49:04 发布

勾吴江南

最新推荐文章于 2021-04-27 14:49:04 发布

阅读量1.5k

点赞数

本文链接：https://blog.csdn.net/TX_OfficeDev/article/details/8124480

版权

Office Development 同时被 3 个专栏收录

134 篇文章 0 订阅

订阅专栏

63 篇文章 0 订阅

订阅专栏

Excel 2010

25 篇文章 0 订阅

订阅专栏

在VSTO中我们可以通过以下代码来获取Undo按钮的列表：

        private static Office.CommandBars getCommandBars()
        {
            return (Office.CommandBars)Globals.ThisWorkbook.Application.GetType().InvokeMember("CommandBars"
                , System.Reflection.BindingFlags.GetProperty,
                null,
                Globals.ThisWorkbook.Application,
                null,
                System.Globalization.CultureInfo.InvariantCulture);
        }

        private static string getLastUndo()
        {
            string result = string.Empty;
            Office.CommandBars oCommandBars = getCommandBars();
            Office.CommandBar oCommandBar = oCommandBars["Standard"];
            Office.CommandBarControl oCommandBarControl = (Office.CommandBarControl)oCommandBar.Controls[14];
            MessageBox.Show(oCommandBarControl.Caption);
            MessageBox.Show(oCommandBarControl.accChildCount.ToString());
            try
            {
                if (oCommandBarControl is Office.CommandBarComboBox)
                {
                    Office.CommandBarComboBox ocbcb = (Office.CommandBarComboBox)oCommandBarControl;
                    for (int i = 1; i < oCommandBarControl.accChildCount; i++)
                    {
                        MessageBox.Show(ocbcb.get_List(i));
                    }
                }
                else
                {
                    MessageBox.Show("No");
                }
            }catch(Exception ex){
                MessageBox.Show(ex.Message);
            }
            return result;
        }

欢迎访问《许阳的红泥屋》