@H_301_0@C# 的代码

@H_301_0@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.VisualStu<a href="/tag/dio/" target="_blank" class="keywords">dio</a>.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 设计器<a href="/tag/shengcheng/" target="_blank" class="keywords">生成</a>的<a href="/tag/daima/" target="_blank" class="keywords">代码</a> /// <summary> /// 设计器<a href="/tag/zhichi/" target="_blank" class="keywords">支持</a>所需的<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a> - 不要 /// 使用<a href="/tag/daima/" target="_blank" class="keywords">代码</a>编辑器<a href="/tag/xiugai/" target="_blank" class="keywords">修改</a>此<a href="/tag/fangfa/" target="_blank" class="keywords">方法</a>的<a href="/tag/neirong/" target="_blank" class="keywords">内容</a>。 /// </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; Message<a href="/tag/Box/" target="_blank" class="keywords">Box</a>.Show(sh.Name); } #endregion } }

@H_301_0@VB.NET的代码

@H_301_0@Public Class ThisWorkbook Private Sub ThisWorkbook_NewSheet(ByVal Sh As Object) Handles Me.NewSheet Message<a href="/tag/Box/" target="_blank" class="keywords">Box</a>.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

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

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

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

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

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