python 快速操作excel

if __name__ == '__main__':
    work_book = openpyxl.Workbook()
    sheet = work_book.create_sheet('username_password')
    sheet.append(['id', 'loginName', 'userName', 'password'])
    users = list()
    for index, user in enumerate(users):
        password = getPassword(user['id'])
        data = [user['id'], user['loginName'], user['userName'], password]
        sheet.append(data)
    work_book.save("教师用户.xlsx")

依赖：pip install openpyxl