worktest/caiji.py at master · foxjojo/worktest · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
#coding=utf-8
from urllib.request import urlopen
from bs4 import BeautifulSoup
import time
import xlwt

workbook = xlwt.Workbook()
sheet1 = workbook.add_sheet('sheet1',cell_overwrite_ok=True)
sheet1.write(0,0,'序号')
sheet1.write(0,1,'通用名' )
sheet1.write(0,2,'剂型')
sheet1.write(0,3,'规格')
sheet1.write(0,4,'生产企业')
sheet1.write(0,5,'进口企业')
sheet1.write(0,6,'企业报价')

def stores(ids,commonname,types,sizes,output,inputs,prices):
	global sheet1
	sheet1.write(int(ids),0,ids)
	sheet1.write(int(ids),1,commonname)
	sheet1.write(int(ids),2,types)
	sheet1.write(int(ids),3,sizes)
	sheet1.write(int(ids),4,output)
	sheet1.write(int(ids),5,inputs)
	sheet1.write(int(ids),6,prices)

def handle_html(url):
	html = urlopen(url)
	bsObj = BeautifulSoup(html, "html.parser")
	title = bsObj.find("tbody").find_all("tr")
	for tr in title:
		td = tr.find_all("td")
		#print(td[0].get_text()+" "+td[1].get_text()+" "+td[2].get_text()+" "+td[3].get_text()+" "+td[4].get_text()+" "+td[5].get_text()+" "+td[6].get_text())
		stores(td[0].get_text(), td[1].get_text(), td[2].get_text(), td[3].get_text(), td[4].get_text(), td[5].get_text(), td[6].get_text())
if __name__ == '__main__':
    global workbook
    handle_html("http://www.jxyycg.cn/yzxt/publicity/view?id=eb1a21f2ab6a40119544e9048417bc1f")
    workbook.save('D:\\'+time.strftime("%Y-%m-%d", time.localtime())+'.xls')
    print ('创建excel文件完成！')