从外面更新unity需要用的题库
unity中必须要有Plugins文件夹以及dll文件
官方dll文件下载链接: https://archive.codeplex.com/?p=exceldatareader
dll下载:点击下载
using System.Collections; using System.Collections.Generic; using UnityEngine; using Excel; using System.IO; using System.Data; using OfficeOpenXml; public class Exc_GenXin : MonoBehaviour { private string DpanMain = "D:/anchor/main.xlsx";//D盘main表格 private string AsstPath;//streaamingAssets文件里面的文件 public static List<DepenceTableDataTwo> DepenceTableDataList = new List<DepenceTableDataTwo>();//创建列表 private void Awake() { AsstPath = Application.streamingAssetsPath + "/main.xlsx"; } private void OnEnable() { if (File.Exists(DpanMain)) { DepenceTableDataList = ReadLoad(DpanMain); WriteExcel(AsstPath); Debug.Log("更新成功"); } } // Use this for initialization void Start () { } public void AANniu() { } public struct DepenceTableDataTwo { public string itemNumber;//标号 public string topicType;//类型 public string topic;//题目 public string optionA;//A public string optionB;//B public string optionC;//C public string optionD;//D public string answer;//答案 } /// <summary> /// 读取表格 /// </summary> /// <param name="path">路径</param> /// <returns></returns> 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(); return result; } public static List <DepenceTableDataTwo> ReadLoad(string path) { List<DepenceTableDataTwo> _data = new List<DepenceTableDataTwo>(); DataSet resultds = ReadExcel(path); int rows = resultds.Tables[0].Rows.Count;//行 int colums = resultds.Tables[0].Columns.Count;//列 for (int i = 0; i < rows; i++) { DepenceTableDataTwo dependData; dependData.itemNumber = resultds.Tables[0].Rows[i][0].ToString(); dependData.topicType = resultds.Tables[0].Rows[i][1].ToString(); dependData.topic = resultds.Tables[0].Rows[i][2].ToString(); if (dependData.topicType =="选择") { dependData.optionA = resultds.Tables[0].Rows[i][3].ToString(); dependData.optionB = resultds.Tables[0].Rows[i][4].ToString(); dependData.optionC = resultds.Tables[0].Rows[i][5].ToString(); dependData.optionD = resultds.Tables[0].Rows[i][6].ToString(); dependData.answer = resultds.Tables[0].Rows[i][7].ToString(); } else { dependData.optionA = string.Empty; dependData.optionB = string.Empty; dependData.optionC = string.Empty; dependData.optionD = string.Empty; dependData.answer = resultds.Tables[0].Rows[i][3].ToString(); } _data.Add(dependData); } return _data; } /// <summary> /// 写入表格 /// </summary> /// <param name="path">路径</param> public static void WriteExcel(string outpath) { FileInfo newFile = new FileInfo(outpath); if (newFile .Exists ) { newFile.Delete(); newFile = new FileInfo(outpath); } using (ExcelPackage package=new ExcelPackage(newFile)) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1"); for (int i = 0; i < DepenceTableDataList.Count; i++) { worksheet.Cells[i + 1, 1].Value = DepenceTableDataList[i].itemNumber.ToString (); worksheet.Cells[i + 1, 2].Value = DepenceTableDataList[i].topicType.ToString (); worksheet.Cells[i + 1, 3].Value = DepenceTableDataList[i].topic.ToString (); if (DepenceTableDataList[i].topicType == "选择") { worksheet.Cells[i + 1, 4].Value = DepenceTableDataList[i].optionA .ToString(); worksheet.Cells[i + 1, 5].Value = DepenceTableDataList[i].optionB .ToString(); worksheet.Cells[i + 1, 6].Value = DepenceTableDataList[i].optionC .ToString(); worksheet.Cells[i + 1, 7].Value = DepenceTableDataList[i].optionD .ToString(); worksheet.Cells[i + 1, 8].Value = DepenceTableDataList[i].answer .ToString(); } else { worksheet.Cells[i + 1, 4].Value = DepenceTableDataList[i].answer.ToString(); } } package.Save(); } }
}
下面附上自己做的Demo地址,不是很完善,但里面也没有错误,大佬们不要介意,感谢!
这是链接:
链接：https://pan.baidu.com/s/1CPLIVsvMzWUknQAi0Ekgjg
提取码：bkod
复制这段内容后打开百度网盘手机App，操作更方便哦
二.新的读取表格方式 (简单明了)
using Excel; using System.Collections; using System.Collections.Generic; using System.Data; using System.IO; using UnityEngine; using UnityEngine.UI; public class ReadExcelController1 : MonoBehaviour { public Transform cubetrans; Dictionary<string, string > tableData = new Dictionary<string, string>(); // Start is called before the first frame update void Start() { ReadDataGame(ExcelControl(Application.streamingAssetsPath + "/大华设备统计.xlsx")); //BianLiModel(); } public void BianLiModel() { foreach (var item in cubetrans.GetComponentsInChildren <MeshRenderer>()) { if (tableData.ContainsKey(item.name)) { item.name = tableData[item.name]; } } } /// <summary> /// 表格数据集合 /// </summary> //private DataSet mResultSet; /// <summary> /// 读取表数据 /// </summary> /// <param name="excelFile">Excel file.</param> public DataSet ExcelControl(string excelFile) { DataSet mResultSet=new DataSet (); FileStream mStream = File.Open(excelFile, FileMode.Open, FileAccess.Read); IExcelDataReader mExcelReader = ExcelReaderFactory.CreateOpenXmlReader(mStream); mResultSet = mExcelReader.AsDataSet(); return mResultSet; } public void ReadDataGame(DataSet mResultSet) { if (mResultSet.Tables.Count < 1) return; //默认读取第一个数据表 DataTable mSheet = mResultSet.Tables[5]; //判断数据表内是否存在数据 if (mSheet.Rows.Count < 1) return; //读取数据表行数和列数 int rowCount = mSheet.Rows.Count; int colCount = mSheet.Columns.Count; Debug.Log("行:" + rowCount + "列:" + colCount); //准备一个列表存储整个表的数据 List<Dictionary<string, object>> table = new List<Dictionary<string, object>>(); //读取数据 for (int i = 1; i < rowCount; i++) { //准备一个字典存储每一行的数据 Dictionary<string, object> row = new Dictionary<string, object>(); string strname=""; string strname1 = ""; for (int j = 0; j < 2; j++) { //读取第1行数据作为表头字段 string field = mSheet.Rows[0][j].ToString(); //Key-Value对应 row[field] = mSheet.Rows[i][j]; //因为我只需要表格前两个数据,所以只保存前两个,有需要全部的把上面的for j<2 改成j<colCount就行了 strname = (mSheet.Rows[i][0].ToString()); strname1 = (mSheet.Rows[i][1].ToString()); } Debug.Log(strname1 + " " + strname); if (!tableData.ContainsKey (strname1)) { tableData.Add(strname1, strname); } //添加到表数据中 table.Add(row); } Debug.Log("添加结束"); } private void Update() { if (Input.GetKeyDown (KeyCode.K)) { BianLiModel(); } } }
