NewSheet事件的疑惑与郁闷

C# 的代码

using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using System.Xml.Linq; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; namespace ExcelWorkbook1 { public partial class ThisWorkbook { private void ThisWorkbook_Startup(object sender, System.EventArgs e) { } private void ThisWorkbook_Shutdown(object sender, System.EventArgs e) { } #region VSTO 设计器生成的代码 /// <summary> /// 设计器支持所需的方法 - 不要 /// 使用代码编辑器修改此方法的内容。 /// </summary> private void InternalStartup() { ((Excel.AppEvents_Event)ThisApplication).WorkbookNewSheet += new Microsoft.Office.Interop.Excel.AppEvents_WorkbookNewSheetEventHandler(ThisWorkbook_WorkbookNewSheet); this.Startup += new System.EventHandler(ThisWorkbook_Startup); this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown); } public void ThisWorkbook_WorkbookNewSheet(Microsoft.Office.Interop.Excel.Workbook Wb,object Sh) { Excel.Worksheet sh = Application.ActiveSheet as Excel.Worksheet; MessageBox.Show(sh.Name); } #endregion } }

 

 

VB.NET的代码

Public Class ThisWorkbook Private Sub ThisWorkbook_NewSheet(ByVal Sh As Object) Handles Me.NewSheet MessageBox.Show(Sh.name) End Sub Private Sub ThisWorkbook_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup End Sub Private Sub ThisWorkbook_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown End Sub End Class

 

 

令我郁闷的是，C#的object Sh中的Sh不可以直接调用Name属性，需要先new一个sh为ActiveSheet，然后调用sh的Name属性，更郁闷的是直接用MessageBox.Show(ActiveSheet.Name)的话还报错。

而VB.NET的ByVal Sh As Object中的Sh可以直接调用Name属性。

KAO，同样是object，差别咋就那么大捏。

由此可以看出，C#比VB.NET的编码更加严格，总需要先定义给变量一个明确的类型，才能调用属性。

琢磨出这两段代码和区别花了我小半天时间，有和我一样从VBA直接转过来的童鞋今后可要注意了哦。