功能
爬取猫眼电影TOP100的排名、图片URL、名称、主演、时间以及评分信息,并存入excel中。
示例代码
import requests
from requests.exceptions import RequestException
import re
import xlwt
all_info_list=[]
def create_ecxel(sheet_header):
header = sheet_header
global book
book = xlwt.Workbook(encoding='utf-8')
global sheet
sheet = book.add_sheet('Sheet1')
for h in range(len(header)):
sheet.write(0, h, header[h])
def get_one_page(url):
try:
headers={
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 '
'(KHTML, like Gecko) Chrome/71.0.3578.80 Safari/537.36'
}
response = requests.get(url, headers=headers)
if response.status_code == 200:
return response.text
return None
except RequestExceptio