
import openpyxl
import urllib.request
wb = openpyxl.load_workbook('관리종목.xlsx')
sheet = wb['종목']
new_rows = list(sheet.rows)[1:]
for row in new_rows:
url = f'https://ssl.pstatic.net/imgfinance/chart/item/area/year3/{row[1].value}.png'
urllib.request.urlretrieve(url, f"imgs/{row[0].value}.png")
FileNotFoundError Traceback (most recent call last)
<ipython-input-95-ee36528f748c> in <cell line: 9>()
9 for row in new_rows:
10 url = f'https://ssl.pstatic.net/imgfinance/chart/item/area/year3/{row[1].value}.png'
---> 11 urllib.request.urlretrieve(url, f"imgs/{row[0].value}.png")
/usr/lib/python3.10/urllib/request.py in urlretrieve(url, filename, reporthook, data)
249 # Handle temporary file setup.
250 if filename:
--> 251 tfp = open(filename, 'wb')
252 else:
253 tfp = tempfile.NamedTemporaryFile(delete=False)
FileNotFoundError: [Errno 2] No such file or directory: 'imgs/삼성전자.png'
