Excel导表工具-开源

功能

支持int、float、bool、string基础类型
支持数组
支持kv
支持枚举
支持unity类型vector3,vector2,color
自动生成csharp类
单个excel中多个sheet，依次导出

使用

设置config.txt文件，按需求配置；

#为注释行必须；结尾

#excel存放路径;

excelPath:./Excel/;

#数据保存路径;

dataPath:./DataTable/;

#c#类保存路径;

classPath:./CSharp/;

#输出类型;

exportType:Json;

isExportServer:False

双击运行DataTable.exe，等待执行完毕；

配表

第一行注释
第二行字段类型
第三行变量名（属性名）
第一列留空
数组：类型+[] e.g: int[]
kv使用

类型：dic<string,int>

变量名：变量名+:+key值

e.g:

dic<string,float> dic<string,float> dic<string,float>

Attribute:atk Attribute:def Attribute:spd
枚举：自动生成的枚举类型从1开始，Enum类型为：Enum+变量名字段；

dic<string,float>	dic<string,float>	dic<string,float>
Attribute:atk	Attribute:def	Attribute:spd

Json序列化

使用json库需要对Vector3等Unity字段魔改；

Litjson库魔改：将自定义类型注册进json库；

namespace LitJson.Extensions

{

    public static class JsonExtensions

    {

        public static void WriteProperty(this JsonWriter w, string name, long value)

        {

            w.WritePropertyName(name);

            w.Write(value);

        }

        public static void WriteProperty(this JsonWriter w, string name, string value)

        {

            w.WritePropertyName(name);

            w.Write(value);

        }

        public static void WriteProperty(this JsonWriter w, string name, bool value)

        {

            w.WritePropertyName(name);

            w.Write(value);

        }

        public static void WriteProperty(this JsonWriter w, string name, double value)

        {

            w.WritePropertyName(name);

            w.Write(value);

        }

    }

}

 using UnityEngine;

 using System;

 using System.Collections;

 using LitJson.Extensions;

 namespace LitJson

 {

#if UNITY_EDITOR

     [UnityEditor.InitializeOnLoad]

#endif

     /// <summary>

     /// Unity内建类型拓展

     /// </summary>

     public static class UnityTypeBindings

     {

         static bool registerd;

         static UnityTypeBindings()

         {

             Register();

         }

         public static void Register()

         {

             if (registerd) return;

             registerd = true;

             // 注册Type类型的Exporter

             JsonMapper.RegisterExporter<Type>((v, w) => { w.Write(v.FullName); });

             JsonMapper.RegisterImporter<string, Type>((s) => { return Type.GetType(s); });

             // 注册Vector2类型的Exporter

             Action<Vector2, JsonWriter> writeVector2 = (v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("x", v.x);

                 w.WriteProperty("y", v.y);

                 w.WriteObjectEnd();

             };

             JsonMapper.RegisterExporter<Vector2>((v, w) => { writeVector2(v, w); });

             // 注册Vector3类型的Exporter

             Action<Vector3, JsonWriter> writeVector3 = (v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("x", v.x);

                 w.WriteProperty("y", v.y);

                 w.WriteProperty("z", v.z);

                 w.WriteObjectEnd();

             };

             JsonMapper.RegisterExporter<Vector3>((v, w) => { writeVector3(v, w); });

             // 注册Vector4类型的Exporter

             JsonMapper.RegisterExporter<Vector4>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("x", v.x);

                 w.WriteProperty("y", v.y);

                 w.WriteProperty("z", v.z);

                 w.WriteProperty("w", v.w);

                 w.WriteObjectEnd();

             });

             // 注册Quaternion类型的Exporter

             JsonMapper.RegisterExporter<Quaternion>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("x", v.x);

                 w.WriteProperty("y", v.y);

                 w.WriteProperty("z", v.z);

                 w.WriteProperty("w", v.w);

                 w.WriteObjectEnd();

             });

             // 注册Color类型的Exporter

             JsonMapper.RegisterExporter<Color>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("r", v.r);

                 w.WriteProperty("g", v.g);

                 w.WriteProperty("b", v.b);

                 w.WriteProperty("a", v.a);

                 w.WriteObjectEnd();

             });

             // 注册Color32类型的Exporter

             JsonMapper.RegisterExporter<Color32>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("r", v.r);

                 w.WriteProperty("g", v.g);

                 w.WriteProperty("b", v.b);

                 w.WriteProperty("a", v.a);

                 w.WriteObjectEnd();

             });

             // 注册Bounds类型的Exporter

             JsonMapper.RegisterExporter<Bounds>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WritePropertyName("center");

                 writeVector3(v.center, w);

                 w.WritePropertyName("size");

                 writeVector3(v.size, w);

                 w.WriteObjectEnd();

             });

             // 注册Rect类型的Exporter

             JsonMapper.RegisterExporter<Rect>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("x", v.x);

                 w.WriteProperty("y", v.y);

                 w.WriteProperty("width", v.width);

                 w.WriteProperty("height", v.height);

                 w.WriteObjectEnd();

             });

             // 注册RectOffset类型的Exporter

             JsonMapper.RegisterExporter<RectOffset>((v, w) =>

             {

                 w.WriteObjectStart();

                 w.WriteProperty("top", v.top);

                 w.WriteProperty("left", v.left);

                 w.WriteProperty("bottom", v.bottom);

                 w.WriteProperty("right", v.right);

                 w.WriteObjectEnd();

             });

         }

     }

 }

开源地址：https://github.com/Rebort1012/DataTable.git

个人博客：www.perilla.work

巴特西

Excel导表工具-开源

功能

使用

配表

Json序列化

最新文章

热门文章