エクセルをJSONに直すPythonスクリプト

gistfile1.py

import xlrd
from collections import OrderedDict
import simplejson as json

excel_path = raw_input('input path> ')
json_path = raw_input('output json path> ')

wb = xlrd.open_workbook(excel_path)

sheets = OrderedDict()

for sheet_name in wb.sheet_names():

    sh = wb.sheet_by_name(sheet_name)

    rows = []

    header_row = sh.row_values(0)

    for rownum in range(1, sh.nrows):
        row_values = sh.row_values(rownum)

        row = OrderedDict()
        for column in range(0, len(header_row)) :
            row[header_row[column]] = row_values[column]       

        rows.append(row)

    sheets[sheet_name] = rows

json_string = json.dumps(sheets)

with open(json_path, 'w') as f:
    f.write(json_string)