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
相关文档:
在asp.net项目中的一个把数据 导出Excel表格的小事件如下:
protected void ibnOut_Click(object sender, ImageClickEventArgs e)//导出Excel按钮的点击事件
{
GridView2.DataSource = dt ......
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 ......
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);
......
在net中有一个至关重要的关键字,那就是using
using一般有着以下几种用法:
1、直接引入命名空间
a、using System ,这个是最常用的,就是using+命名空间,这样就可以直接使用命名空间中的类型,而免去了使用详细的命名空间
b、使用全限定名
不用使用using System;直接在程序中调用System.Console.WriteLine("Hello ......
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 ......