刚接触Python语言,在网上学习了一个教学视频,然后把视频中的代码敲了一遍,可运行
开发环境:Python 3.6.1 + PyCharm Professional 2017.1.4
Pycharm 下载地址:
excel插件xlwt的
安装方法:
2、右键解压后,执行 setup.py
3、CMD 窗口执行命令:pip install xlwt
# _*_ coding:utf-8 _*_
import xlwt
import urllib.request, re
def getdata():
for i in range(1, 3):
url = 'http://furhr.com/?page={}'.format(i)
try:
html = urllib.request.urlopen(url).read()
html = html.decode('utf-8')
# print(html)
except Exception as e:
print(e)
continue
# <tr><td>15</td><td>104881004090</td><td>中国银行股份有限公司乌鲁木齐市中山路支行</td><td>0991-2326787</td><td>新疆乌鲁木齐市中山路159号</td></tr>
page_list = re.findall(r"<tr><td>\d+</td><td>\d+</td><td>(.*?)</td><td>(.*?)</td><td>(.*?)</td></tr>", html)
return page_list
def excel_write():
newTable = 'test123.xls' # C:\Users\Administrator\PycharmProjects\untitled1\test123.xls
wb = xlwt.Workbook(encoding='utf-8')
ws = wb.add_sheet('sheet1')
headdata = ['公司名称', '电话', '地址']
for colnum in range(0, 3):
ws.write(0, colnum, headdata[colnum], xlwt.easyxf('font:bold on'))
index = 1
for item in items:
for i in range(0, 3):
ws.write(index, i, item[i])
index += 1
wb.save(newTable)
if __name__ == '__main__':
items = getdata()
excel_write()