openpyxl库 写入数据时出现错误 raise ValueError("Cannot convert {0!r} to Excel".format(value))
故做一个笔记进行错误的记录
经过检查,传入的代码list格式为[['',''],['',''],['','']]
不符合sheet.append所需的格式
list1 = [['1','2'],['3','4'],['5','6']]
workbook = openpyxl.load_workbook(excel_path)
sheet = workbook['SheetName']
for one_list in list1:
sheet.append(one_list)
workbook.save(excel_path)
将其通过for循环提取写入即可。