导出django数据库

 

 

def to_csv(quert_set, path, *args):
    """
    :param quert_set: TB.objects.all().values_list()
    :param path: 文件保存路径
    :param args: *['字段1','字段2',...] 
    :return:
    """
    result = []
    for item in quert_set:
        result.append(item)

    result.sort()

    lst = list(zip(*result))

    from pandas import DataFrame
    import collections

    data = collections.OrderedDict({})
    for i in range(len(args)):
        data[args[i]] = lst[i]

    df = DataFrame(data)

    df.to_excel('%s.xlsx' % path)