C#插入图片到Excel中

43720938

于 2010-09-12 10:38:00 发布

阅读量599

点赞数 1

分类专栏： C# 文章标签： excel c# exception object image string

本文链接：https://blog.youkuaiyun.com/43720938/article/details/5878725

版权

C# 专栏收录该内容

11 篇文章

订阅专栏

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;
}

}