字典转dataframe写入excel且创建多个sheet

从环信请求的批量用户信息，分页在返回结果cursor里面，且不固定。返回结果集是json字符串，利用列表追加或者扩展的属性进行全局变量赋值，然后写入excel统计查看。

代码如下：

# -*- coding: utf-8 -*-
import requests
import json
import pandas as pd

"""
查看环信注册用户数据
"""
headers = {
   
    'Content-Type': 'application/json',
    "User-Agent": "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.146 Safari/537.36"
}

ulistextend = []
ulistappend = []
def getToken():
    url = "https://a1-vip5.easemob.com/test/test/token"
    dictdata = '''{
	"grant_type":"test",
	"client_id":"test",
	"client_secret":"test"
    }'''
    res = requests.post(url, headers=headers, data=dictdata)
    token = res.content.decode("utf-8"