VSTO在EXCEL里列出所有文件夹及其文件


int i = 0, k = 0;
DirectoryInfo dir = new DirectoryInfo(@"c:\windows");
DirectoryInfo[] dirs = dir.GetDirectories();
foreach (DirectoryInfo folder in dirs)
{
i++;
this.Range["a" + i, missing].Value2 = folder.Name;
}
FileInfo[] files = dir.GetFiles();
foreach (FileInfo file in files)
{
k++;
this.Range["b" + k, missing].Value2 = file.Name;
}
posted @ 2010-03-22 23:25  RobinLao  阅读(592)  评论(0编辑  收藏  举报