C#插入图片到Excel中

private void insertImage()
{
            Excel.Application ThisApplication = new Excel.ApplicationClass();
            Excel.Workbook ThisWorkBook;


string _stFileName = "D://Test.xls";
string _stLOGO = "D://LOGO.bmp";

object missing = System.Reflection.Missing.Value;

try
{
ThisWorkBook = ThisApplication.Workbooks.Open(_stFileName,missing,missing,5,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);

Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];


Excel.Range oRange = (Excel.Range)ThisSheet.Cells[10,1];


Image oImage = Image.FromFile(_stLOGO);
System.Windows.Forms.Clipboard.SetDataObject(oImage,true);
ThisSheet.Paste(oRange,_stLOGO);



ThisWorkBook.Save();
}
catch(Exception oEx)
{ }
finally
{

ThisApplication.Quit();
ThisWorkBook = null;
ThisApplication = null;
}

}

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值