python 读取excel中的图片url，下载图片

import xlrd,os,re,time
from xlrd import xldate_as_tuple
import requests
from urllib import request
from io import BytesIO
from PIL import Image

data = xlrd.open_workbook(r'.\郑州洪水暴雨.xlsx')
table = data.sheets()[0]
# 创建一个空列表，存储Excel的数据
tables = []
# 将excel表格内容导入到tables列表中
for rown in range(table.nrows):
    array = {'序号':'','图片url':''}
    array['序号'] = table.cell_value(rown, 0)
    array['图片url'] = table.cell_value(rown, 2)
    tables.append(array)

for i in tables[1:]:
    path = r'E:\a'
    os.chdir(path)
    dirname = str(int(i['序号']))
    print(dirname)
    os.mkdir(dirname)
    path2 = os.path.join(path,dirname)
    print(path2)
    os.chdir(path2)

    imglist = i['图片url'].split(";")[0:-