python抓取视频真实地址_快手批量获取真实地址python

import requests

from bs4 import BeautifulSoup

import re

import xlrd

import xlwt

class KSNoMark():

# 忽略警告代码

requests.packages.urllib3.disable_warnings()

def GetShareUrl(self):

try:

# 打开Excel表格

wb = xlrd.open_workbook('分享链接.xlsx')

# 获取当前正在显示的sheet

sheet = wb.sheet_by_name('url')

urls = [(sheet.cell_value(i, 0))for i in range(1, sheet.nrows)]

while '' in urls:

urls.remove('')

except FileNotFoundError:

print("分享链接.xlsx文件不存在")

return urls

def GetRealUrl(self):

headers = {

'User-Agent': 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1',

'Cookie': 'did=web_e4581e2dbe33aa