计算机充电网
 


  利用C#向Excel中插入图片(报表)  
编辑:网络小飞  来源:计算机充电网  发表时间:2008-03-25  被查阅【】次<% Else %><% End If %>
Google
")
      {
        MessageBox.Show("您的 Excel 版本不是 11.0 (Office 2003),操作可能会出现问题。");
        m_objExcel.Quit();
        return;
      }

      m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
      if (TemplateFilePath.Equals(String.Empty))
      {
        m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
      }
      else
      {
        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_objSheets = (Excel.Sheets)m_objBook.Worksheets;
      m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
      m_objExcel.WorkbookBeforeClose += new Excel.AppEvents_WorkbookBeforeCloseEventHandler(m_objExcel_WorkbookBeforeClose);
    }

    private void m_objExcel_WorkbookBeforeClose( Excel.Workbook m_objBooks, ref bool _Cancel )
    {
      MessageBox.Show("保存完毕!");
    }

    /// <summary>
    /// 将图片插入到指定的单元格位置。
    /// 注意:图片必须是绝对物理路径
    /// </summary>
    /// <param name="RangeName">单元格名称,例如:B4</param>
    /// <param name="PicturePath">要插入图片的绝对路径。</param>
    public void InsertPicture( string RangeName, string PicturePath )
    {
      m_objRange = m_objSheet.get_Range(RangeName, m_objOpt);
      m_objRange.Select();
      Excel.Pictures pics =

[1] [2[3] [4] 

返回顶部】【 】【关闭窗口
  上篇文章:C#+Office 2003实现对Excel文件的操控   下篇文章:优秀程序员的两大要素:懒 + 笨
计算机充电网 为您服务 关于本站 免责声明 法律法规 网址之家 便民查询 本站地图
 
Copyright © 72598.COM All Rights Reserved. 
E-mail:admin@72598.com QQ:360107618
粤ICP备06034384号