python办公实用的小代码
时间: 2024-05-14 19:11:13 浏览: 15
当然,以下是几个 Python 办公实用小代码:
1. 自动发送邮件
可以使用 smtplib 模块来发送邮件。以下是一个示例代码:
```python
import smtplib
from email.mime.text import MIMEText
mail_host = 'smtp.163.com'
mail_user = 'username'
mail_pass = 'password'
sender = 'sender@example.com'
receivers = ['receiver1@example.com', 'receiver2@example.com']
message = MIMEText('This is a test email')
message['Subject'] = 'Test Email'
message['From'] = sender
message['To'] = ','.join(receivers)
smtpObj = smtplib.SMTP()
smtpObj.connect(mail_host, 25)
smtpObj.login(mail_user, mail_pass)
smtpObj.sendmail(sender, receivers, message.as_string())
smtpObj.quit()
```
2. 批量处理 Excel 文件
可以使用 openpyxl 模块来处理 Excel 文件。以下是一个示例代码:
```python
from openpyxl import load_workbook
wb = load_workbook(filename='example.xlsx')
ws = wb.active
for row in ws.rows:
for cell in row:
print(cell.value)
wb.save('example.xlsx')
```
3. 自动化操作网页
可以使用 selenium 模块来自动化操作网页。以下是一个示例代码:
```python
from selenium import webdriver
driver = webdriver.Chrome()
driver.get('https://www.baidu.com/')
search_box = driver.find_element_by_css_selector('#kw')
search_box.send_keys('Python')
search_box.submit()
driver.quit()
```
希望这些代码可以帮助到你!如果你有任何其他问题或者需要更多帮助,欢迎随时提出。