python从网站拿数据到excel

之前写过一篇文章爬取图片的，有的童鞋就私聊我，说能不能写一篇爬取数据的，便于分析，下面就简单介绍一下爬取网站的商品的步骤：如果你正在追求一个小姐姐，那么我只能帮你到这了。啊哈哈

代码：

import urllib
import xlwt
from bs4 import BeautifulSoup
import requests

def writeExcel(ilt, name):
    if (name != ''):
        count = 0
        workbook = xlwt.Workbook(encoding='utf-8')
        worksheet = workbook.add_sheet('temp')
        worksheet.write(count, 0, '序号')
        worksheet.write(count, 1, '价格')
        worksheet.write(count, 2, '名称')
        for g in ilt:
            count = count + 1
            worksheet.write(count, 0, count)
            worksheet.write(count, 1, g[0])
            worksheet.write(count, 2, g[1])
        workbook.save(name + '.xls')
        print('已保存为：' + name + '.xls')
    else:
        printGoodsList(ilt)

def getHTMLText(url):
    kv &#