C#如何新建Excel

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, Missing.Value, Missing.Value, Missing.Value,Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);EWBook.Save();