慕的地6264312
2021-12-26 15:18:56
我當前的代碼將 CSV 寫入多個單元格(請參閱屏幕截圖)from bs4 import BeautifulSoupimport csvimport urlliburl = 'https://www.bhphotovideo.com/c/product/1346734-REG/canon_eos_6d_mark_ii.html'page = urllib.request.urlopen(url)soup = BeautifulSoup(page,'lxml')content = soup.find('div', class_='js-productHighlights product-highlights c28 fs14 js-close')bullets = content.find_all('li', class_='top-section-list-item')csv_file = open('book2.csv', 'w')csv_writer = csv.writer(csv_file)csv_writer.writerow (['headline'])for bullet in bullets: headline = (bullet.string) csv_writer.writerow ([headline])csv_file.close()如何將excel寫入單個單元格?所需的輸出將是 - 單元格 A1 將包含變量“標題”包含的所有文本。
1 回答

呼啦一陣風
TA貢獻1802條經驗 獲得超6個贊
而不是bullets像現(xiàn)在這樣遍歷所有內容并將每個內容寫入 csv 文件:
for bullet in bullets:
headline = (bullet.string)
csv_writer.writerow ([headline])
您可能應該只寫一行,其中包含經過消毒的bullets變量內容。不完全確定您的內容是什么樣的,但請嘗試以下操作:
# your other code...
bullets = content.find_all('li', class_='top-section-list-item')
csv_file = open('book2.csv', 'w')
csv_writer = csv.writer(csv_file)
csv_writer.writerow (['headline'])
# don't loop, instead join values with new line
csv_writer.writerow(['\015'.join([bullet.string for bullet in bullets])])
csv_file.close()
添加回答
舉報
0/150
提交
取消