爬虫并储存于excel

# 简单爬取并储存在excel中 成功
# coding=utf-8
import bs4

import re

import random
from openpyxl import workbook  # 写入Excel表所用
import time
import re
import requests
import xlsxwriter

url="http://changyongdianhuahaoma.51240.com/"

headers={
    "User-Agent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)\
     Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0"
}

response=requests.get(url, headers=headers)

print(response.status_code)
result=response.text
bs = bs4.BeautifulSoup(result, features='html.parser')

Name=[]
nameList = bs.find_all("tr", bgcolor="#EFF7F0")
for i in nameList:
    Name.append(i.text)

print(Name)
'''for i in range(len(Name)):
    ws.append([Name[i], Introductions[i]])'''

wb = workbook.Workbook()  # 创建Excel对象
ws = wb.active  # 获取当前正在操作的表对象
# 往表中写入标题行,以列表形式写入！
ws.append(['角色名字', '票数'])

for i in range(len(Name)):
    ws.append([i, Name[i]])

wb.save('hhaha.xlsx')  # 存入所有信息后，保存为filename.xlsx