做个记录方便回看
import numpy as np
from pandas import DataFrame
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows
# 数据类型转换为dataframe#index,行名,columns,列名
data_frame = DataFrame(columns=['店名','有关直播的信息','好物一栏/商品信息'],data =[[A],[B],[C]])#ABC本身就是列表
print(dataframe)
# 创建工作簿,写入,并保存
wb = Workbook()
ws = wb.active
ws.title = 'data' # 工作表名字
for x in dataframe_to_rows(data_frame):
ws.append(x)
wb.save('data_file.xlsx')