背景:将爬取到的list存入excel表格
错误:
Traceback (most recent call last):
File "D:/crawler/articles/spiderwxpages.py", line 66, in <module>
main()
File "D:/crawler/articles/spiderwxpages.py", line 58, in main
saveToExcel(article_data)
File "D:/crawler/articles/spiderwxpages.py", line 39, in saveToExcel
ws.append(data)
File "D:\software\anaconda3\lib\site-packages\openpyxl\worksheet\worksheet.py", line 675, in append
self._invalid_row(iterable)
File "D:\software\anaconda3\lib\site-packages\openpyxl\worksheet\worksheet.py", line 811, in _invalid_row
raise TypeError('Value must be a list, tuple, range or generator, or a dict. Supplied value is {0}'.format(
TypeError: Value must be a list, tuple, range or generator, or a dict. Supplied value is <class 'str'>
代码:
for data in article_data:
ws.append(data)
解决方法:
ws.append([data])