#?import?requests
#?newsurl?=?‘http://news.sina.com.cn/china/‘
#?res?=?requests.get（newsurl）
#?res.encoding?=?‘utf-8‘
import?requests
import?time
from?bs4?import?BeautifulSoup

from?openpyxl?import?Workbook
from?openpyxl?import?load_workbook
from?openpyxl.writer.excel?import?ExcelWriter
import?pymysql
from?xpinyin?import?Pinyin
p?=?Pinyin（）
#?db?=?pymysql.Connect（
????#?host?=?“127.0.0.1“
????#?port?=?3306
????#?user?=?“root“
????#?password?=?“root“
????#?db?=?“bigdata“
#?）

#?wb?=?load_workbook（‘d:\\cc.xlsx‘）
#?#?ws?=?wb[‘Sheet1‘]
#?#?ws.cell（11）.value?=?‘序號‘
#?#?ws.cell（12）.value?=?‘小區名稱‘
#?#?ws.cell（13）.value?=?‘省份‘
#?#?ws.cell（14）.value?=?‘城市‘
#?#?ws.cell（15）.value?=?‘區‘
#?#?ws.cell（16）.value?=?‘街道‘
#?#?ws.cell（17）.value?=?‘建成時間‘
#?#?ws.cell（1