简单生成excel文件

import os
import xlwt


def save_to_excel(check_date, data):
    book = xlwt.Workbook(encoding='utf-8', style_compression=0)

    for sheet_name, item in data.items():
        sheet = book.add_sheet(sheet_name, cell_overwrite_ok=True)
        for i in range(0, len(item)):  # 写入字段信息
            for j in range(0, len(item[i])):
                sheet.write(i, j, str(item[i][j]))
    # 记住要保存
    filename = '{}-long-bill.xls'.format(check_date)
    filepath = '/Users/dzsbamacbookair/Desktop/script/lianxi/{}'.format(filename)

    book.save(filepath)

    # if os.path.exists(filepath) and os.path.isfile(filepath):  # 检测文件是已经存在
    #     os.remove(filepath)  # 删除文件


if __name__ == '__main__':
    save_to_excel('20210710',{'通道长单': [['主播', '诨名', '性别'],['卢本伟', '55开', '神'],['赵梦玥', '一血妹', '女']]})