using?System;
using?System.Collections.Generic;
using?System.Text;
using?Excel;
using?System.Reflection;
using?System.Threading;

namespace?Qcd.Common.Tools
{
????///?

????///?操作excel
????///?

????public?class?oprationExcel
????{
????????public?Excel.Application?m_objExcel?=?null;//Excel的工作環境
????????public?Excel._Workbook?m_objBook?=?null;//工作簿對象
????????public?Excel.Sheets?m_objsheets?=?null;//工作表集合
????????public?Excel._Worksheet?m_objSheet?=?null;//活動工作表
????????public?Excel.Range?m_objRange?=?null;//選擇單元格

????????//定義操作圖形的公有成員變量
????????private?Excel._Chart?m_objChart?=?null;
????????private?Excel.ChartGroup?m_objChartGroup?=?null;
????????private?Excel.Series?m_objSeries?=?null;

????????public?object?m_objOpt?=?System.Reflection.Missing.Value;//缺省值

????????//連接指定excel文件的方法
????????#region?打開excel文件的方法
????????//根據工作薄的名字，選擇工作對象
????????public??void?connectionExcel（string?excelfilename）
????????{
????????????if?（excelfilename==““）
????????????{
????????????????excelfilename=@“d:\dotest\texcel.xls“;
????????????}

????????????try
????????????{
????????????????m_objExcel?=?new?Excel.Application（）;

????????????????//m_objBook?=?m_objExcel.Workbooks.Open（excelfilename?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_objBook?=?m_objExcel.Workbooks.Open（excelfilename?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=m_objBook.Worksheets;

????????????????m_objSheet=（_Worksheet）m_objsheets.get_Item（1）;

????????????????


????????????}
????????????catch（Exception?ex）
????????????{
????????????????
????????????}
????????}
????????//根據工作薄的名字，工作表的序號選擇工作對象
????????public?void?connectionExcel（string?excelfilenameint?sheet_No）
????????{
????????????if?（excelfilename?==?““）
????????????{
????????????????excelfilename?=?@“d:\dotest\texcel.xls“;
????????????}

????????????try
????????????{
????????????????m_objExcel?=?new?Excel.Application（）;

????????????????//m_objBook?=?m_objExcel.Workbooks.Open（excelfilename?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_objBook?=?m_objExcel.Workbooks.Open（excelfilename?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?=?m_objBook.Worksheets;

????????????????m_objSheet?=?（_Worksheet）m_objsheets.get_Item（sheet_No）;




????????????}
????????????catch?（Exception?ex）
????????????{

????????????}
????????}
????????#endregion

????????//關閉所有的連接，清空內存的方法
????????public??void?closeExcel（）
????????{
????????????try
????????????{
????????????????m_objBook.Close（m_objOpt?m_objOpt?m_objOpt）;

???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????14367??2009-03-26?00:03??OprationExcel.cs

?????文件???????8146??2009-03-26?16:55??Print.cs

-----------?---------??----------?-----??----

????????????????22513????????????????????2