# DGConfig

**Repository Path**: wrbxdj/DGConfig

## Basic Information

- **Project Name**: DGConfig
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-01-21
- **Last Updated**: 2025-01-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# DGConfig
cocos creator3.x excel导出插件

# 优点
* 数据导出到二进制文件中比其他类型的数据要小的多
* 导出时动态分析数据的类型以及数值范围，使用最合适的存储类型保证二进制文件最小化
* 导出d.ts接口，保证编码时有代码提示，运行时不增加代码体积(对小游戏体积很重要！！！)
* excel表支持两种方式：
    1. a.单表导出--表示以文件名为表名且只导出文件中的第一张表
    1. b.多表导出--根据文件中的表明进行导出

# 使用方式
* 将dgconfig复制到项目中的extensions文件夹下
* 面板=>DGConfig=>配置导出
* 选择配置表文件夹和导出代码及二进制文件路径后，点击导出搞定。

# 配置表格式
* 第一行--属性名
* 第二行--数据类型参考
~~~ts
    //注意数组内容分隔符为"|"
    let types=["string","[string]","int","[int]","uint","[uint]","float","[float]","number","[number]"]
~~~
* 第三行--注释


# 运行时解析
~~~ ts
//这里用的ByteArray 在runtime文件夹中(copy来自我的老东家egret)
    parseSheet(buffer: ArrayBuffer): void {
        let byte: ByteArray = new ByteArray(buffer);
        //解析表头
        let len: number = byte.readUnsignedInt();
        let titleList: Array<string> = [];
        for (let index = 0; index < len; index++) {
            titleList.push(byte.readUTF());
        }
        //类型
        let typeList: Array<number> = [];
        len = byte.readUnsignedInt();
        for (let index = 0; index < len; index++) {
            typeList.push(byte.readByte());
        }
        len = byte.readUnsignedInt();
        let type: number;
        let title: string;
        let dataList = [];
        let data: any;
        for (let dataIndex = 0; dataIndex < len; dataIndex++) {
            data = {};
            for (let index = 0; index < typeList.length; index++) {
                title = titleList[index];
                type = typeList[index];
                switch (type) {
                    case 0: //byte
                    case 1://ubyte
                    case 2: //short
                    case 3: //ushort
                    case 4: //int
                    case 5: //uint
                    case 6: //float
                    case 7: //number
                        this.__readNumber(title, type, data, byte);
                        break;
                    case 8: //string
                        data[title] = byte.readUTF();
                        break;
                    case 9: //[byte]
                    case 10://[ubyte]
                    case 11: //[short]
                    case 12: //[ushort]
                    case 13: //[int]
                    case 14: //[uint]
                    case 15: //[float]
                    case 16: //[number]
                    case 17: //[string]
                        this.__readArray(title, type, data, byte);
                        break;
                    default:
                        break;
                }
            }
            //你要怎么存储那就看需求了
            console.log(data);
        }
    }
    private __readNumber(title: string, type: number, data: any, byte: ByteArray): void {
        switch (type) {
            case 0: //byte
                data[title] = byte.readByte();
                break;
            case 1://ubyte
                data[title] = byte.readUnsignedByte();
                break;
            case 2: //short
                data[title] = byte.readShort();
                break;
            case 3: //ushort
                data[title] = byte.readUnsignedShort();
                break;
            case 4: //int
                data[title] = byte.readInt();
                break;
            case 5: //uint
                data[title] = byte.readUnsignedInt();
                break;
            case 6: //float
                data[title] = byte.readFloat();
                break;
            case 7: //number
                data[title] = byte.readDouble();
                break;
            default:
                throw new Error(title + ' 未知类型:' + type);
        }
    }
    private __readArray(title: string, type: number, data: any, byte: ByteArray): void {
        let len: number = byte.readUnsignedInt();
        let list = [];
        for (let index = 0; index < len; index++) {
            switch (type) {
                case 9: //byte
                    list.push(byte.readByte());
                    break;
                case 10://ubyte
                    list.push(byte.readUnsignedByte());
                    break;
                case 11: //short
                    list.push(byte.readShort());
                    break;
                case 12: //ushort
                    list.push(byte.readUnsignedShort());
                    break;
                case 13:
                    list.push(byte.readInt());
                    break;
                case 14:
                    list.push(byte.readUnsignedInt());
                    break;
                case 15:
                    list.push(byte.readFloat());
                    break;
                case 16:
                    list.push(byte.readDouble());
                    break;
                case 17:
                    list.push(byte.readUTF());
                    break;
                default:
                    throw new Error(title + ' 未知类型:' + type);
            }
        }
        data[title] = list;
    }
~~~