from openpyxl import Workbook

data = [
    ['姓名', '部門', '成績'],
    ['張三', '銷售部', 89],
    ['李四', '技術部', 95]
]

wb = Workbook()
ws = wb.active
ws.title = "員工成績表"

for row in data:
    ws.append(row)

wb.save("員工成績表.xlsx")
print(" Excel 報表已生成。")

import smtplib
from email.message import EmailMessage

msg = EmailMessage()
msg['Subject'] = '日報 - 自動發(fā)送'
msg['From'] = 'your_email@example.com'
msg['To'] = 'receiver@example.com'
msg.set_content('請查收今日日報，見附件。')

# 添加附件
with open('日報.xlsx', 'rb') as f:
    msg.add_attachment(f.read(), maintype='application',
                       subtype='vnd.openxmlformats-officedocument.spreadsheetml.sheet',
                       filename='日報.xlsx')

# 發(fā)送郵件（使用QQ郵箱為例）
with smtplib.SMTP_SSL('smtp.qq.com', 465) as smtp:
    smtp.login('your_email@example.com', 'your_app_password')
    smtp.send_message(msg)

print(" 郵件已發(fā)送。")

import pdfplumber

with pdfplumber.open('文件.pdf') as pdf:
    all_text = ''
    for page in pdf.pages:
        all_text += page.extract_text() + '\n'

with open('提取內(nèi)容.txt', 'w', encoding='utf-8') as f:
    f.write(all_text)

print(" PDF 文本已提取。")

import webbrowser
import pyautogui
import time

# 打開網(wǎng)頁
webbrowser.open('https://www.google.com')
time.sleep(3)  # 等待頁面加載

# 模擬輸入搜索內(nèi)容
pyautogui.write('Python automation', interval=0.1)
pyautogui.press('enter')

print(" 自動搜索已完成。")

import schedule
import time

def job():
    print("現(xiàn)在是：", time.strftime("%H:%M:%S"), " → 執(zhí)行任務")

# 每天早上 9 點執(zhí)行
schedule.every().day.at("09:00").do(job)

while True:
    schedule.run_pending()
    time.sleep(1)

pip install openpyxl pandas

import pandas as pd
import os

folder = './excel_files'  # Excel 文件所在文件夾
output_file = '合并結果.xlsx'

all_data = []

for file in os.listdir(folder):
    if file.endswith('.xlsx'):
        file_path = os.path.join(folder, file)
        df = pd.read_excel(file_path)
        df['來源文件'] = file  # 可選：添加來源文件列
        all_data.append(df)

# 合并所有數(shù)據(jù)
merged_df = pd.concat(all_data, ignore_index=True)
merged_df.to_excel(output_file, index=False)

print(" 所有 Excel 文件已合并到：", output_file)

import pandas as pd
import os

folder = './excel_files'

for file in os.listdir(folder):
    if file.endswith('.xlsx'):
        path = os.path.join(folder, file)
        df = pd.read_excel(path)

        # 修改 “狀態(tài)” 列中的“未完成”為“完成”
        df['狀態(tài)'] = df['狀態(tài)'].replace('未完成', '完成')

        # 保存覆蓋原文件
        df.to_excel(path, index=False)
        print(f" 已修改：{file}")

import pandas as pd
import os

input_file = '員工信息表.xlsx'
df = pd.read_excel(input_file)

# 篩選工資大于10000的員工
filtered = df[df['工資'] > 10000]

filtered.to_excel('高薪員工.xlsx', index=False)
print(" 篩選結果已保存。")

import pandas as pd
import os

df = pd.read_excel('員工信息.xlsx')

output_dir = './員工報表'
os.makedirs(output_dir, exist_ok=True)

# 按“姓名”分組，每個員工一個文件
for name, group in df.groupby('姓名'):
    filename = os.path.join(output_dir, f'{name}_報表.xlsx')
    group.to_excel(filename, index=False)
    print(f" 已生成：{filename}")

import os
import pandas as pd

# === 配置區(qū)域 ===
input_folder = r"./excel_input"       # 待處理Excel文件所在文件夾
output_folder = r"./excel_output"     # 清洗后文件保存文件夾
subset_columns = None                 # 去重依據(jù)的列，例如 ["姓名", "身份證號"]，None表示全列去重
keep_rule = "first"                   # 保留規(guī)則: "first" 保留首次出現(xiàn), "last" 保留最后一次, False 保留所有重復(不常用)

# 創(chuàng)建輸出文件夾
os.makedirs(output_folder, exist_ok=True)

# 遍歷文件夾中的所有Excel文件
for filename in os.listdir(input_folder):
    if filename.lower().endswith((".xls", ".xlsx")):
        file_path = os.path.join(input_folder, filename)
        
        try:
            # 讀取Excel（保留所有sheet）
            xls = pd.ExcelFile(file_path)
            cleaned_sheets = {}
            
            for sheet_name in xls.sheet_names:
                df = pd.read_excel(xls, sheet_name=sheet_name)
                
                # 去重
                before_rows = len(df)
                df_cleaned = df.drop_duplicates(subset=subset_columns, keep=keep_rule)
                after_rows = len(df_cleaned)
                
                print(f"{filename} - {sheet_name}: {before_rows} -> {after_rows} 行")
                
                cleaned_sheets[sheet_name] = df_cleaned
            
            # 保存清洗后的文件
            output_path = os.path.join(output_folder, filename)
            with pd.ExcelWriter(output_path, engine="openpyxl") as writer:
                for sheet_name, df_cleaned in cleaned_sheets.items():
                    df_cleaned.to_excel(writer, sheet_name=sheet_name, index=False)
        
        except Exception as e:
            print(f"處理文件 {filename} 時出錯: {e}")

print(" 數(shù)據(jù)清洗完成！")