C#如何新建Excel

时间:2024-10-13 15:57:26

1、项目,右击 引用——添加引用(COM组件,需要安装office才有)

C#如何新建Excel

2、程序,添加引用

C#如何新建Excel

3、类,添加代码[DllImport("User32.dll", CharSet = CharSet.Auto)]

C#如何新建Excel

4、初始化 Excel.Application EApp; //Excel应用程序 Excel.Workbook EWBook; //Excel文嘲汲萝镗档 Excel.Worksheet WSheet; EApp = new Excel.ApplicationClass();

C#如何新建Excel

5、新建表 object nothing = Missing.Value; EWBook = EApp.Workbooks.Add(nothing); WSheet = EWBook.Worksheets[1] as Excel.Worksheet;

C#如何新建Excel

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();

C#如何新建Excel
© 手抄报圈