[导入]C#向Excel报表中插入图片的2种方法

如果使用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