wxExportContact.py 文件源码

def saveContactFile(memberList):
    _data = [(u'??', u'???', u'???', u'???', u'??', u'??', u'??', u'??', ' ')]
    for contact in memberList:
        if not isPerson(contact):
            continue
        info = (
            removeEmoji(contact['NickName']),
            removeEmoji(contact['RemarkName']),
            pickScreenName(contact['NickName'], contact['RemarkName']),
            contact['Alias'],
            convertGender(contact['Sex']),
            contact['Province'],
            contact['City'],
            removeEmoji(contact['Signature']),
            formatQuanPin(contact['PYQuanPin'], contact['RemarkPYQuanPin'])
        )
        _data.append(info)
    _data.sort(key=lambda x: x[-1])
    _data = [e[:-1] for e in _data]
    filename = u'%s_????_%s.xlsx' % (
        removeEmoji(w.nickName),
        strftime('%Y%m%d-%H%M%S', localtime()),
    )
    workbook = xlsxwriter.Workbook(filename)
    worksheet = workbook.add_worksheet()
    row = 0
    col = 0
    for nickName, remarkName, screenName, alias, gender, province, city, signature in OrderedSet(_data):
        worksheet.write(row, col, nickName)
        worksheet.write(row, col + 1, remarkName)
        worksheet.write(row, col + 2, screenName)
        worksheet.write(row, col + 3, alias)
        worksheet.write(row, col + 4, gender)
        worksheet.write(row, col + 5, province)
        worksheet.write(row, col + 6, city)
        worksheet.write(row, col + 7, signature)
        row += 1
    workbook.close()
    print 'total: %d' % (row - 1)
    return