如果使用Excel2003,需要添加.NET库的Microsoft.Office.Interop.Excel 版本11.0,引用栏会出现Microsoft.Office.Interop.Excel
然后添加COM库,Microsoft Office 11.0 Object Library,引用栏中会出现Microsoft.Office.Core
另外如果添加 C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE,则引用栏中会出现Excel和Microsoft.Office.Core
调用方法
MengXianhui.Utility.ExcelReport.InsertPictureToExcel ipt = new MengXianhui.Utility.ExcelReport.InsertPictureToExcel();
ipt.Open();
ipt.InsertPicture("B2", @"C:\Excellogo.gif");
ipt.InsertPicture("B8", @"C:\Excellogo.gif",120,80);
ipt.SaveFile(@"C:\ExcelTest.xls");
ipt.Dispose();
简单包装的类using System; using System.Windows.Forms; using Excel = Microsoft.Office.Interop.Excel; namespace MengX