简单生成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开', '神'],['赵梦玥', '一血妹', '女']]})