using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.OleDb;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;

namespace?讀取excel到datagridview
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{

????????}
????????///?

????????///?選擇文件，并且讀取excel中sheet
????????///?

????????///?
????????///?
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
??????
?????????try
?????????{
????????????//獲取Excel文件路徑和名稱
????????????OpenFileDialog?odXls?=?new?OpenFileDialog（）;
????????????//?指定相應的打開文檔的目錄
????????????odXls.InitialDirectory?=?“C://“;
????????????//?設置文件格式
????????????odXls.Filter?=?“Excel?files?（*.xls）|*.xls|Excel?files?（*.xlsx）|*.xls

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

?????文件??????12288??2015-09-19?22:46??讀取excel到datagridview\讀取excel到datagridview\bin\Debug\讀取excel到datagridview.exe

?????文件??????26112??2015-09-19?22:46??讀取excel到datagridview\讀取excel到datagridview\bin\Debug\讀取excel到datagridview.pdb

?????文件??????22984??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\bin\Debug\讀取excel到datagridview.vshost.exe

?????文件????????490??2012-06-02?22:34??讀取excel到datagridview\讀取excel到datagridview\bin\Debug\讀取excel到datagridview.vshost.exe.manifest

?????文件???????3517??2015-09-19?23:06??讀取excel到datagridview\讀取excel到datagridview\Form1.cs

?????文件???????5661??2015-09-19?23:06??讀取excel到datagridview\讀取excel到datagridview\Form1.Designer.cs

?????文件???????5817??2015-09-19?23:06??讀取excel到datagridview\讀取excel到datagridview\Form1.resx

?????文件????????863??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6920??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????1202??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.csproj.FileListAbsolute.txt

?????文件????????975??2015-09-19?21:30??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.csproj.GenerateResource.Cache

?????文件???????2209??2015-09-19?21:20??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.csprojResolveAssemblyReference.cache

?????文件??????12288??2015-09-19?22:46??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.exe

?????文件????????180??2015-09-19?22:15??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.Form1.resources

?????文件??????26112??2015-09-19?22:46??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.pdb

?????文件????????180??2015-09-19?22:15??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\讀取excel到datagridview.Properties.Resources.resources

?????文件????????507??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\Program.cs

?????文件???????1372??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\Properties\AssemblyInfo.cs

?????文件???????2904??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\Properties\Resources.Designer.cs

?????文件???????5612??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\Properties\Resources.resx

?????文件???????1113??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\Properties\Settings.Designer.cs

?????文件????????249??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\Properties\Settings.settings

?????文件???????3762??2015-09-19?22:15??讀取excel到datagridview\讀取excel到datagridview\讀取excel到datagridview.csproj

?????文件????????968??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview.sln

????..A..H.?????36864??2015-09-19?23:06??讀取excel到datagridview\讀取excel到datagridview.v11.suo

?????目錄??????????0??2015-09-19?21:00??讀取excel到datagridview\讀取excel到datagridview\obj\Debug\TempPE

?????目錄??????????0??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\bin\Debug

?????目錄??????????0??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\obj\Debug

?????目錄??????????0??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\bin

?????目錄??????????0??2015-09-19?23:04??讀取excel到datagridview\讀取excel到datagridview\obj

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