Importing External Data into Excel using Python смотреть онлайн

In this video I am going to show you how to import external data into your excel sheets. In this iteration, however, we are going to do this using web scraping with Python, BeautifulSoup and Requests. If this video was helpful please consider liking or subscribing - it would help me out a lot!

The Code for the Script:

import bs4
import requests
import openpyxl

wb = openpyxl.load_workbook('**File Path**')
sheet = wb['**Sheet Name**']

r = requests.get('https://finance.yahoo.com/quote/AAPL?p=AAPL&.tsrc=fin-srch&guce_referrer=aHR0cHM6Ly9maW5hbmNlLnlhaG9vLmNvbS8_Z3VjZV9yZWZlcnJlcj1hSFIwY0hNNkx5OTNkM2N1WjI5dloyeGxMbU52YlM4Jmd1Y2VfcmVmZXJyZXJfc2lnPUFRQUFBTXJRZlphTm1qRE1FZHplWm1ra29pRU54cDdYSV9vQy1abmUxd0xLV2FmS1MyUXhYN2E2NXZ5SVZlSWxSTDRCY3NGVlJPUFcyN1NZSkFQa2pSSG04Vk55WTdSZURsa2lHaHEySVFqaGpNcS1oZnVHRXA4V2xiMDFTYlFwTW11YUtVTi1CclFRT3NldW9PN1R3ZVRIeFFmRUNNOTB6VWlSa05URHZQRE42ajUzJl9ndWNfY29uc2VudF9za2lwPTE1OTY5MjU5OTQ&guce_referrer_sig=AQAAAJ9MJIO1Wuuv3tlhwx4XmafEYzNBlBVxwIatIdwmph_PD_6084ClbHd_100qrWH_CLANySK5gXDU6YhzkO7rH9ZxYBQr6CzY9dGHz8w8hfXIul_aCdIwtNSr3oJIuInWm5edw2AsMmn_gsDRgysYheSjyBDl-zHW2mxnDcLsvU-B&_guc_consent_skip=1596926000')
soup = bs4.BeautifulSoup(r.text, features='html.parser')
priceAAPL = soup.find_all('div', {'class', 'D(ib) Mend(20px)'})[0].find('span').text.replace('.', ',')

v = sheet.cell(row=7, column=6).value = priceAAPL
wb.save('**File Path**')