#xlsx2json-py
##Env
python version >= 2.7
##Dependencies
openpyxl (2.2.2)
you can install it by pip, like this: pip install openpyxl
##Usage
export from excel/ to json/
run it:
$ python xlsx2json.py
.xlsx file head row default 2 and you can define it by yourself
don't forget add the num when run it
$ python xlsx2json.py 3
##Supported data type
- int
- float
- string
- boolean
- date
- array
- object
- object array
##Data rule
- use half-angle
- use
,to split array data - if only one data in array, ending with
, - use
;to split object array data - if only one data in object array, ending with
;
##Example
result:
[
{
"hero": [
{
"id": 12,
"name": "king"
},
{
"id": 20,
"name": "queen"
}
],
"person": {
"age": 18,
"name": "dong"
},
"value": 0.12,
"start": "Mon May 11 00:00:00 2015",
"flag": true,
"words": [
1,
2,
3,
4
],
"id": 1,
"desc": "hello"
},
{
"hero": [
{
"id": 7,
"name": "jake"
}
],
"person": {
"id": 5
},
"value": 2.4,
"start": "Mon May 11 13:30:24 2015",
"flag": false,
"words": [
1
],
"id": 2,
"desc": "你好"
},
{
"hero": [
{
"id": 6
},
{
"id": 28
}
],
"person": {
"max": true,
"min": false
},
"value": 3.14,
"start": "Mon Jan 20 00:00:00 2020",
"flag": true,
"words": [
"hello",
"world"
],
"id": 3,
"desc": "foo"
},
{
"hero": [
{
"id": 777
},
{
"name": "seven"
}
],
"person": {
"level": 100
},
"value": 2.22,
"start": "Fri May 1 02:30:00 2020",
"flag": true,
"words": [
true,
false
],
"id": 4,
"desc": "world"
}
]