擅长:python、mysql、java
<p>如果您想保持<code>ws.append()</code>如您所愿(将一个列表追加为一行),请执行以下操作:</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 names_n_dates.items():
for column in item:
row.append(column)
ws.append(row)
wb.save("container.xlsx")
</code></pre>