擅长:python、mysql、java
<p>要解决这个问题,您可以迭代(key,value)元组的字典项,然后像列表一样获得这些项中每个项的key和value。键位于项的位置0,值位于位置1</p>
<pre><code>import re
import requests
from bs4 import BeautifulSoup
from openpyxl import load_workbook
wb = load_workbook('container.xlsx')
ws = wb['Sheet1']
url = "https://abr.business.gov.au/ABN/View?id=78007306283"
response = requests.get(url)
soup = BeautifulSoup(response.text,'lxml')
try:
names_n_dates = {item.find("a").get_text(strip=True):' '.join(item.find("a").find_parent().find_next_sibling().text.split()) for item in soup.find("th",text=re.compile("Business name",re.I)).find_parent().find_next_siblings("tr")}
except AttributeError: names_n_dates = ""
row = []
for item in dict.items(): #iterate over all dict items
row.append(item[0]) #key
row.append(item[1]) #value
ws.append(row)
wb.save("container.xlsx")
</code></pre>