ExcelToJson

A excel with VBA that able to export content to json and a C# enum class file

This is a sample project, download the “ExcelToJson.xlsm” and enable the macro, when u change the content and save the excel,it’ll be export json files.
Each sheet will be exported as a json file which’s name is the sheet name.
Still, it will export a .cs file with all enum,so you can use the enum in Unity.

PS:There’s no error check in this excel,make sure you fill the right content

This excel only generate “ANSI” encoding file,if you want “UTF-8″format, try “AnsiToUtf8.py”

GitHub

View Github