摘要：import matplotlib.pyplot as pltplt.bar(df['产品'], df['销售额'])plt.title('2025年Q1销售分析')plt.savefig('sales_chart.png')from docx import
在数字化办公时代，握Python自动化技能已成为职场竞争力的关键指标。本文将通过系统化的知识框架，带您从零基础快速掌握Python办公自动化核心技能。
pip install pandas openpyxl python-docx PyPDF2 python-pptx smtplib pillow
import matplotlib.pyplot as pltplt.bar(df['产品'], df['销售额'])plt.title('2025年Q1销售分析')plt.savefig('sales_chart.png')from docx import Documentdoc = Document('template.docx')doc.add_paragraph(f"当前日期：{datetime.date.today}")doc.save('report.docx')from docx import Documentfrom docx.enum.text import WD_ALIGN_PARAGRAPHdef generate_contract(name, amount):doc = Documentdoc.add_heading("销售合同", 0)doc.add_paragraph(f"甲方：{name}")doc.add_paragraph(f"金额：{amount}元")doc.save(f"{name}_contract.docx")from PyPDF2 import PdfMergermerger = PdfMergermerger.append("report1.pdf")merger.append("report2.pdf")merger.write("merged_report.pdf")merger.closefrom PyPDF2 import PdfReaderreader = PdfReader("document.pdf")text = ""for page in reader.pages:text += page.extract_textprint(text)import smtplibfrom email.mime.text import MIMETextfrom email.utils import formatdatemsg = MIMEText("自动化发送测试邮件")msg['Subject'] = "测试邮件"msg['From'] = "sender@example.com"msg['To'] = "recipient@example.com"msg['Date'] = formatdatewith smtplib.SMTP("smtp.example.com", 587) as server:server.starttlsserver.login("user", "password")server.send_message(msg)from email.mime.application import MIMEApplicationfrom email.mime.multipart import MIMEMultipartmsg = MIMEMultipartwith open("report.pdf", "rb") as f:attach = MIMEApplication(f.read, _subtype="pdf")attach.add_header('Content-Disposition', 'attachment', filename="report.pdf")msg.attach(attach)import osimport shutildef organize_files(source_dir):for filename in os.listdir(source_dir):file_path = os.path.join(source_dir, filename)if os.path.isfile(file_path):ext = filename.split('.')[-1].lowertarget_dir = os.path.join(source_dir, ext)os.makedirs(target_dir, exist_ok=True)shutil.move(file_path, os.path.join(target_dir, filename))import scheduleimport timedef daily_backup:shutil.copy2("data.xlsx", "backup/")schedule.every.day.at("00:00").do(daily_backup)while True:schedule.run_pendingtime.sleep(1)import pyautoguifrom PIL import Imageimport pytesseractscreenshot = pyautogui.screenshotscreenshot.save('screenshot.png')text = pytesseract.image_to_string(Image.open('screenshot.png'))import pyautoguiimport timepyautogui.click(100, 200) # 移动并点击坐标pyautogui.typewrite("Hello World") # 输入文字pyautogui.hotkey('ctrl', 's') # 组合键操作来源：TigerOnHill一点号
