VSTO ExcelTemplate 如何做激活工作表程序,类似VBA中工作表Worksheet_Activate

aieh

求助:  想用 VSTO C# 做个 Excel工作簿模板,举例如下工作簿有多个工作表,如何做当激活Sheet1时,就在单元格Cells[1, 1] 录入当前日期时间?
下面的代码,只是实现在工作簿打开时执行,当切换到其他工作表后再切换回Sheet1时没有更新,如何做到切换时可以更新?
请各位指教,谢谢!


using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using Microsoft.VisualStudio.Tools.Applications.Runtime;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;

namespace ExcelTemplate2
{
    public partial class Sheet1
    {
        private void Sheet1_Startup(object sender, System.EventArgs e)
        {
            this.Cells[1, 1] = DateTime.Now;
        }
    }  
}

phsu

用工作簿的工作表激活事件處理。
Private EventDel_SheetActivate As Excel.AppEvents_SheetActivateEventHandler

Private Sub ThisAddIn_Startup() Handles Me.Startup
     EventDel_SheetActivate = New Excel.AppEvents_SheetActivateEventHandler(AddressOf WorkbookSheetActivate)
     AddHandler Globals.ThisAddIn.Application.SheetActivate, EventDel_SheetActivate
End Sub

Private Sub WorkbookSheetActivate(sht As Object)
    If sht.Name = "Sheet1" Then
        sht.Cells(1,1).value = DateTime.Now
    End If
End Sub