最近研究了一下在Unity中如何读取Excel文件的方法,之前在网上搜索过,但感觉写的太复杂,用起来不太方便.下面是我整理出来写的一个Demo,用起来比较方便实用.
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityExcelTool;
using Newtonsoft.Json;
public class ReadExcelTest : MonoBehaviour
{
private string ExcelPath = "Assets/ExcelPath/测试数据.xlsx";
public Dictionary<string, List<Dictionary<string, string>>> XmlsDic;
private void Start()
{
ReadExcelData();
}
public void ReadExcelData()
{
string data = ReadUnityExcel.StartReadExcel(ExcelPath);
Debug.Log(data);
XmlsDic = JsonConvert.DeserializeObject < Dictionary<string, List<Dictionary<string, string>>>>(data);
foreach (var item in XmlsDic)
{
Debug.Log("SheetName:" + item.Key);
for (int i = 0; i < item.Value.Count; i++)
{
var dataDic = item.Value[i];
foreach (var temp in dataDic)
{
Debug.Log(temp.Key+":"+temp.Value);
}
}
}
}
}
UnityExcelTool是我封装好的一个dll库,可以直接调用里面的方法
下面是表测试数据
读取结果是分别把两张表格存在字典里面,方便取值
有Demo演示,下载链接:ReadExcelTool