首先我们来实现 列出所有工作表的名称,这个很简单
代码如下:
private void btnShowAllWorksheets_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");
接着我们来实现 列出所有最近打开文件列表的名称
private void btnShowRecentFiles_Click(object sender, EventArgs e)
for (int i = 1; i < this.Application.RecentFiles.Count; i++)
sb.Append(this.Application.RecentFiles[i].Name + "/n");
MessageBox.Show(sb.ToString(),"All RecentFiles");