【工具推荐】excel转换json，在线转换

作为技术其实用python随便就能转，但是写还是要时间，先用网络工具帮忙一下吧。

同时给诸位对比使用，注意后面有对比说明。

先看一下模板的excel数据：

第一个：  http://www.esjson.com/exceltojson.html

生成后的结构是：

[ {"id":"1","time":"60","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3","elite_interval_time":"11","elite_pool":"11|12|13","buff_interval_time":"18","buff_pool":"1|1|2|2|2|2|3|4"}, {"id":"2","time":"60","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3|4","elite_interval_time":"6","elite_pool":"13|12|14","buff_interval_time":"18","buff_pool":"1|2|2|2|3|3|4"}, {"id":"3","time":"60","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3|4|5","elite_interval_time":"6","elite_pool":"11|12|13|14","buff_interval_time":"25","buff_pool":"1|2|2|3|4|4"}, {"id":"4","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"2|3|4|5","elite_interval_time":"6","elite_pool":"11|12|13|14","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}, {"id":"5","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"3|4|5|6","elite_interval_time":"6","elite_pool":"12|13|14|15","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}, {"id":"6","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3|4|5|6","elite_interval_time":"6","elite_pool":"11|12|13|14|15","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}, {"id":"7","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"4|5|6|7","elite_interval_time":"5","elite_pool":"13|14||15|16","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}, {"id":"8","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"2|3|4|5|6|7","elite_interval_time":"5","elite_pool":"11|12|16|17","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}, {"id":"9","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"5|6|7|8","elite_interval_time":"5","elite_pool":"14||15|16|17","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}, {"id":"10","time":"240","boss":"21","enemy_interval_time":"2","enemy_pool":"3|4|5|6|7|8","elite_interval_time":"5","elite_pool":"11|12|13|14|15|16|17","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"} ]

第二个：https://uutool.cn/excel2json/

生成的结构是：

[{"id":"1","time":"60","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3","elite_interval_time":"11","elite_pool":"11|12|13","buff_interval_time":"18","buff_pool":"1|1|2|2|2|2|3|4"},{"id":"2","time":"60","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3|4","elite_interval_time":"6","elite_pool":"13|12|14","buff_interval_time":"18","buff_pool":"1|2|2|2|3|3|4"},{"id":"3","time":"60","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3|4|5","elite_interval_time":"6","elite_pool":"11|12|13|14","buff_interval_time":"25","buff_pool":"1|2|2|3|4|4"},{"id":"4","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"2|3|4|5","elite_interval_time":"6","elite_pool":"11|12|13|14","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"},{"id":"5","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"3|4|5|6","elite_interval_time":"6","elite_pool":"12|13|14|15","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"},{"id":"6","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"1|2|3|4|5|6","elite_interval_time":"6","elite_pool":"11|12|13|14|15","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"},{"id":"7","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"4|5|6|7","elite_interval_time":"5","elite_pool":"13|14||15|16","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"},{"id":"8","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"2|3|4|5|6|7","elite_interval_time":"5","elite_pool":"11|12|16|17","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"},{"id":"9","time":"120","boss":"21","enemy_interval_time":"2","enemy_pool":"5|6|7|8","elite_interval_time":"5","elite_pool":"14||15|16|17","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"},{"id":"10","time":"240","boss":"21","enemy_interval_time":"2","enemy_pool":"3|4|5|6|7|8","elite_interval_time":"5","elite_pool":"11|12|13|14|15|16|17","buff_interval_time":"25","buff_pool":"1|2|2|2|3|3|4"}]

第三个：https://www.bejson.com/json/col2json/

生成的结构是：

[ {"id":1,"time":60,"boss":21,"enemy_interval_time":2,"enemy_pool":"1|2|3","elite_interval_time":11,"elite_pool":"11|12|13","buff_interval_time":18,"buff_pool":"1|1|2|2|2|2|3|4"}, {"id":2,"time":60,"boss":21,"enemy_interval_time":2,"enemy_pool":"1|2|3|4","elite_interval_time":6,"elite_pool":"13|12|14","buff_interval_time":18,"buff_pool":"1|2|2|2|3|3|4"}, {"id":3,"time":60,"boss":21,"enemy_interval_time":2,"enemy_pool":"1|2|3|4|5","elite_interval_time":6,"elite_pool":"11|12|13|14","buff_interval_time":25,"buff_pool":"1|2|2|3|4|4"}, {"id":4,"time":120,"boss":21,"enemy_interval_time":2,"enemy_pool":"2|3|4|5","elite_interval_time":6,"elite_pool":"11|12|13|14","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, {"id":5,"time":120,"boss":21,"enemy_interval_time":2,"enemy_pool":"3|4|5|6","elite_interval_time":6,"elite_pool":"12|13|14|15","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, {"id":6,"time":120,"boss":21,"enemy_interval_time":2,"enemy_pool":"1|2|3|4|5|6","elite_interval_time":6,"elite_pool":"11|12|13|14|15","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, {"id":7,"time":120,"boss":21,"enemy_interval_time":2,"enemy_pool":"4|5|6|7","elite_interval_time":5,"elite_pool":"13|14||15|16","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, {"id":8,"time":120,"boss":21,"enemy_interval_time":2,"enemy_pool":"2|3|4|5|6|7","elite_interval_time":5,"elite_pool":"11|12|16|17","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, {"id":9,"time":120,"boss":21,"enemy_interval_time":2,"enemy_pool":"5|6|7|8","elite_interval_time":5,"elite_pool":"14||15|16|17","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, {"id":10,"time":240,"boss":21,"enemy_interval_time":2,"enemy_pool":"3|4|5|6|7|8","elite_interval_time":5,"elite_pool":"11|12|13|14|15|16|17","buff_interval_time":25,"buff_pool":"1|2|2|2|3|3|4"}, ]

总结：

对比说明，：

1.第三种也就是百度最多的网站，但是生成的数据，注意看id和time这些，它是转为number类型，而其他两个是string类型。本来number类型的确是想要的结果，但是json校验是错误的，只能是string才正确。

2.第一种和第二种区别在于格式方便与观看