字典在xls中的应用

def dictCreaDemo():
    dic1=dict()
    print(dic1)
    dic2=dict(王五=22)
    print(dic2)
    dic3={}
    print(dic3)
    dic4={'张三':18, '李四':20}
    print(dic4)
    del dic3

def getKeyvalDemo():
    dic={'张三':18, '李四':29, '王五':30}
    # 通过字典的键获取值
    print(dic['李四'])
    # 获取字典中所有的键
    print(dic.keys())
    # 获取字典中所有的值
    print(dic.values())
    # 获取字典中所有的键和值
    print(dic.items())

def dicModifyDemo():
    # 创建空的字典
    dic={}
    # 添加键值，使用update
    dic.update(李四=88,王五=79)
    print(dic)
    # 也可用另外的方式
    dic.update({'麻子':96})
    print(dic)
    # 也可以使用键和值
    dic['张三']=99
    print(dic)
    # 修改键值
    dic['张三']=109
    print(dic)
    del dic['张三']
    print(dic)
    dic['张三']=99
    print(dic)
    dic['赵六']=dic.pop('李四')
    print(dic)

def dictXlsDemo(wbR, wsR, wbW, wsW):
    import xlwt,xlrd
    wb=xlrd.open_workbook(wbR)
    ws=wb.sheet_by_name(wsR)
    nwb=xlwt.Workbook('utf-8')
    nws=nwb.add_sheet(wsW)
    dic, rowN=dict(), 0
    for cls, name in ws.get_rows():
        dic[cls.value]=name.value
    for key, item in dic.items():
        nws.write(rowN, 0, key)
        nws.write(rowN, 1, item)
        rowN += 1
    nwb.save(wbW)

CON1=True
if CON1:
    #dictCreaDemo()
    #getKeyvalDemo()
    #dicModifyDemo()
    wbR='../dat/Chapter-7/Chapter-7-6/Chapter-7-6-1.xls'
    wsR='分数表'
    wbW='../dat/gsc/Chapter-7-6-2.xls'
    wsW='汇总表'
    dictXlsDemo(wbR, wsR, wbW, wsW)

代码非常简单，无需多言。