易截截图软件、单文件、免安装、纯绿色、仅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#中将控件数据导出Excel

在asp.net项目中的一个把数据 导出Excel表格的小事件如下:
 protected void ibnOut_Click(object sender, ImageClickEventArgs e)//导出Excel按钮的点击事件
        {
              GridView2.DataSource = dt ......

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#和UDP SOCKET广播

server:
Socket sock = new Socket(AddressFamily.InterNetwork, SocketType.Dgram,ProtocolType.Udp);
IPEndPoint iep1 = new IPEndPoint(IPAddress.Broadcast, 9050);//255.255.255.255
IPEndPoint iep2 = new IPEndPoint(IPAddress.Parse("192.168.1.255"), 9050);
......

c# using 关键字的用法


在net中有一个至关重要的关键字,那就是using
using一般有着以下几种用法:
1、直接引入命名空间
a、using System ,这个是最常用的,就是using+命名空间,这样就可以直接使用命名空间中的类型,而免去了使用详细的命名空间
b、使用全限定名
不用使用using System;直接在程序中调用System.Console.WriteLine("Hello ......

C#利用winapi捕捉鼠标操作控件的句柄

public struct POINTAPI
{
   public int x;
   public int y;
}
public static void GetWindowfromPoint(ref int hwnd,ref StringBuilder winText,ref StringBuilder clsName,ref StringBuilder pText)
{
  int parentHandle=0;
  int maxLen=128;
  POINTAPI pnt = new ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号