获取所选取表名和区域的名称

private void ThisWorkbook_Startup(object sender, System.EventArgs e) { this.SheetSelectionChange += new Microsoft.Office.Interop.Excel.WorkbookEvents_SheetSelectionChangeEventHandler(ThisWorkbook_SheetSelectionChange); } void ThisWorkbook_SheetSelectionChange(object Sh, Microsoft.Office.Interop.Excel.Range Target) { Excel.Worksheet sh = ActiveSheet as Excel.Worksheet; MessageBox.Show("Selection WorkSheet: " +sh.Name + "/n" + "Selection Range: " + Target.get_Address(missing,missing,Excel.XlReferenceStyle.xlA1,missing,missing),"Selection"); }