資源簡介
讀取EXCEL文檔顯示在winfrom中(可以讀出每一個sheet)
代碼片段和文件信息
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個文件信息
- 上一篇:最短路徑搜索蟻群算法
- 下一篇:國標軟件工程標準文檔格式+案例文檔
評論
共有 條評論