需安装python库：requests和openpyxl

import requests
import openpyxl #导入库

wb = openpyxl.load_workbook("dc.xlsx") #加载有模型编号的表格
path = "https://patch.real.dckr.shiftupcorp.com/real.170.z75lr26owob1/hd_android/asset/character/"
#模型网站

wsheet = wb["Sheet1"]#选择工作簿1

for data in wsheet.rows:#遍历表格
    productName = data[0].value #第一列赋值给productName
    url = path + productName +".pck" #拼合url
   
 r = requests.get(url)
    with open (productName + ".pck", "wb") as code:#保存文件为模型的编号
        code.write(r.content)
        print(url)
    print("ok啦！")