下載第三方模塊的句式
	pip install 模塊名
下載第三方模塊臨時(shí)切換倉庫
	pip install 模塊名 -i 倉庫地址
下載第三方模塊指定版本(不指定默認(rèn)是最新版)
	pip install 模塊名==版本號(hào) -i 倉庫地址

import requests

url = "https://www.baidu.com"
res = requests.get(url)

res = encoding = 'utf8'

print(res.content)
# 返回的是一個(gè)原生字符串，是bytes類型

print(res.text)
# 獲取字符串類型的網(wǎng)頁數(shù)據(jù)(默認(rèn)按照utf8)

print(res.url)

print(res.staus_code)

import re
import requests
from openpyxl import Workbook
url = 'https://sh.lianjia.com/ershoufang/pg1/'
for i in range(1, 101):
    url = f"https://sh.lianjia.com/ershoufang/pg{i}/"
    print(url)
    res = requests.get(url)
    url_data = res.text
    home_biaoqian = re.findall(
        """data-is_focus="" data-sl="">(.*?)</a>""",
        url_data)
    home_xiaoqu_name = re.findall(
        """<a href="https:.*?" rel="external nofollow"  target="_blank" data-log_index=".*?" data-el=".*?">(.*?)</a>""",
        url_data)
    home_xiaoqu_dir = re.findall("""<a  rel="external nofollow"  target="_blank">(.*?)</a>""",
                                 url_data)
    home_jutixinxi = re.findall("""<div class="houseInfo"><span class="houseIcon"></span>(.*?)</div>""", url_data)
    home_guanzhudu = re.findall("""<div class="followInfo"><span class="starIcon"></span>(.*?)</div>""", url_data)
    home_zongjia = re.findall("""<span class="">(.*?)</span>""", url_data)
    home_danjia = re.findall("""<span>(.*?)</span>""", url_data)
    home_data = zip(home_xiaoqu_name, home_xiaoqu_dir, home_biaoqian, home_jutixinxi, home_guanzhudu, home_zongjia,
                    home_danjia)
    with open(r'sh_.txt', 'w', encoding='utf8') as f:
        for i in home_data:
            f.write('''
                小區(qū)名稱：%s
                小區(qū)地址：%s
                小區(qū)標(biāo)簽：%s
                詳情：%s
                關(guān)注度：%s
                總價(jià)：%s
                單價(jià)：%s\r
                '''%i)

導(dǎo)入模塊：
	form openpyxl import workbook
代碼用法：
	from openpyxl import Workbook
    wb = Workbook
	 # 一個(gè) excel 文件創(chuàng)建成功

導(dǎo)入模塊：
	form openpyxl import workbook
代碼用法：
	from openpyxl import Workbook
	wb = Workbook()
	ws1 = wb.cerate_sheet('工作簿名稱'， 0)

導(dǎo)入模塊：
	form openpyxl import workbook
代碼用法：
	from openpyxl import Workbook
	wb = Workbook()
	ws1 = wb.cerate_sheet('用戶信息表'， 0)
	ws1.title = 'user_infor'

導(dǎo)入模塊：
	from openpyxl import Workbook
    wb = Workbook()
    ws1 = wb.create_sheet('用戶信息表', 0)
    ws1.sheet_properties.tabColor = 'FF6666' 
    # 將標(biāo)題背景改為指定RRGGBB顏色代碼

導(dǎo)入模塊：
	from openpyxl import Workbook
代碼用法：
	wb = Workbook()
	ws1 = wb.create_sheet('uese_zhangzhang')
	ws2 = wb.create_sheet('user_kangkang')
	print(wb.sheetname)
	# ['user_zhangzhang', 'user_zhangzhang']                

導(dǎo)入模塊：
	from openpyxl import Workbook
代碼用法：
	wb = Workbook()
	ws1 = wb.create_sheet('uese_zhangzhang')
	ws1['A1'] = 'kangkang'
	# ws1['A1'] 代表的是該表中的 A1 位置，我們可以將數(shù)據(jù)直接賦值給它

導(dǎo)入模塊：
	from openpyxl import Workbook
代碼用法：
	wb = Workbook()
	ws1 = wb.create_sheet('uese_zhangzhang')
	ws1.cell(row = 1, column= 1, value = 'kangkang')
	# 在第一行，第一列，填入數(shù)值'kangkang'

導(dǎo)入模塊：
	from openpyxl import Workbook
代碼用法：
	wb = Workbook()
	ws = wb.cerate_sheet('user_name'， 0)
	ws.append(['序號(hào)'， '姓名'， '性別'， '年齡'])
	ws.append(['1'， 'kangkang'， '男'， '18'])

x = ws['A1':'C2']
x1 = ws['C']
x2 = ws['C:D']
x3 = ws[10]
x4 = ws[5:10]

導(dǎo)入模塊：
	from openpyxl import Workbook
代碼用法：
	wb = Wordbook()
	ws1 = wb.create_sheet('nser_name', 0)
	ws1.append(['name', 'age', 'hobby'])
	ws1.append(['kangkang', 18, 'read'])
	for i in ws1.vallue:
        print(i)

wb = Workbook()
wb.save('user_infor.xlsx') 
# balances.xlsx 是保存的路徑，也就是文件名。
# 編輯完要保存才行。

from openpyxl import load_workbook

from openpyxl import load_workbook
wb = load_workbook('ex_a.xlsx', read_only=True, data_only=True)
ws = wb['用戶信息表']  # 拿到工作薄對(duì)象
print(ws['A1'].value)  # 取出工作薄對(duì)象中 A1 位置的值

from openpyxl import load_workbook
wb = load_workbook('ex_a.xlsx', read_only=True, data_only=True)
ws = wb['用戶信息表']
print(ws.cell(row=2, column=1).value)  # 通過行與列的形式來取值

方式三（逐行讀?。?
from openpyxl import load_workbook
wb = load_workbook('ex_a.xlsx', read_only=True, data_only=True)
ws = wb['用戶信息表']
for row in ws.rows:  # 獲取每一行的數(shù)據(jù)
	for data in row:  # 獲取每一行中單元格的數(shù)據(jù)
		print(data.value)  # 打印單元格的值