列行与dict python on ex

Question

我有这个密码：

"result": [{
        "Name": "Jean",
        "LastName": "xxx",
        "Salaire": xxx,
        "hire": "2015-07-25",
        "numerobadge": 0000111 ",
        "worked_per_week": 35,
    }, {
        "Name": "Catherine",
        "LastName": "xxx",
        "Salaire": xxx,
        "hire": "2016-11-09",
        "numerobadge": 0000127 ",
        "worked_per_week": 25,
    }, {
        "Name": "George",
        "LastName": "xxx",
        "Salaire": xxx,
        "hire": "2016-12-05",
        "numerobadge": 0000144 ",
        "worked_per_week": 35,
    },

我想在excel上提取hours_per_week和name。我没有找到一个关于dict和list以及xlsxwriter的好教程。你知道吗

Answer 1

结果是一个列表，您可以通过如下循环提取信息：

for p in result:
    name = p['Name']
    w_p_w = p['worked_per_week']

Answer 2

import json

import xlsxwriter

workbook = xlsxwriter.Workbook('Expenses01.xlsx')

worksheet = workbook.add_worksheet()

"result":[
{ "Name":"Jean", "LastName":"xxx", "Salaire":xxx, "hire":"2015-07-25", "numerobadge":0000111", "worked_per_week":35, }, { "Name":"Catherine", "LastName":"xxx", "Salaire":xxx, "hire":"2016-11-09", "numerobadge":0000127", "worked_per_week":25, }, { "Name":"George", "LastName":"xxx", "Salaire":xxx, "hire":"2016-12-05", "numerobadge":0000144", "worked_per_week":35, },
]
row = 0

col = 0

    a=['result']

    for p in result
        name = p['Name']
        w_p_w = p['worked_per_week']


workbook.close()