目錄
一.DLL插件讀取
1.1.Excel存放位置
1.2.使用示例
1.3.Excel格式
?1.4.輸出顯示?
1.5.所需插件
二.Excel轉(zhuǎn)成Asset文件，再進行讀取
2.1Excel文件存放位置
2.2 編輯模式生成Asset文件，并保存到指定位置?
2.3創(chuàng)建ExcelRead腳本，讀取Excel內(nèi)容
2.4 創(chuàng)建數(shù)據(jù)存儲腳本
2.5? 編輯器生成Asset 與屬性面板詳情
?2.6 Asset數(shù)據(jù)的使用方式
?三:Excel文件轉(zhuǎn)成json 再以json的方式讀取
一.DLL插件讀取
1.1.Excel存放位置
如圖 將命名為cook的excel文件存放在Assets根目錄下
1.2.使用示例
using System.Data;
using System.IO;
using Excel;
using UnityEngine;
public class ExcelTool : MonoBehaviour
{
void Start()
{
ReadExcel("/cook.xlsx");
}
public void ReadExcel(string xmlName)
{
FileStream stream = File.Open(Application.dataPath + xmlName, FileMode.Open, FileAccess.Read, FileShare.Read);
//IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);//讀取 Excel 1997-2003版本
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);//讀取 2007及以后的版本
DataSet result = excelReader.AsDataSet();
if (stream != null)
{
stream.Close();
}
int[] counts = GetCount(result.Tables[0]);
int rows = counts[0];
int columns = counts[1];
Debug.LogError("row:" + rows + "...col:" + columns);
for (int i = 0; i < rows; i++)
{
for (int j = 0; j < columns; j++)
{
Debug.LogError(result.Tables[0].Rows[i][j].ToString());
}
}
}
private int[] GetCount(DataTable dt)
{
int i = dt.Rows.Count;
for (int m = 0; m < dt.Rows.Count; m++)
{
if (string.IsNullOrEmpty(dt.Rows[m][0].ToString()))
{
i = m;
break;
}
}
int j = dt.Columns.Count;
for (int n = 0; n < dt.Columns.Count; n++)
{
if (string.IsNullOrEmpty(dt.Rows[0][n].ToString()))
{
j = n;
break;
}
}
return new int[] { i, j };
}
}
1.3.Excel格式
?1.4.輸出顯示?
1.5.所需插件
需導(dǎo)入3個dll文件到Plugins文件夾下。
分別是：Excel.dll EPPlus.dll 和 ICSharpCode.SharpZipLib.dl
插件下載https://download.csdn.net/download/lalate/87401837
??注意：上述示例在安卓真機上運行是讀取不到的，有解決了的同學(xué)歡迎評論補充，或者私信我
二.Excel轉(zhuǎn)成Asset文件，再進行讀取
2.1Excel文件存放位置
2.2 編輯模式生成Asset文件，并保存到指定位置?
using System;
using System.Reflection;
using UnityEditor;
using UnityEngine;
public class ExcelReadEditor : Editor
{
[MenuItem("Excel/批量讀表")]
public static void ReadAllExcel()
{
Type typeInfo = typeof(ExcelReadEditor);
MethodInfo[] methodInfo = typeInfo.GetMethods();
foreach (MethodInfo mInfo in methodInfo)
{
if (mInfo.ToString().StartsWith("Void Create"))
{
mInfo.Invoke(null, null);
}
}
Debug.Log("讀取全部表成功");
}
[MenuItem("Excel/讀取Decoration數(shù)據(jù)")]
public static void CreateChapterData()
{
GetLocalData<LocalSheBei, Entity_SheBei>("SheBei");
Debug.Log("讀取Decoration數(shù)據(jù)成功");
}
//泛型創(chuàng)建 保存本地數(shù)據(jù)
public static void GetLocalData<T, W>(string fileName) where T : LocalDataBase<W>
{
T t = CreateInstance<T>();
string filePath = Application.dataPath + "/Excel/" + "cook-en" + ".xlsx";
//string filePath = Path.GetFullPath(".") + "\\Excel\\" + "cook-en" + ".xlsx";
t.data = ExcelRead.GetExcelData<W>(filePath, fileName);
if (t.data == null) Debug.LogError("數(shù)據(jù)讀取錯誤");
string savePath = "Assets/Excel/Data/EN/" + fileName + ".asset";
AssetDatabase.CreateAsset(t, savePath);
AssetDatabase.SaveAssets();
AssetDatabase.Refresh();
GetLocalDataCH<T, W>(fileName);
}
public static void GetLocalDataCH<T, W>(string fileName) where T : LocalDataBase<W>
{
T t = CreateInstance<T>();
string filePath = Application.dataPath + "/Excel/" + "cook-ch" + ".xlsx";
//string filePath = Path.GetFullPath(".") + "\\Excel\\" + "cook-ch" + ".xlsx";
t.data = ExcelRead.GetExcelData<W>(filePath, fileName);
if (t.data == null) Debug.LogError("數(shù)據(jù)讀取錯誤");
string savePath = "Assets/Excel/Data/CH/" + fileName + ".asset";
AssetDatabase.CreateAsset(t, savePath);
AssetDatabase.SaveAssets();
AssetDatabase.Refresh();
}
}
??注意：要先在指定位置創(chuàng)建好父文件夾，此腳步要放在Editor文件夾下
2.3創(chuàng)建ExcelRead腳本，讀取Excel內(nèi)容
using System.Collections.Generic;
using UnityEngine;
using System.Data;
using System.IO;
using Excel;
public class ExcelRead
{
public static T[] GetExcelData<T>(string filePath, string name)
{
switch (name)
{
case "Entity_SheBei":
return GetEntity_SheBei(filePath) as T[];
//。。。
}
return null;
}
//設(shè)備
private static Entity_SheBei[] GetEntity_SheBei(string filePath)
{
int columnNum = 0, rowNum = 0;
DataRowCollection collect = ReadExcel(filePath, ref columnNum, ref rowNum, 1);
List<Entity_SheBei> list = new List<Entity_SheBei>();
for (int i = 1; i < rowNum; i++)
{
if (string.IsNullOrEmpty(collect[i][0].ToString()) || string.IsNullOrEmpty(collect[0][i].ToString())) break;
Entity_SheBei data = new Entity_SheBei();
data.name = collect[i][0].ToString();
for (int j = 1; j < columnNum; j++)
{
//Debug.LogError(collect[i][j].ToString());
data.parts.Add(collect[i][j].ToString());
}
list.Add(data);
}
return list.ToArray();
}
/// <summary>
/// 讀取excel文件內(nèi)容
/// </summary>
/// <param name="filePath">文件路徑</param>
/// <param name="columnNum">行數(shù)</param>
/// <param name="rowNum">列數(shù)</param>
/// <param name="table">第幾張表</param>
/// <returns></returns>
static DataRowCollection ReadExcel(string filePath, ref int columnNum, ref int rowNum, int table = 0)
{
FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
DataSet result = excelReader.AsDataSet();
//Tables[0] 下標(biāo)0表示excel文件中第一張表的數(shù)據(jù)
int[] counts = GetRowColumns(result.Tables[table]);
//columnNum = result.Tables[table].Columns.Count;
//rowNum = result.Tables[table].Rows.Count;
rowNum = counts[0];
columnNum = counts[1];
Debug.LogError("行:" + rowNum + "...列:" + columnNum);
return result.Tables[table].Rows;
}
private static int[] GetRowColumns(DataTable dt)
{
int i = dt.Rows.Count;
for (int m = 0; m < dt.Rows.Count; m++)
{
if (string.IsNullOrEmpty(dt.Rows[m][0].ToString()))
{
i = m;
break;
}
}
int j = dt.Columns.Count;
for (int n = 0; n < dt.Columns.Count; n++)
{
if (string.IsNullOrEmpty(dt.Rows[0][n].ToString()))
{
j = n;
break;
}
}
return new int[] { i, j };
}
}
2.4 創(chuàng)建數(shù)據(jù)存儲腳本
基類：
using UnityEngine;
public class LocalDataBase<T> : ScriptableObject
{
public T[] data;
}?子類：
public class LocalSheBei : LocalDataBase<Entity_SheBei>
{
}?子類對應(yīng)的實體類：
using System.Collections.Generic;
[System.Serializable]
public class Entity_SheBei
{
public string name;
public List<string> parts = new List<string>();
}2.5? 編輯器生成Asset 與屬性面板詳情
?
?
?
?2.6 Asset數(shù)據(jù)的使用方式
??Resources.Load方式
?也可以定義一個單例類，直接拖拽：
文章來源：http://www.zghlxwxcb.cn/news/detail-807899.html
public LocalSheBei Data_SheBei;
//數(shù)據(jù)讀取
public void GetLocalData()
{
Debug.LogError(Data_SheBei.name + "..." + Data_SheBei.data.Length);
}?三:Excel文件轉(zhuǎn)成json 再以json的方式讀取
unity--json讀取與解析文章來源地址http://www.zghlxwxcb.cn/news/detail-807899.html
到了這里，關(guān)于UNITY--讀取Excel的幾種方式的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
