1、项目,右击 引用——添加引用(COM组件,需要安装office才有)
2、程序,添加引用
3、类,添加代码[DllImport("User32.dll", CharSet = CharSet.Auto)]
4、初始化 Excel.Application EApp; //Excel应用程序 Excel.Workbook EWBook; //Excel文嘲汲萝镗档 Excel.Worksheet WSheet; EApp = new Excel.ApplicationClass();
5、新建表 object nothing = Missing.Value; EWBook = EApp.Workbooks.Add(nothing); WSheet = EWBook.Worksheets[1] as Excel.Worksheet;
6、保存工作簿WSheet.SaveAs(EPath, Missing.Value, Missi艘绒庳焰ng.Value, Missing.Value, Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);EWBook.Save();