易截截图软件、单文件、免安装、纯绿色、仅160KB

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

一、插图的类(含2方法)
1using System;
2using System.Collections.Generic;
3using System.Text;
4//using Excel = Microsoft.Office.Interop.Excel;
5using Excel;
6using System.Windows.Forms;
7
8
9namespace ExcelReport
10{
11 class InsertPicToExcel
12 {
13 /**//// <summary>
14 /// 打开没有模板的操作。
15 /// </summary>
16 public void Open()
17 {
18 this.Open(String.Empty);
19 }
20
21 /**//// <summary>
22 /// 功能:实现Excel应用程序的打开
23 /// </summary>
24 /// <param name="TemplateFilePath">模板文件物理路径</param>
25 public void Open(string TemplateFilePath)
26 {
27 //打开对象
28 m_objExcel = new Excel.Application();
29 m_objExcel.Visible = false;
30 m_objExcel.DisplayAlerts = false;
31
32 if (m_objExcel.Version != "11.0")
33 {
34 MessageBox.Show("您的 Excel 版本不是 11.0 (Office 2003),操作可能会出现问题。");
35 m_objExcel.Quit();
36 return;
37 }
38
39 m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
40 if (TemplateFilePath.Equals(String.Empty))
41 {
42 m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
43 }
44 else
45 {
46 m_objBook = m_objBooks.Open(TemplateFilePath, m_objOpt, m_objOpt, m_objOpt, m_objOpt,
47 m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
48 }
49 m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
50 m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
51 m_objExcel.WorkbookBeforeClose += new Excel.AppEvents_WorkbookBeforeCloseEventHandler(m_objExcel_WorkbookBeforeC


相关文档:

C#调用 win32遍历win桌面控件的算法

private static int level=0
public static int FindGUILike(ref int hWndArray,int hWndStart,ref string windowText,ref string className,ref string parentText)
{
int hwnd=0;
int r=0;
StringBuilder sWindowText=new StringBuilder();
StringBuilder sClassname=new StringBuilder();
StringBuilder sParentT ......

c#利用winapi遍历桌面控件算法

public enum GUIInfoType
{
     guiText.
     guiTextClass,
     guiTextParent,
     guiTextClassParent,
}
private static int level=0
public static int FindGUILike(ref int hWndArray,int hWndStart,ref string window ......

[笔记]C#实现动态编译

今天看了我的老师钟声的书《Java程序员上班那点儿事》,其中有一段关于Java实现动态编译的代码使我很受启发,决定在.NET中尝试一下。
引入下列命名空间:
using System.CodeDom;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.Diagnostics;
C#代码:
     &n ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号