import xlwings as xw
wb = xw.Book()  # this will create a new workbook
wb = xw.Book('FileName.xlsx')  # connect to a file that is open or in the current working directory
wb = xw.Book(r'C:\path\to\file.xlsx')  # on Windows: use raw strings to escape backslashes

import matplotlib.pyplot as plt
import xlwings as xw
fig = plt.figure()
plt.plot([1, 2, 3])
sheet = xw.Book().sheets[0]
sheet.pictures.add(fig, name='MyPlot', update=True)

import PyPDF2
pdfFile = open('example.pdf','rb')
pdfReader = PyPDF2.PdfFileReader(pdfFile)
print(pdfReader.numPages)
page = pdfReader.getPage(0)
print(page.extractText())
pdfFile.close()

# 提取pdf表格
import pdfplumber
with pdfplumber.open("example.pdf") as pdf:
    page01 = pdf.pages[0] #指定頁碼
    table1 = page01.extract_table()#提取單個表格
    # table2 = page01.extract_tables()#提取多個表格
    print(table1)

import smtplib
import email
# 負(fù)責(zé)將多個對象集合起來
from email.mime.multipart import MIMEMultipart
from email.header import Header
# SMTP服務(wù)器,這里使用163郵箱
mail_host = "smtp.163.com"
# 發(fā)件人郵箱
mail_sender = "******@163.com"
# 郵箱授權(quán)碼,注意這里不是郵箱密碼,如何獲取郵箱授權(quán)碼,請看本文最后教程
mail_license = "********"
# 收件人郵箱，可以為多個收件人
mail_receivers = ["******@qq.com","******@outlook.com"]
mm = MIMEMultipart('related')
# 郵件正文內(nèi)容
body_content = """你好，這是一個測試郵件！"""
# 構(gòu)造文本,參數(shù)1：正文內(nèi)容，參數(shù)2：文本格式，參數(shù)3：編碼方式
message_text = MIMEText(body_content,"plain","utf-8")
# 向MIMEMultipart對象中添加文本對象
mm.attach(message_text)
# 創(chuàng)建SMTP對象
stp = smtplib.SMTP()
# 設(shè)置發(fā)件人郵箱的域名和端口，端口地址為25
stp.connect(mail_host, 25)  
# set_debuglevel(1)可以打印出和SMTP服務(wù)器交互的所有信息
stp.set_debuglevel(1)
# 登錄郵箱，傳遞參數(shù)1：郵箱地址，參數(shù)2：郵箱授權(quán)碼
stp.login(mail_sender,mail_license)
# 發(fā)送郵件，傳遞參數(shù)1：發(fā)件人郵箱地址，參數(shù)2：收件人郵箱地址，參數(shù)3：把郵件內(nèi)容格式改為str
stp.sendmail(mail_sender, mail_receivers, mm.as_string())
print("郵件發(fā)送成功")
# 關(guān)閉SMTP對象
stp.quit()

import pymysql
# 打開數(shù)據(jù)庫連接
db = pymysql.connect(host='localhost',
                     user='testuser',
                     password='test123',
                     database='TESTDB') 
# 使用 cursor() 方法創(chuàng)建一個游標(biāo)對象 cursor
cursor = db.cursor()
# 使用 execute()  方法執(zhí)行 SQL 查詢 
cursor.execute("SELECT VERSION()")
# 使用 fetchone() 方法獲取單條數(shù)據(jù).
data = cursor.fetchone()
print ("Database version : %s " % data)
# 關(guān)閉數(shù)據(jù)庫連接
db.close()

import os,shutil
import sys
import numpy as np
def arrange_file(dir_path0):
  for dirpath,dirnames,filenames in os.walk(dir_path0):
    if 'my_result' in dirpath:
      # print(dirpath)
      shutil.rmtree(dirpath)

