我正在嘗試使用 openpyxl 將輸出的社交媒體鏈接保存到 excel 檔案，但出現以下錯誤：
Traceback (most recent call last):
File "/Users/xxxx/_Main_.py", line 40, in <module>
sheet.cell(cell.row, col2).value = ig_get_present
File "/Users/xxxx/venv/lib/python3.10/site-packages/openpyxl/cell/cell.py", line 215, in value
self._bind_value(value)
File "/Users/xxxx/venv/lib/python3.10/site-packages/openpyxl/cell/cell.py", line 184, in _bind_value
raise ValueError("Cannot convert {0!r} to Excel".format(value))
ValueError: Cannot convert ['https://www.instagram.com/xxxx/'] to Excel
這是導致它的代碼，不知道它為什么會發生。
column_name = 'URL'
column_name2 = 'Instagram'
headers = [cell.value for cell in sheet[1]]
col = get_column_letter(headers.index(column_name) 1)
col2 = headers.index(column_name2) 1
for cell in sheet[col][1:]:
url = cell.value
r = requests.get(url)
ig_get = ['instagram.com']
ig_get_present = []
soup = BeautifulSoup(r.content, 'html5lib')
all_links = soup.find_all('a', href=True)
for ig_get in ig_get:
for link in all_links:
if ig_get in link.attrs['href']:
ig_get_present.append(link.attrs['href'])
sheet.cell(cell.row, col2).value = ig_get_present
uj5u.com熱心網友回復：
將資料轉換為字串解決了我的問題。
ig_got = str(ig_get_present)
sheet.cell(cell.row, col2).value = ig_got
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/486878.html
上一篇：使用R進行Web-Scraping-我想從網站中提取一些類似資料的表格
下一篇：硒上的禁用按鈕有問題