using?System.Collections;
using?System.Collections.Generic;
using?UnityEngine;
using?System.Data;
using?System.IO;
using?Excel;

public?class?DoExcel?{
????public?static?DataSet?ReadExcel（string?path）
????{
????????FileStream?stream?=?File.Open（path?FileMode.Open?FileAccess.Read?FileShare.Read）;
????????IExcelDataReader?excelReader?=?ExcelReaderFactory.CreateOpenxmlReader（stream）;
????????DataSet?result?=?excelReader.AsDataSet（）;
????????excelReader.Close（）;
????????return?result;

????}

????public?static?List?Load（string?path）
????{
????????List?_data?=?new?List（）;
????????DataSet?resultds?=?ReadExcel（path）;
????????int?column?=?resultds.Tables[0].Columns.Count;
????????int?row?=?resultds.Tables[0].Rows.Count;
????????Debug.LogWarning（column?+?“??“?+?row）;
????????for（int?i=1;i????????{
????????????DepenceTableData?temp_data;
????????????temp_data.instruct?=?resultds.Tables[0].Rows[i][0].ToString（）;
????????????temp_data.word?=?resultds.Tables[0].Rows[i][1].ToString（）;
????????????Debug.Log（temp_data.instruct?+?“??“?+?temp_data.word）;
????????????_data.Add（temp_data）;
????????}
????????return?_data;
????}

}

public?struct?DepenceTableData
{
????public?string?word;
????public?string?instruct;
}

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

????.......???????493??2016-02-24?18:10??ExcelReadWrite\.gitignore

????.......????121856??2016-02-24?18:10??ExcelReadWrite\.vs\ExcelReadWrite\v14\.suo

?????文件???????8104??2017-06-08?16:30??ExcelReadWrite\Assembly-CSharp-Editor.csproj

?????文件???????6440??2017-06-08?17:04??ExcelReadWrite\Assembly-CSharp.csproj

?????文件??????17408??2017-06-08?16:57??ExcelReadWrite\Assets\Data\Test2003.xls

????..A..H.???????174??2017-06-08?16:58??ExcelReadWrite\Assets\Data\Test2003.xls.meta

?????文件???????8600??2017-06-08?16:39??ExcelReadWrite\Assets\Data\Test2007.xlsx

????..A..H.???????174??2017-06-08?16:32??ExcelReadWrite\Assets\Data\Test2007.xlsx.meta

????..A..H.???????191??2017-06-08?16:10??ExcelReadWrite\Assets\Data.meta

????I.A....?????24856??2017-06-08?16:38??ExcelReadWrite\Assets\main.unity

????..A..H.???????174??2017-06-08?14:36??ExcelReadWrite\Assets\main.unity.meta

????.......???1068032??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\EPPlus.dll

????.....H.???????467??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\EPPlus.dll.meta

????.......?????68608??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\Excel.dll

????.....H.???????467??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\Excel.dll.meta

?????文件?????680448??2015-10-20?17:45??ExcelReadWrite\Assets\Plugins\I18N.CJK.dll

????..A..H.???????486??2017-06-08?16:50??ExcelReadWrite\Assets\Plugins\I18N.CJK.dll.meta

?????文件??????31744??2015-10-20?17:45??ExcelReadWrite\Assets\Plugins\I18N.dll

????..A..H.???????486??2017-06-08?16:50??ExcelReadWrite\Assets\Plugins\I18N.dll.meta

?????文件??????32256??2015-10-20?17:45??ExcelReadWrite\Assets\Plugins\I18N.Other.dll

????..A..H.???????486??2017-06-08?16:50??ExcelReadWrite\Assets\Plugins\I18N.Other.dll.meta

?????文件?????171008??2015-10-20?17:45??ExcelReadWrite\Assets\Plugins\I18N.Rare.dll

????..A..H.???????486??2017-06-08?16:50??ExcelReadWrite\Assets\Plugins\I18N.Rare.dll.meta

?????文件??????65536??2013-03-12?23:55??ExcelReadWrite\Assets\Plugins\I18N.West.dll

????..A..H.???????486??2017-06-08?16:50??ExcelReadWrite\Assets\Plugins\I18N.West.dll.meta

????.......????192512??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\ICSharpCode.SharpZipLib.dll

????.....H.???????467??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\ICSharpCode.SharpZipLib.dll.meta

????.......????856064??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\System.Data.dll

????.....H.???????467??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins\System.Data.dll.meta

????.....H.???????191??2016-02-24?18:10??ExcelReadWrite\Assets\Plugins.meta

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