擅长:python、mysql、java
<p>要读取excel,请使用<code>xlrd</code>库。在<code>sheet.cell_value(i, 0)</code>中,<code>i</code>是<code>row</code>索引,<code>0</code>是列索引。根据excel数据更改列索引。在</p>
<p>定义报废函数和返回值,必要时追加到另一个列表中。在您的例子中,您只是在打印,所以我返回<code>None</code></p>
<pre><code>import xlrd
from selenium import webdriver
# Give the location of the file
def scrapping(browser, links):
browser.get(links)
website_link_anchor = browser.find_element_by_xpath("//dd[@class='website']/a")
actual_website_link = website_link_anchor.get_attribute("href")
print(actual_website_link)
return None
driver = webdriver.Chrome()
loc = ("path of file")
# To open Workbook
wb = xlrd.open_workbook(loc)
sheet = wb.sheet_by_index(0)
# links = []
for i in range(1, sheet.nrows):
scrapping(driver, sheet.cell_value(i, 0))
# links.append(sheet.cell_value(i, 0))
driver.close()
</code></pre>