excel转json脚本

开发中将策划配置好的excel文件转为json数据

import xlrd


def xls2json_skip(path, rowsToSkip):
    wb = xlrd.open_workbook(path)
    data = {}
    for index in range(wb.nsheets):
        sh = wb.sheet_by_index(index)
        sheetName = sh.name
        convert_list = []
        title = sh.row_values(0)
        for rownum in range(rowsToSkip, sh.nrows):
            rowvalue = sh.row_values(rownum)
            single = OrderedDict()
            for colnum in range(0, len(rowvalue)):
                single[title[colnum]] = rowvalue[colnum]
            convert_list.append(single)
        data[sheetName] = convert_list
    return data

path xlsx文件路径   rowsToSkip表示要忽略的前几行数据