c# 使用事件处理程序WorkbookOpen

c# using the event handler WorkbookOpen(c# 使用事件处理程序WorkbookOpen)

问题描述

我正在编写一个 excel 插件，我想在打开工作簿时执行某些代码.这意味着如果他们打开 excel 然后打开工作簿，加载项将执行代码.

I am programming an excel add-in and I want to execute certain code when a workbook is opened. This means that if they open excel and then open a workbook, the add-in will execute the code.

我假设我们必须使用事件处理程序:Application.WokbookOpen

I am assuming we have to use the event handler: Application.WokbookOpen

但我不知道如何应用.

谢谢！

推荐答案

将此添加到 InternalStartUp()

    this.Application.WorkbookOpen += new Excel.AppEvents_WorkbookOpenEventHandler(Application_WorkbookOpen);

然后在打开工作簿时会调用这个函数

And then this function will be called when the workbook is opened

void Application_WorkbookOpen(Excel.Workbook Wb)
{
   //Do something         
}

另外，默认隐藏在ThisAddIn.cs中的#region VSTO生成代码中.

Also, it is hidden in the #region VSTO generated code in ThisAddIn.cs by default.

这篇关于c# 使用事件处理程序WorkbookOpen的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！