import openpyxl
import urllib.request
import time
import os
import re
filePath= "F:/download/"#换成自己的下载目录地址
wb= openpyxl.load_workbook('file/allhref.xlsx')
#换成自己的exal目录
sheets=wb.sheetnames
# print(sheets, type(sheets))
import dowloadXunlei
def getHref(ws):
# print(ws['A']) A一竖列
#循环B数列
i= 0
for href in ws['B']:
name= (ws['A'][i].value)
i= i + 1
if href.value != 'href':
getFileType(href.value, name)
def getFileType(url, name):if(re.search("jpg",url)):
dowloadPic(url, name)
elif(re.search("rmvb",url)):
dowloadXunlei.download(url, name)
elif(re.search("mkv",url)):
dowloadXunlei.download(url, name)
elif(re.search("mp4",url)):
dowloadXunlei.download(url, name)
def dowloadPic(url, fileName):
response=urllib.request.urlopen(url)
data=response.read()
t= int(time.time() * 1000)
os.mkdir("download/"+fileName)
name= filePath +fileName+"/"+ '%d'%t+".jpg"print(name)
with open(name,'wb') ascode:
code.write(data)
print('finish')for sheet insheets: # 循环表if(sheet == 'Sheet1'): getHref(wb[sheet])
# wb[sheet]