易截截图软件、单文件、免安装、纯绿色、仅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# 代码的 html fragment 生成

测试语法高亮的 C# 代码的 html fragment 生成:
用csdn blog API 发布.
下面是:
public class HtmlWriter
{
   static Dictionary _colors;
   static int _colorNum;
   static StringBuilder _colorString;

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# primer note I

------------------------

Foreach :
优点:
1、不用考虑数组起始索引是几
int[] nArray = new int[100];
// Use "foreach" to loop array
foreach( int i in nArray )
2、对于多维数组操作用foreach非常简便
int[,] nVisited = new int[8,8];
// Use "for" to loop two-dimension array
for( int i = 0; i ......

C#中继承实现父类方法、重写、重载

继承是派生类(子类)去实现(重写<override>、重构<new>)基类(父类)的方法或属性。从而获取在派生类中要实现的功能。
子类调用父类构造方法,在父类中有个实现姓名和年龄的构造方法但是中子类也要实现这样的功能这时子类不用再次去写这个功能只要去调用父类的功能即可。
public class Person
 & ......

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号