05-generate-json.py

import xlrd
import json

wb = xlrd.open_workbook('TOPIMENA_SI.xlsx')
sh = wb.sheet_by_index(0)

data = {"name": "imena", 
			"children": [
				{"name": "Decki",   "children":[] }, 
				{"name": "Deklice", "children":[] },
			]
		}

for row in range(8, 107):
	child = {
		"name": unicode(sh.cell_value(row, 1)).strip(), 
		"size": int(sh.cell_value(row, 2))
	}
	data["children"][0]["children"].append(child)

for row in range(8, 110):
	child = {
		"name": unicode(sh.cell_value(row, 5)).strip(), 
		"size": int(sh.cell_value(row, 6))
	}
	data["children"][1]["children"].append(child)

f = open('06_js_imena/imena.json', 'w')
json_string = json.dumps(data)
f.write(json_string)
f.close()