wxExportGroups.py 文件源码

def saveGroupFile(groups, firends):
    friendsUserName = [contact['UserName'] for contact in firends]
    for group in groups:
        gMemberList = queryGMemberList(group['UserName'])
        _data = [(u'??', u'???', u'???', u'????', u'???', u'??', u'??', u'??', u'??')]
        for contact in gMemberList:
            info = (
                removeEmoji(contact['NickName']),
                contact['Alias'],
                removeEmoji(contact['DisplayName']),
                isFriend(friendsUserName, contact['UserName']),
                removeEmoji(contact['RemarkName']),
                convertGender(contact['Sex']),
                contact['Province'],
                contact['City'],
                removeEmoji(contact['Signature'])
            )
            _data.append(info)
        filename = u'%s_???_%s.xlsx' % (
            removeEmoji(group['NickName']),
            strftime('%Y%m%d-%H%M%S', localtime()),
        )
        workbook = xlsxwriter.Workbook(filename)
        worksheet = workbook.add_worksheet()
        row = 0
        col = 0
        for nickName, alias, displayName, friend, remarkName, gender, province, city, signature in _data:
            worksheet.write(row, col, nickName)
            worksheet.write(row, col + 1, alias)
            worksheet.write(row, col + 2, displayName)
            worksheet.write(row, col + 3, friend)
            worksheet.write(row, col + 4, remarkName)
            worksheet.write(row, col + 5, gender)
            worksheet.write(row, col + 6, province)
            worksheet.write(row, col + 7, city)
            worksheet.write(row, col + 8, signature)
            row += 1
        workbook.close()
        print '%s: %d' % (removeEmoji(group['NickName']), row - 1)
    return