VSTO 列出所有EXCEL工作表的名称

    private void button1_Click(object sender, EventArgs e)
    {
        StringBuilder sb = new StringBuilder();
        foreach (Excel.Worksheet sht in Globals.ThisWorkbook.Worksheets)
        {
            sb.Append(sht.Name);
            sb.Append("\n");
        }
        MessageBox.Show(sb.ToString(), "All sheets");
    }
posted @ 2010-03-18 21:44  RobinLao  阅读(931)  评论(0编辑  收藏  举报