ExcelToJsonC#

    技术2025-07-11  12

    做个笔记,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

    Processed: 0.013, SQL: 9