欢迎来到天天文库
浏览记录
ID:34722020
大小:68.68 KB
页数:4页
时间:2019-03-10
《c#向excel文件中导入图像》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、classClass1 { privatevoidtest() { InsertPictureToExcelipt=newInsertPictureToExcel(); ipt.Open(); ipt.InsertPicture("B2",@"C:Excellogo.gif"); ipt.InsertPicture("B8",@"C:Excellogo.gif",120,80); ipt.SaveFile(@"C:ExcelTest.xls");
2、 ipt.Dispose(); } } /// ///注意:使用之前需要引用COM:MicrosoftOffice11.0ObjectLibrary /// classInsertPictureToExcel { privateMicrosoft.Office.Interop.Excel.Applicationm_objExcel=null; privateMicrosoft.Office.Interop.Excel.Workbooksm_objBooks=null;
3、 privateMicrosoft.Office.Interop.Excel._Workbookm_objBook=null; privateMicrosoft.Office.Interop.Excel.Sheetsm_objSheets=null; privateMicrosoft.Office.Interop.Excel._Worksheetm_objSheet=null; privateMicrosoft.Office.Interop.Excel.Rangem_objRange=null; privateobjectm_objOp
4、t=System.Reflection.Missing.Value; publicvoidOpen() { this.Open(String.Empty); } ///功能:实现Excel应用程序的打开 /// name="TemplateFilePath"模板文件物理路径 publicvoidOpen(stringTemplateFilePath) { //打开对象 m_objExcel=newMic
5、rosoft.Office.Interop.Excel.Application(); m_objExcel.Visible=false; m_objExcel.DisplayAlerts=false; if(m_objExcel.Version!="11.0") { MessageBox.Show("您的Microsoft.Office.Interop.Excel 版本不是11.0(Office2003),操作可能会出现问题。"); m_objExce
6、l.Quit();return; } m_objBooks=(Microsoft.Office.Interop.Excel.Workbooks)m_objExcel.Workbooks; if(TemplateFilePath.Equals(String.Empty)) { m_objBook=(Microsoft.Office.Interop.Excel._Workbook)(m_objBooks.Add(m_objOpt)); } el
7、se { m_objBook=m_objBooks.Open(TemplateFilePath,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt,m_objOpt); } m_
此文档下载收益归作者所有