using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OleDb;
using?System.Reflection;
using?Microsoft.Office.Interop.Excel;
using?System.Runtime.InteropServices;

/*
?*?軟件名:C#實(shí)現(xiàn)導(dǎo)出EXCEL?
?*?作者:SmallWhite
?*?2009-11-7?23:00
?*?QQ?296326
?*?EMail?smallwhite@yahoo.cn
?*/

namespace?DatagridviewToExcel
{
????public?partial?class?Form1?:?Form
????{
????????System.DateTime?TimeP?=?new?System.DateTime（0）;

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????button2.Enabled?=?false;
????????????button3.Enabled?=?false;
????????}

????????#region?打開文件獲取文件路徑
????????///?

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

????????///?
????????private?string?getPath（）
????????{
????????????//打開一個(gè)文件選擇框

????????????openFileDialog1.title?=?“Excel文件“;
????????????openFileDialog1.FileName?=?““;
????????????openFileDialog1.InitialDirectory?=?Environment.GetFolderPath（Environment.SpecialFolder.MyDocuments）;//為了獲取特定的系統(tǒng)文件夾，可以使用System.Environment類的靜態(tài)方法GetFolderPath（）。該方法接受一個(gè)Environment.SpecialFolder枚舉，其中可以定義要返回路徑的哪個(gè)系統(tǒng)目錄
????????????openFileDialog1.Filter?=?“Excel文件（*.xls）|*.xls“;
????????????openFileDialog1.ValidateNames?=?true;?????//文件有效性驗(yàn)證ValidateNames，驗(yàn)證用戶輸入是否是一個(gè)有效的Windows文件名
????????????openFileDialog1.CheckFileExists?=?true;??//驗(yàn)證路徑有效性
????????????openFileDialog1.CheckPathExists?=?true;?//驗(yàn)證文件有效性



????????????string?strName?=?string.Empty;
????????????if?（openFileDialog1.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????strName?=?openFileDialog1.FileName;
????????????}

????????????if?（strName?==?““）
????????????{
????????????????MessageBox.Show（“沒有選擇Excel文件！無(wú)法進(jìn)行數(shù)據(jù)導(dǎo)入“）;

????????????}

????????????return?strName;
????????}
????????#endregion

????????#region?導(dǎo)入一個(gè)EXCEL表格的數(shù)據(jù)進(jìn)DATASET以進(jìn)行測(cè)試之用
????????///?

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

????????void?loadSouce（）
????????{
????????????try
????????????{

????????????????//連接EXCEL數(shù)據(jù)源
????????????????string?strPath?=?this.getPath（）;
????????????????string?strConn?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?strPath?+?“;Extended?Properties=“?+?“\““?+?“Excel?8.0;HDR=Yes;IMEX=1“?+?“\““;
????????????????OleDbConnection?conn?=?new?OleDbConnection（strConn）;

????????????????conn.Open（）;

????????????????/*
?????????????????如果用戶把sheet表名改了就是報(bào)下面的錯(cuò)：
????????????????‘sheet1$‘?不是一個(gè)有效名稱。請(qǐng)確認(rèn)它不包含無(wú)效的字符或標(biāo)點(diǎn)，且名稱不太長(zhǎng)。?
????????????????如果可以動(dòng)態(tài)獲得Excel中各個(gè)sheet的名稱能動(dòng)態(tài)的選中返回哪個(gè)sheet的數(shù)據(jù)，
????????????????即使用戶更改了名稱也不怕，完全可以把所有sheet的名稱列出來(lái)供用戶選擇:?
????????????????下面就把解決問題的代碼列出來(lái)，主要用到了OleDbConnection.GetOleDbSchemaTable（）方法
?????????????????*/

????????????????//返回Excel的架構(gòu)，包括各個(gè)sheet表的名稱類型，創(chuàng)建時(shí)間和修改時(shí)間等
????????????????System.Data.DataTable?dtSheetName?=?conn.GetOleDb

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件?????217600??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\DatagridviewToExcel.exe

?????文件??????50688??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\DatagridviewToExcel.pdb

?????文件??????14328??2011-11-05?18:17??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\DatagridviewToExcel.vshost.exe

?????文件????????490??2007-07-21?01:33??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\DatagridviewToExcel.vshost.exe.manifest

?????文件????1100392??2007-10-10?09:48??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\Microsoft.Office.Interop.Excel.dll

?????文件??????64088??2007-10-10?09:48??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\Microsoft.Vbe.Interop.dll

?????文件?????223800??2007-10-10?09:48??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Debug\office.dll

?????文件?????217088??2009-11-08?00:58??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\DatagridviewToExcel.exe

?????文件??????32256??2009-11-08?00:58??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\DatagridviewToExcel.pdb

?????文件??????14328??2009-11-08?00:58??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\DatagridviewToExcel.vshost.exe

?????文件????????490??2007-07-21?01:33??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\DatagridviewToExcel.vshost.exe.manifest

?????文件????1100392??2009-11-06?13:36??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\Microsoft.Office.Interop.Excel.dll

?????文件??????64088??2009-11-06?13:36??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\Microsoft.Vbe.Interop.dll

?????文件?????223800??2009-11-06?13:36??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\bin\Release\office.dll

?????文件???????4232??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\DatagridviewToExcel.csproj

?????文件??????21191??2011-11-05?18:15??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\Form1.cs

?????文件???????7581??2009-11-07?23:50??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\Form1.Designer.cs

?????文件?????156236??2009-11-07?23:50??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\Form1.resx

?????文件??????99678??2009-11-07?23:10??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\ICO.ico

?????文件???????7572??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\DatagridviewToExcel.csproj.FileListAbsolute.txt

?????文件????????847??2011-11-05?15:13??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\DatagridviewToExcel.csproj.GenerateResource.Cache

?????文件?????217600??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\DatagridviewToExcel.exe

?????文件?????100244??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\DatagridviewToExcel.Form1.resources

?????文件??????50688??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\DatagridviewToExcel.pdb

?????文件????????180??2011-11-05?21:08??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\DatagridviewToExcel.Properties.Resources.resources

?????文件???????8724??2011-11-05?15:13??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1403??2009-11-08?00:58??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Release\DatagridviewToExcel.csproj.FileListAbsolute.txt

?????文件????????847??2009-11-07?23:50??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Release\DatagridviewToExcel.csproj.GenerateResource.Cache

?????文件?????217088??2009-11-08?00:58??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Release\DatagridviewToExcel.exe

?????文件?????100244??2009-11-07?23:54??Mr_YoungC#導(dǎo)出數(shù)據(jù)到EXCEL方法談\C#導(dǎo)出數(shù)據(jù)到EXCEL方法談（附實(shí)例源碼和超級(jí)無(wú)敵詳細(xì)講解）\DatagridviewToExcel\DatagridviewToExcel\obj\Release\DatagridviewToExcel.Form1.resources

............此處省略73個(gè)文件信息