问尝试遍历滚动条数组并从Web下载所有表

EN

# pip install -U multi-mechanize
import mechanize
mech = mechanize.Browser()
from mechanize import Browser
from BeautifulSoup import BeautifulSoup
from openpyxl import load_workbook
from openpyxl import Workbook

mech = Browser()

tckr = ['SBUX','MSFT','AAPL']
url = "https://finance.google.com/finance?q=NASDAQ:" + tckr + "&fstype=ii"
page = mech.open(url)
html = page.read()
soup = BeautifulSoup(html)
table = soup.find("fs-table", border=1)

url_list = [url + s for s in tckr]

for url in url_list:
    try:
        wb1 = Workbook()
        ws1 = wb1.active
        wb1 = load_workbook('C:/Users/Excel/Desktop/template.xlsx')
        wb1.create_sheet(tckr)
        with open('C:/Users/Excel/Desktop/today.csv', 'a', newline='') as f:   
            for row in table.findAll('tr')[1:]:
                col = row.findAll('td')
                rank = col[0].string
                artist = col[1].string
                album = col[2].string
                cover_link = col[3].img['src']
                record = (rank, artist, album, cover_link)
                print("|".join(record))

    except HTTPError:
        print("{} - not found".format(url))
    wb1.save('C:/Users/Excel/Desktop/template.xlsx')