自动化工具：Excel 转 Json 并自动化生成C# 代码

一：简介

手动或者用reg 脚本命令往注册表中添加执行命令，效果为当鼠标右键时，如果时文件则有添加到注册表命令执行reg 脚本命令可以查看 reg 命令.note 执行命令主要时为了快捷执行.bat 命令，通过。bat命令.note往Python 脚本 传入选中的文件路径和文件名
如点击Equip表格文件，生成如下对应的json 和 C# 文件

二：工具目录文件

通过reg 命令注册后，将在鼠标右键中添加命令如下

点击后将在目录文件夹下生成对应的json 文件和C#文件

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System;

[System.Serializable]
public class Equip_Data{
    public List<Equip> EquipInfo = new List<Equip>();
    public Dictionary<int, Equip> EquipInfoDic = new Dictionary<int, Equip>();
    
    public void ListToDicData()
    {
        foreach (var item in EquipInfo)
        {
            if (EquipInfoDic.ContainsKey(item.ID))
            {
                throw new Exception(string.Format("已存在 ID = {0}", item.ID));
            }
            else
            {
                EquipInfoDic.Add(item.ID, item);
            }
        }
    }
}

 [System.Serializable]
public class Equip{
	public int	ID;
	public string	name;
	public string	desc;
	public int	type;
	public int 	quality;
	public int	level;
	public int	suilt_id;
	public int	skill_id;
	public float	advance_rete;
	public int[]	advance_cost_info;
	public float	bonus;
}

{
	"EquipInfo":[
		{
			"ID" : 10001,
			"name" : "菜鸟草鞋",
			"desc" : "",
			"type" : 1,
			"quality" : 1.0,
			"level" : 10,
			"suilt_id" : 1,
			"skill_id" : 20001,
			"advance_rete" : 0.8,
			"advance_cost_info" : [30001,10],
			"bonus" : 10.5
		},
		{
			"ID" : 10002,
			"name" : "黄金宝剑",
			"desc" : "",
			"type" : -1,
			"quality" : 2.0,
			"level" : -1,
			"suilt_id" : -1,
			"skill_id" : -1,
			"advance_rete" : 1.8,
			"advance_cost_info" : [],
			"bonus" : -1
		},
		{
			"ID" : 10003,
			"name" : "草帽",
			"desc" : "",
			"type" : -1,
			"quality" : 3.0,
			"level" : -1,
			"suilt_id" : -1,
			"skill_id" : -1,
			"advance_rete" : 2.8,
			"advance_cost_info" : [],
			"bonus" : -1
		},
		{
			"ID" : 10004,
			"name" : "吊具",
			"desc" : "",
			"type" : -1,
			"quality" : 4.0,
			"level" : -1,
			"suilt_id" : -1,
			"skill_id" : -1,
			"advance_rete" : 3.8,
			"advance_cost_info" : [],
			"bonus" : -1
		},
		{
			"ID" : 10005,
			"name" : "长枪",
			"desc" : "",
			"type" : -1,
			"quality" : 5.0,
			"level" : -1,
			"suilt_id" : -1,
			"skill_id" : -1,
			"advance_rete" : 4.8,
			"advance_cost_info" : [],
			"bonus" : -1
		},
		{
			"ID" : 10006,
			"name" : "裙子",
			"desc" : "",
			"type" : -1,
			"quality" : 6.0,
			"level" : -1,
			"suilt_id" : -1,
			"skill_id" : -1,
			"advance_rete" : 5.8,
			"advance_cost_info" : [],
			"bonus" : -1
		},
		{
			"ID" : 10007,
			"name" : "护腕",
			"desc" : "",
			"type" : -1,
			"quality" : 7.0,
			"level" : -1,
			"suilt_id" : -1,
			"skill_id" : -1,
			"advance_rete" : 6.8,
			"advance_cost_info" : [],
			"bonus" : -1
		}
	]
}

详情可以看使用规则文件！！！！！！！！！！！！！！！
可关注微信公众号输入1110获取工具包：