做个笔记,excel表格转Json文件,再通过对象操作读取
表格如下截图:
Excemple代码
using UnityEngine;
using GameFrameWork.Config;
using UnityEngine.UI;
public class Excemple : MonoBehaviour
{
void Start()
{
Transform nameAll = transform.Find("NameAll");
Text name = transform.Find("Name").GetComponent<Text>();
Text icon = transform.Find("Icon").GetComponent<Text>();
Text type = transform.Find("Type").GetComponent<Text>();
Text role = transform.Find("Role").GetComponent<Text>();
string _nameAll = null;
//循环出表中所有的名字字段
foreach (var item in SkillCfgCtrl.Instance.All)
{
_nameAll += item.Value.Name + ",";
}
nameAll.GetComponent<Text>().text = _nameAll;
//传入一个id得到一个对象
SkillCfgItem skillCfgItem = SkillCfgCtrl.TryGet(1001);
name.text = skillCfgItem.Name;
icon.text = skillCfgItem.Icon;
type.text = skillCfgItem.Type;
role.text = skillCfgItem.Role;
}
}
结果:
这里导出表格是将Excel转成json文件,生成与excel文件名对应的工具类方便调用,
导出过程excel必须保存并关闭,excel文件名必须是英文名字
工具地址:
https://gitee.com/Brand123147/ExcelToJson.git
https://github.com/Brand123147/ExcelToJson.git