Python中使用 xlrd + requests下载excel表中的jpg图像或mp4视频
import requests
import xlrd
# 读取xls格式的文件,读取全部的数据,以最大的行和最大的列来计算
def read_xls_all(url):
'''
url:文件的路径
返回值:表格中的数据
'''
# 打开指定的工作簿
workbook = xlrd.open_workbook(url)
# 获取工作簿中所有的表格
sheets = workbook.sheet_names() # sheets: ['Sheet1', 'Sheet2', 'Sheet3']
print('sheets:', sheets)
# 获取index的表格
worksheet = workbook.sheet_by_name(sheets[1])
print('worksheet:', worksheet.nrows)
# 遍历每一行数据
for i in range(0, worksheet.nrows):
for j in range(0, worksheet.ncols):
# 遍历每一列数据
a=worksheet.cell_value(i, j)
print(a)
if a.endswith("mp4"):
# 下载mp4视频
mp4 = requests.get(a)
with open("/disk2/ruqinjiance/mp4-20240524/" + f'{i}.mp4', 'wb') as f:
f.write(mp4.content)
elif a.endswith("jpg"):
# 下载jpg图片
jpg = requests.get(a)
with open("/disk2/ruqinjiance/jpg-20240524/"+f'{i}.jpg', 'wb') as f:
f.write(jpg.content)
if __name__ == '__main__':
url = '/disk2/ruqinjiance/data20240524.xls'
read_xls_all(url)