|
|
发表于 2020-9-10 17:53:02
|
显示全部楼层
本帖最后由 DBArtist 于 2020-9-10 17:55 编辑
我本地测试会有问题：如果是下面这样的会报错：
TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is <class 'str'>
def save_to_excel(result):
wb = openpyxl.Workbook()
ws = wb.active
ws['A1'] = "电影名称"
ws['B1'] = "评分"
ws['C1'] = "资料"
for each in result:
ws.append(each)
wb.save("豆瓣TOP250电影.xlsx")
如果我把ws.append(each)改成ws.append([each])，就不会报错，但是保存的内容是全部都是在A列。
def save_to_excel(result):
wb = openpyxl.Workbook()
ws = wb.active
ws['A1'] = "电影名称"
ws['B1'] = "评分"
ws['C1'] = "资料"
for each in result:
ws.append([each])
wb.save("豆瓣TOP250电影.xlsx")
@小甲鱼 @小甲鱼 |
|
[复制链接]
( 粤ICP备18085999号-1 | 粤公网安备 44051102000585号)
狗仔卡
显身卡
发表于 2020-9-4 08:04:30