C#操作Excel相关方法总结

0.导入命名空间: using Microsoft.Office.Core; using Microsoft.Office.Interop.Excel; using System.IO; using System.Reflection; 1.如何打开已有excel文档,或者创建一个新的excel文档 Application app = new Application(); Workbooks wbks = app.Workbooks; _Workbook _wbk = wbks.Add(xxx); 若打开已有excel,把“xxx”替换成该excel的文件路径; 注:若新建一个excel文