import os
def file_rename():
    path = input("請輸入你需要修改的目錄(格式如'F:\\test')：")
    old_suffix = input('請輸入你需要修改的后綴（需要加點(diǎn).）：')
    new_suffix = input('請輸入你要改成的后綴（需要加點(diǎn).）：')
    file_list = os.listdir(path)
    for file in file_list:
        old_dir = os.path.join(path, file)
        print('當(dāng)前文件：', file)
        if os.path.isdir(old_dir):
            continue
        if old_suffix != os.path.splitext(file)[1]:
            continue
        filename = os.path.splitext(file)[0]
        new_dir = os.path.join(path, filename + new_suffix)
        os.rename(old_dir, new_dir)
if __name__ == '__main__':
    file_rename()

# 獲取鼠標(biāo)位置
import pyautogui as pg
try:
    while True:
        x, y = pg.position()
        print(str(x) + " " + str(y))  #輸出鼠標(biāo)位置
        if 1746 < x < 1800 and 2 < y < 33:
            pg.click()#左鍵單擊
        if 1200 < x < 1270 and 600 < y < 620:
            pg.click(button='right')#右鍵單擊
        if 1646 < x < 1700 and 2 < y < 33:
            pg.doubleClick()#左鍵雙擊
except KeyboardInterrupt:
    print("\n")

import pyautogui
#typewrite()無法輸入中文內(nèi)容，中英文混合的只能輸入英文
#interval設(shè)置文本輸入速度，默認(rèn)值為0
pyautogui.typewrite('你好，world!',interval=0.5)

import zipfile
try:
  with zipfile.ZipFile("c://test.zip",mode="w") as f:
    f.write("c://test.txt")          #寫入壓縮文件，會把壓縮文件中的原有覆蓋
except Exception as e:
    print("異常對象的類型是:%s"%type(e))
    print("異常對象的內(nèi)容是:%s"%e)
finally:
    f.close()

import zipfile
try:
  with zipfile.ZipFile("c://test.zip",mode="a") as f:
     f.extractall("c://",pwd=b"root") ##將文件解壓到指定目錄，解壓密碼為root
except Exception as e:
     print("異常對象的類型是:%s"%type(e))
     print("異常對象的內(nèi)容是:%s"%e)
finally:
     f.close()

# 導(dǎo)入urlopen
from urllib.request import urlopen
# 導(dǎo)入BeautifulSoup
from bs4 import BeautifulSoup as bf
# 導(dǎo)入urlretrieve函數(shù)，用于下載圖片
from urllib.request import urlretrieve
# 請求獲取HTML
html = urlopen("http://www.baidu.com/")
# 用BeautifulSoup解析html
obj = bf(html.read(),'html.parser')
# 從標(biāo)簽head、title里提取標(biāo)題
title = obj.head.title
# 只提取logo圖片的信息
logo_pic_info = obj.find_all('img',class_="index-logo-src")
# 提取logo圖片的鏈接
logo_url = "https:"+logo_pic_info[0]['src']
# 使用urlretrieve下載圖片
urlretrieve(logo_url, 'logo.png')

from PIL import Image
from PIL import ImageEnhance
img_main = Image.open(u'E:/login1.png')
img_main = img_main.convert('L')
threshold1 = 138
table1 = []
for i in range(256):
  if i < threshold1:
    table1.append(0)
  else:
    table1.append(1)
img_main = img_main.point(table1, "1")
img_main.save(u'E:/login3.png')

import numpy as np
import matplotlib.pyplot as plt
N = 5
menMeans = (20, 35, 30, 35, 27)
womenMeans = (25, 32, 34, 20, 25)
menStd = (2, 3, 4, 1, 2)
womenStd = (3, 5, 2, 3, 3)
ind = np.arange(N)    # the x locations for the groups
width = 0.35       # the width of the bars: can also be len(x) sequence
p1 = plt.bar(ind, menMeans, width, yerr=menStd)
p2 = plt.bar(ind, womenMeans, width,
             bottom=menMeans, yerr=womenStd)
plt.ylabel('Scores')
plt.title('Scores by group and gender')
plt.xticks(ind, ('G1', 'G2', 'G3', 'G4', 'G5'))
plt.yticks(np.arange(0, 81, 10))
plt.legend((p1[0], p2[0]), ('Men', 'Women'))
plt.show()