using?System;
using?System.Data;
using?System.Reflection;
using?System.IO;
using?Microsoft.Office.Core;
using?System.Windows.Forms;
using?Excel?=?Microsoft.Office.Interop.Excel;



namespace?MOAWindows
{
????public?class?ExcelProgress
????{
????????#region?Variables
????????private?Excel.Application?excelApplication?=?null;
????????private?Excel.Workbooks?excelWorkBooks?=?null;
????????private?Excel.Workbook?excelWorkBook?=?null;
????????private?Excel.Worksheet?excelWorkSheet?=?null;
????????private?Excel.Range?excelRange?=?null;//Excel?Range?object多種用途
????????private?Excel.Range?excelCopySourceRange?=?null;//Excel?Range?object
????????private?int?excelActiveWorkSheetIndex;???//活動工作表索引
????????private?string?excelOpenFileName?=?““;??//操作Excel的路徑
????????private?string?excelSaveFileName?=?““;??//保存Excel的路徑
????????#endregion

????????#region?Properties
????????public?int?ActiveSheetIndex
????????{
????????????get
????????????{
????????????????return?excelActiveWorkSheetIndex;
????????????}
????????????set
????????????{
????????????????excelActiveWorkSheetIndex?=?value;
????????????}
????????}
????????public?string?OpenFileName
????????{
????????????get
????????????{
????????????????return?excelOpenFileName;
????????????}
????????????set
????????????{
????????????????excelOpenFileName?=?value;
????????????}
????????}
????????public?string?SaveFileName
????????{
????????????get
????????????{
????????????????return?excelSaveFileName;
????????????}
????????????set
????????????{
????????????????excelSaveFileName?=?value;
????????????}
????????}
????????#endregion

????????///?

????????///?構(gòu)造函數(shù)；
????????///?


????????public?ExcelProgress（）
????????{
????????????excelApplication?=?null;//Excel?Application?object
????????????excelWorkBooks?=?null;//Workbooks
????????????excelWorkBook?=?null;//Excel?Workbook?object
????????????excelWorkSheet?=?null;//Excel?Worksheet?object
????????????ActiveSheetIndex?=?1;???//默認(rèn)值活動工作簿為第一個；設(shè)置活動工作簿請參閱SetActiveWorkSheet（）?
????????}

????????///?

????????///?以excelOpenFileName為模板新建Excel文件
????????///?

????????public?bool?OpenExcelFile（）
????????{
????????????if?（excelApplication?!=?null）?CloseExcelApplication（）;

????????????//檢查文件是否存在
????????????if?（excelOpenFileName?==?““）
????????????{
????????????????throw?new?Exception（“請選擇文件！“）;
????????????}
????????????if?（!File.Exists（excelOpenFileName））
????????????{

????????????????throw?new?Exception（excelOpenFileName?+?“該文件不存在！“）;//該異常如何處理，由什么處理？？？？
????????????}
????????????try
????????????{
????????????????excelApplication?=?new?Excel.ApplicationClass（）;
????????????????excelWorkBooks?=?excelApplication.Workbooks;
????????????????excelWorkBook?=?（（Excel.Workbook）excelWorkBooks.Open（excelOpenFileName?Missing.Value?Missing.Value?Missing.Value?Missing.Value?Missing.Value?Missing.Value?Missing.Value?Missing.Value?Missing.Value?Missing.

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

?????文件????????914??2010-03-16?11:02??MOAWindows\app.config

?????文件?????151552??2010-03-17?11:04??MOAWindows\bin\Debug\AxInterop.OWC11.dll

?????文件??????45056??2010-03-17?11:04??MOAWindows\bin\Debug\AxInterop.SHDocVw.dll

?????文件????1093632??2010-01-31?19:12??MOAWindows\bin\Debug\Interop.Excel.dll

?????文件?????217088??2010-02-10?13:38??MOAWindows\bin\Debug\Interop.Microsoft.Office.Core.dll

?????文件?????131072??2010-03-17?11:04??MOAWindows\bin\Debug\Interop.SHDocVw.dll

?????文件??????57344??2010-02-24?14:14??MOAWindows\bin\Debug\Interop.VBIDE.dll

?????文件?????135168??2010-03-18?10:38??MOAWindows\bin\Debug\MOAWindows.exe

?????文件????????914??2010-03-16?11:02??MOAWindows\bin\Debug\MOAWindows.exe.config

?????文件?????163328??2010-03-18?10:38??MOAWindows\bin\Debug\MOAWindows.pdb

?????文件???????5632??2005-11-11?22:25??MOAWindows\bin\Debug\MOAWindows.vshost.exe

?????文件????????914??2010-03-16?11:02??MOAWindows\bin\Debug\MOAWindows.vshost.exe.config

?????文件????1496576??2008-01-09?08:00??MOAWindows\bin\Debug\shdocvw.dll

?????文件??????27732??2010-03-17?17:00??MOAWindows\bin\Debug\temp.xml

?????目錄??????????0??2010-03-17?17:00??MOAWindows\bin\Debug

????.......?????13277??2010-03-16?10:18??MOAWindows\bin\Debugtemp.xls

?????文件??????23632??2010-03-16?19:52??MOAWindows\bin\Debugtemp.xml

?????目錄??????????0??2010-03-16?19:52??MOAWindows\bin

?????文件??????30350??2010-03-15?16:26??MOAWindows\ExcelProgress.cs

?????文件???????3495??2010-03-15?10:58??MOAWindows\Form1.cs

?????文件???????7692??2010-03-15?10:58??MOAWindows\Form1.Designer.cs

?????文件???????5814??2010-03-15?10:58??MOAWindows\Form1.resx

?????文件??????17173??2010-03-18?11:12??MOAWindows\Form2.cs

?????文件??????12245??2010-03-18?09:57??MOAWindows\Form2.Designer.cs

?????文件??????10995??2010-03-18?09:57??MOAWindows\Form2.resx

?????文件???????9844??2010-03-16?11:23??MOAWindows\MOAWindows.csproj

?????文件???????2705??2010-03-08?20:11??MOAWindows\MSExcle.cs

?????文件?????151552??2010-03-17?11:04??MOAWindows\obj\Debug\AxInterop.OWC11.dll

?????文件??????45056??2010-03-17?11:04??MOAWindows\obj\Debug\AxInterop.SHDocVw.dll

?????文件?????409600??2010-03-05?17:17??MOAWindows\obj\Debug\Interop.Microsoft.Office.Core.dll

............此處省略48個文件信息