Python Array to Json 数组转Json

# coding=utf-8
import itertools
import json

import xlrd

#
#  a special tool to handle excel
#  it is used to collect data and transfer data into database
#
def read_xlrd(excelFile):
    data = xlrd.open_workbook(excelFile)
    table = data.sheet_by_index(0)
    data = []
    keys = []

    for rowNum in range(table.nrows):
        # if 去掉表头
        if rowNum > 0:
            values = table.row_values(rowNum)
            parkPos = {
                'id': values[0],
                'aa': values[1],
                'bb': values[2],
                'cc': values[3],
                'dd': values[4],
                'ee': values[5],
                'ff': values[6],
                'ee': values[7],
                'gg': values[8],
            }
            data.append(parkPos)

    for item in data:
        itemKey = str(item['aa']) + str(item['bb']) + str(item['cc']) + str(
            item['dd'])
        keys.append(itemKey)
        motorFactorvals.append(str(item['ee']))
        noMotorFactorvals.append(str(item['gg']))
    # print(json.dumps(mapVal))
   
    mfMapVal = {k: v for k, v in itertools.zip_longest(keys, motorFactorvals)}
    mfJson = json.dumps(mfMapVal, ensure_ascii=False)
    print(mfJson)

if __name__ == '__main__':
    excelFile = 'data.xlsx'
    print(read_xlrd(excelFile=excelFile))