列出所有工作表的名称

在sheet1里插入button1，双击输入click事件

 

 

private void button1_Click(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); foreach (Excel.Worksheet sht in Globals.ThisWorkbook.Worksheets) { sb.Append(sht.Name + "/n"); } MessageBox.Show(sb.ToString(),"All sheets"); }