xlsx2json

项目地址 xlsx2json master

作用

让excel表达复杂的json格式

将excel转成json

示例1 test.xlsx

id desc flag otherid#[] words#[] map#[] data#{} hero#[{}]

123 description true 1,2 哈哈,呵呵 true,true a:123;b:45 id:2;level:30,id:3;level:80

456 描述 false 3,5,8 shit,my god false,true a:11;b:22 id:9;level:38,id:17;level:100

输出如下：

[{ "id": 123, "desc": "description", "flag": true, "otherid": [1, 2], "words": ["哈哈", "呵呵"], "map": [true, true], "data": { "a": 123, "b": 45 }, "hero": [ {"id": 2,"level": 30}, {"id": 3,"level": 80} ] }, { "id": 456, "desc": "描述", "flag": false, "otherid": [3, 5, 8], "words": ["shit", "my god"], "map": [false, true], "data": { "a": 11, "b": 22 }, "hero": [ {"id": 9, "level": 38 }, {"id": 17,"level": 100} ] }] 支持以下数据类型 表头规则