with open("data/demo猫眼电影TOP100.txt", 'r', encoding='UTF8') as f: # 迭代读取文件的每一行 for line in f.readlines(): # 将读取到的内容转化为python对象 data = json.loads(line) yield data def write_to_excel(): # 创建一个工作簿 w = Workbook() # 获取当前工作表 w_s = w.act...