1 /// <summary>

 2         /// 将同名Excel分组

 3         /// </summary>

 4         void MoveFile()

 5         {

 6             //改为你自己的路径

 7             string path = @"C:\Users\Reasonable\Desktop\table";

 8             DirectoryInfo root = new DirectoryInfo(path);

 9             FileInfo[] files = root.GetFiles();

10

11             Regex fileRegex = new Regex(@".+(?=\()");

12

13             foreach (var file in files)

14             {

15                 var fileName = fileRegex.Match(file.Name).ToString();

16

17                 var targetPath = $@"{path}\{fileName}";

18

19                 //以文件名创建子目录

20                 if (!Directory.Exists(targetPath))

21                 {

22                     Directory.CreateDirectory(targetPath);

23                 }

24

25                 file.MoveTo(Path.Combine(targetPath, file.Name));

26             }

27

28             Console.Read();

29         }

30     }

 1 /// <summary>

 2         /// 多个excel合并

 3         /// </summary>

 4         void MergeExcel()

 5         {

 6             //改为你自己的路径

 7             string path = @"C:\Users\Reasonable\Desktop\table";

 8             DirectoryInfo root = new DirectoryInfo(path);

 9             //获取所有子目录

10             var dires = root.GetDirectories();

11             foreach (var dir in dires)

12             {

13                 Excel.Application app = new Excel.Application();

14                 Excel._Workbook result = app.Workbooks.Add();

15                 //获取子目录的文件

16                 FileInfo[] files = dir.GetFiles();

17

18                 foreach (var file in files)

19                 {

20                     Excel._Workbook wb1 = app.Workbooks.Open(Path.GetFullPath(file.FullName));

21                     foreach (Excel._Worksheet each in wb1.Sheets)

22                     {

23                         each.Copy(result.Worksheets[1]);

24                     }

25                     wb1.Close();

26                 }

27                 result.SaveAs($@"{dir.FullName}\new.xlsx");

28                 app.Quit();

29             }

30         }