Python 3.6
主要库:
openpyxl:对excel文件进行读、写;
requests:下载文件
从excel中取出下载链接,通过requests.head(url)得到头信息,过滤非apk文件或大于100.00M的文件(可按需修改),再利用requests下载文件。
import openpyxl
import re
import requests
import os.path
from sys import argv
from openpyxl import Workbook
from datetime import datetime
url = ''
count = 0
def download_apk(num, url):
"""
下载文件
:param url:下载链接
:param num:索引值
"""
global count
succeed = 'Succeed'
failure = 'Failure'
print('第' + str(num) + '条url:\n' + url)
filename = os.path.basename(url)
filename = filename.split('?')[0]
response = requests.head(url)
filesize = round(float(response.headers['Content-Length']) / 1048576, 2)
apk_format = 'application/vnd.android.package-archive'
#