python 自动下载文件_python 自动下载实现(1)

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]