xlsx-2-json

1.Excel文件配置规范

1.字段名*(key)*必须为英文字母

2.字段名*(key)*在第一行

3.第二行是字段描述，不做处理

4.辅助表格字段名字用中文，就不会生成在json里

5.第一列必须为必填字段，必须有值*（如:Id）*，没有值不会生成在json里

6.遍历xlsx文件里的sheet，在output目录输出以sheet name为名字的json文件

7.生成Data Type 2，首列值连续一样的行会被认为是数组，注意如图字段描述最后要加上“[]”标记生成数组形式

2.脚本调用：

例：在build.js里

const xlsx2json = require("xlsx-gen-json");
xlsx2json.toJson("./excel/gameconfig.xlsx","./src/config/",function(e,r){
	e?console.log(e):console.log(r);
});

3.Sheet and Data

Data Type 1:

javascript:

{
	"1":{"name":"superman","toyid":1,"price":100,"tag":[101,103,108]}
}

lua:

local toys =
{
	["1"] = 
	{
		["name"] = "superman",
		["toyid"] = 1,
		["price"] = 100,
		["tag"] = 
		{
			101,
			103,
			108
		}
	}
}
return toys

Data Type 2:

javascript

{
	"1":[{"num":3,"id":1,"toyid":1},
		{"num":4,"id":1,"toyid":2},
		{"num":5,"id":1,"toyid":3}],
	"2":[{"num":1,"id":2,"toyid":4},
		{"num":4,"id":2,"toyid":1}]
}

lua:

local missions =
{
	["1"] = 
	{
		{
			["num"] = 3,
			["id"] = 1,
			["toyid"] = 1
		},
		{
			["num"] = 4,
			["id"] = 1,
			["toyid"] = 2
		},
		{
			["num"] = 5,
			["id"] = 1,
			["toyid"] = 3
		}
		},
	["2"] = 
	{
		{
			["num"] = 1,
			["id"] = 2,
			["toyid"] = 4
		},
		{
			["num"] = 4,
			["id"] = 2,
			["toyid"] = 1
		}
	}
}
return missions

4.更新

1.支持生成以id为Key的Map方式以提高访问效率，参数useDictionary 2.支持生成Lua配置

const xlsx2json = require("xlsx-gen-json");
xlsx2json.toJson("./excel/gameconfig.xlsx","./src/config/",function(e,r){
	xlsx2json.jsonToLua(r,"./src/config/lua/"+s+".lua");
},true);