Skip to content

A useful tool for converting MS Excel files(.xls or .xlsx) to Json type files

License

Notifications You must be signed in to change notification settings

LizhuWeng/ExcelToJson

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ExcelToJson

A useful tool for converting MS Excel files(.xls or .xlsx) to Json type files

  • EXCEL FILE FORMAT


First row is used for descriptions of data structs.
Second row is used for data property names (or IDs).

Tip: ID with bracket can be used just for description in Excel cells.
All the following rows are datas



  • RESULT JSON
[{"Name":"idle","FadeTime":"0.4"},{"Name":"run","FadeTime":"0.3"},{"Name":"dance","FadeTime":"0.3"},{"Name":"attack","FadeTime":"0.5"}]



NOTE

For reading data from Microsoft Office Excel, you should check if Access database engine 2007 or newer has been installed in your PC.

About

A useful tool for converting MS Excel files(.xls or .xlsx) to Json type files

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages