# 批量安裝核心依賴庫（指定穩(wěn)定版本，避免版本兼容問題）
# pip install openpyxl==3.1.2 pandas==2.0.3 python-docx==0.8.16 PyPDF2==2.12.1 pdfplumber==0.9.0

# 環(huán)境驗(yàn)證代碼
import openpyxl
import pandas as pd
import docx
import PyPDF2
import pdfplumber
import smtplib

print("環(huán)境驗(yàn)證通過：")
print(f"openpyxl版本：{openpyxl.__version__}")
print(f"pandas版本：{pd.__version__}")
print(f"python-docx版本：{docx.__version__}")
print(f"PyPDF2版本：{PyPDF2.__version__}")
print(f"pdfplumber版本：{pdfplumber.__version__}")
print(f"smtplib版本：{smtplib.__version__}")  # Python內(nèi)置，版本與Python一致
    

from openpyxl import Workbook
from openpyxl.styles import Font, PatternFill, Alignment
from openpyxl.utils.dataframe import dataframe_to_rows

def batch_generate_excel_reports(data_list, save_dir):
    """
    批量生成帶格式的Excel報(bào)表
    :param data_list: 數(shù)據(jù)列表，每個(gè)元素是字典（含報(bào)表數(shù)據(jù)）
    :param save_dir: 保存目錄
    """
    for idx, data in enumerate(data_list):
        # 1. 創(chuàng)建工作簿
        wb = Workbook()
        ws = wb.active
        ws.title = "月度報(bào)表"
        
        # 2. 寫入標(biāo)題并設(shè)置樣式
        ws["A1"] = f"{data['部門']}2024年{data['月份']}度報(bào)表"
        ws["A1"].font = Font(name="微軟雅黑", size=16, bold=True)
        ws["A1"].fill = PatternFill(start_color="E6F3FF", end_color="E6F3FF", fill_type="solid")
        ws["A1"].alignment = Alignment(horizontal="center")
        ws.merge_cells("A1:D1")  # 合并單元格
        
        # 3. 寫入表頭
        headers = ["序號(hào)", "項(xiàng)目", "金額（元）", "備注"]
        for col, header in enumerate(headers, 1):
            cell = ws.cell(row=3, column=col, value=header)
            cell.font = Font(name="微軟雅黑", size=12, bold=True)
            cell.fill = PatternFill(start_color="D9E2F3", end_color="D9E2F3", fill_type="solid")
        
        # 4. 寫入數(shù)據(jù)
        for row, item in enumerate(data["details"], 4):
            ws.cell(row=row, column=1, value=item["序號(hào)"])
            ws.cell(row=row, column=2, value=item["項(xiàng)目"])
            ws.cell(row=row, column=3, value=item["金額"])
            ws.cell(row=row, column=4, value=item["備注"])
        
        # 5. 調(diào)整列寬
        ws.column_dimensions["A"].width = 8
        ws.column_dimensions["B"].width = 20
        ws.column_dimensions["C"].width = 15
        ws.column_dimensions["D"].width = 30
        
        # 6. 保存文件
        save_path = f"{save_dir}/{data['部門']}_{data['月份']}月報(bào)表.xlsx"
        wb.save(save_path)
        print(f"已生成報(bào)表：{save_path}")

# 測(cè)試數(shù)據(jù)
test_data = [
    {
        "部門": "技術(shù)部",
        "月份": 10,
        "details": [
            {"序號(hào)": 1, "項(xiàng)目": "服務(wù)器租賃", "金額": 5000, "備注": "季度付"},
            {"序號(hào)": 2, "項(xiàng)目": "軟件訂閱", "金額": 3000, "備注": "月度付"}
        ]
    },
    {
        "部門": "市場(chǎng)部",
        "月份": 10,
        "details": [
            {"序號(hào)": 1, "項(xiàng)目": "廣告投放", "金額": 20000, "備注": "線上推廣"},
            {"序號(hào)": 2, "項(xiàng)目": "活動(dòng)策劃", "金額": 8000, "備注": "線下活動(dòng)"}
        ]
    }
]

# 調(diào)用函數(shù)（需提前創(chuàng)建save_dir目錄）
batch_generate_excel_reports(test_data, "./monthly_reports")
    

import pandas as pd
import os

def batch_merge_excel_files(file_dir, save_path):
    """
    批量讀取指定目錄下的所有Excel文件，合并數(shù)據(jù)后保存
    :param file_dir: Excel文件目錄
    :param save_path: 合并后保存路徑
    """
    # 1. 遍歷目錄，獲取所有Excel文件路徑
    excel_files = [f for f in os.listdir(file_dir) if f.endswith(".xlsx") and not f.startswith("~$")]
    if not excel_files:
        print("目錄下無有效Excel文件")
        return
    
    # 2. 批量讀取并合并
    all_data = []
    for file in excel_files:
        file_path = os.path.join(file_dir, file)
        # 讀取Excel的"數(shù)據(jù)"工作表（假設(shè)所有文件結(jié)構(gòu)一致）
        df = pd.read_excel(file_path, sheet_name="數(shù)據(jù)")
        # 添加"來源文件"列，便于追溯數(shù)據(jù)
        df["來源文件"] = file
        all_data.append(df)
    
    # 3. 合并所有數(shù)據(jù)（忽略索引，重新生成）
    merged_df = pd.concat(all_data, ignore_index=True)
    
    # 4. 數(shù)據(jù)清洗（示例：去除空行、重復(fù)行）
    merged_df = merged_df.dropna(how="all")  # 去除全空行
    merged_df = merged_df.drop_duplicates()  # 去除重復(fù)行
    
    # 5. 保存合并后的數(shù)據(jù)
    merged_df.to_excel(save_path, index=False, sheet_name="合并數(shù)據(jù)")
    print(f"合并完成，共 {len(merged_df)} 條數(shù)據(jù)，保存至：{save_path}")

# 調(diào)用函數(shù)
batch_merge_excel_files("./excel_files", "./merged_data.xlsx")
    

from docx import Document
from docx.shared import Inches, Pt
from docx.enum.text import WD_PARAGRAPH_ALIGNMENT

def batch_generate_contracts(template_path, data_list, save_dir):
    """
    基于Word模板批量生成合同
    :param template_path: 合同模板路徑（.docx）
    :param data_list: 合同數(shù)據(jù)列表，每個(gè)元素是字典
    :param save_dir: 保存目錄
    """
    for idx, data in enumerate(data_list):
        # 1. 加載模板
        doc = Document(template_path)
        
        # 2. 替換文檔中的變量（模板中用{{變量名}}標(biāo)記）
        # 遍歷所有段落
        for para in doc.paragraphs:
            for key, value in data.items():
                if f"{{{{{key}}}}}" in para.text:
                    # 替換變量
                    para.text = para.text.replace(f"{{{{{key}}}}}", str(value))
                    # 設(shè)置段落樣式（可選）
                    para.alignment = WD_PARAGRAPH_ALIGNMENT.JUSTIFY  # 兩端對(duì)齊
                    for run in para.runs:
                        run.font.name = "微軟雅黑"
                        run.font.size = Pt(11)
        
        # 3. 替換表格中的變量（如果模板中有表格）
        for table in doc.tables:
            for row in table.rows:
                for cell in row.cells:
                    for key, value in data.items():
                        if f"{{{{{key}}}}}" in cell.text:
                            cell.text = cell.text.replace(f"{{{{{key}}}}}", str(value))
                            # 設(shè)置表格文本樣式
                            for para in cell.paragraphs:
                                para.alignment = WD_PARAGRAPH_ALIGNMENT.CENTER
                                for run in para.runs:
                                    run.font.name = "微軟雅黑"
                                    run.font.size = Pt(10)
        
        # 4. 插入附件說明（可選，在文檔末尾添加）
        para = doc.add_paragraph("附件說明：")
        para.font.name = "微軟雅黑"
        para.font.size = Pt(11)
        para.font.bold = True
        for attach in data["attachments"]:
            doc.add_paragraph(f"1. {attach}", style="List Bullet")
        
        # 5. 保存文件
        save_path = f"{save_dir}/合同_{data['甲方名稱']}_{data['合同編號(hào)']}.docx"
        doc.save(save_path)
        print(f"已生成合同：{save_path}")

# 測(cè)試數(shù)據(jù)
test_contract_data = [
    {
        "合同編號(hào)": "HT202410001",
        "甲方名稱": "XX科技有限公司",
        "乙方名稱": "YY軟件有限公司",
        "項(xiàng)目名稱": "企業(yè)OA系統(tǒng)開發(fā)",
        "合同金額": "500000元",
        "簽訂日期": "2024年10月20日",
        "有效期": "2年",
        "attachments": ["技術(shù)需求說明書", "報(bào)價(jià)單"]
    },
    {
        "合同編號(hào)": "HT202410002",
        "甲方名稱": "ZZ貿(mào)易有限公司",
        "乙方名稱": "YY軟件有限公司",
        "項(xiàng)目名稱": "客戶管理系統(tǒng)升級(jí)",
        "合同金額": "200000元",
        "簽訂日期": "2024年10月21日",
        "有效期": "1年",
        "attachments": ["升級(jí)需求清單", "維護(hù)協(xié)議"]
    }
]

# 調(diào)用函數(shù)（需提前準(zhǔn)備模板文件，模板中用{{合同編號(hào)}}等變量標(biāo)記）
batch_generate_contracts("./contract_template.docx", test_contract_data, "./contracts")

from PyPDF2 import PdfMerger
import os

def batch_merge_pdfs(pdf_dir, save_path):
    """
    批量合并指定目錄下的所有PDF文件
    :param pdf_dir: PDF文件目錄
    :param save_path: 合并后保存路徑
    """
    # 1. 初始化合并器
    merger = PdfMerger()
    
    # 2. 遍歷目錄，添加所有PDF文件
    pdf_files = [f for f in os.listdir(pdf_dir) if f.endswith(".pdf")]
    if not pdf_files:
        print("目錄下無有效PDF文件")
        return
    
    # 按文件名排序（確保合并順序正確）
    pdf_files.sort()
    for file in pdf_files:
        file_path = os.path.join(pdf_dir, file)
        try:
            merger.append(file_path)  # 添加PDF文件
            print(f"已添加：{file}")
        except Exception as e:
            print(f"添加{file}失?。簕e}")
    
    # 3. 合并并保存
    merger.write(save_path)
    merger.close()
    print(f"合并完成，保存至：{save_path}")

# 調(diào)用函數(shù)
batch_merge_pdfs("./pdf_files", "./merged_pdf.pdf")
    

import pdfplumber
import pandas as pd
import os

def batch_extract_pdf_tables(pdf_dir, save_dir):
    """
    批量提取多個(gè)PDF中的表格數(shù)據(jù)，保存為Excel
    :param pdf_dir: PDF文件目錄
    :param save_dir: 保存目錄
    """
    # 確保保存目錄存在
    os.makedirs(save_dir, exist_ok=True)
    
    pdf_files = [f for f in os.listdir(pdf_dir) if f.endswith(".pdf")]
    if not pdf_files:
        print("目錄下無有效PDF文件")
        return
    
    for file in pdf_files:
        file_path = os.path.join(pdf_dir, file)
        save_path = f"{save_dir}/{os.path.splitext(file)[0]}_表格數(shù)據(jù).xlsx"
        
        # 打開PDF文件
        with pdfplumber.open(file_path) as pdf:
            # 初始化Excel寫入器
            with pd.ExcelWriter(save_path, engine="openpyxl") as writer:
                table_count = 0
                # 遍歷所有頁面
                for page_idx, page in enumerate(pdf.pages, 1):
                    # 提取當(dāng)前頁面的所有表格
                    tables = page.extract_tables()
                    if not tables:
                        continue
                    # 遍歷當(dāng)前頁面的表格
                    for table_idx, table in enumerate(tables, 1):
                        table_count += 1
                        # 轉(zhuǎn)換為DataFrame
                        df = pd.DataFrame(table[1:], columns=table[0])  # table[0]是表頭
                        # 保存到Excel的不同工作表
                        sheet_name = f"第{page_idx}頁_表格{table_idx}"
                        df.to_excel(writer, sheet_name=sheet_name, index=False)
        
        if table_count > 0:
            print(f"已提取{file}中的{table_count}個(gè)表格，保存至：{save_path}")
        else:
            print(f"{file}中未發(fā)現(xiàn)表格")

# 調(diào)用函數(shù)
batch_extract_pdf_tables("./pdf_files", "./pdf_tables")
    

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header
import os

def batch_send_emails(smtp_info, email_data_list):
    """
    批量發(fā)送帶附件的郵件
    :param smtp_info: SMTP服務(wù)器信息，字典格式
    :param email_data_list: 郵件數(shù)據(jù)列表，每個(gè)元素是字典（含收件人、主題、正文、附件）
    """
    try:
        # 1. 連接SMTP服務(wù)器
        smtp = smtplib.SMTP_SSL(smtp_info["smtp_server"], smtp_info["smtp_port"])
        # 2. 登錄驗(yàn)證（注意：QQ郵箱用授權(quán)碼，企業(yè)郵箱用密碼）
        smtp.login(smtp_info["sender"], smtp_info["password"])
        print("SMTP服務(wù)器連接成功")
        
        # 3. 批量發(fā)送郵件
        for email_data in email_data_list:
            # 構(gòu)造郵件對(duì)象（帶附件）
            msg = MIMEMultipart()
            msg["From"] = Header(smtp_info["sender_name"], "utf-8")  # 發(fā)件人名稱
            msg["To"] = Header(";".join(email_data["receivers"]), "utf-8")  # 收件人列表
            msg["Subject"] = Header(email_data["subject"], "utf-8")  # 郵件主題
            
            # 添加正文
            msg.attach(MIMEText(email_data["content"], "html", "utf-8"))  # 支持HTML格式正文
            
            # 添加附件
            for attach_path in email_data["attachments"]:
                if not os.path.exists(attach_path):
                    print(f"附件{attach_path}不存在，跳過")
                    continue
                # 讀取附件文件
                with open(attach_path, "rb") as f:
                    attach = MIMEText(f.read(), "base64", "utf-8")
                    attach["Content-Type"] = "application/octet-stream"
                    # 設(shè)置附件名稱（避免中文亂碼）
                    attach["Content-Disposition"] = f'attachment; filename="{Header(os.path.basename(attach_path), "utf-8").encode()}"'
                    msg.attach(attach)
            
            # 發(fā)送郵件
            smtp.sendmail(smtp_info["sender"], email_data["receivers"], msg.as_string())
            print(f"已發(fā)送郵件至：{email_data['receivers']}，主題：{email_data['subject']}")
        
        # 4. 關(guān)閉連接
        smtp.quit()
        print("所有郵件發(fā)送完成")
    
    except Exception as e:
        print(f"郵件發(fā)送失?。簕e}")

# 配置SMTP信息（以企業(yè)郵箱為例，QQ郵箱需替換為smtp.qq.com，端口465，密碼用授權(quán)碼）
smtp_config = {
    "smtp_server": "smtp.exmail.qq.com",
    "smtp_port": 465,
    "sender": "admin@company.com",
    "sender_name": "行政部",
    "password": "your_password"  # 企業(yè)郵箱密碼，QQ郵箱用授權(quán)碼
}

# 郵件數(shù)據(jù)（批量發(fā)送的郵件列表）
email_data = [
    {
        "receivers": ["tech@company.com", "manager1@company.com"],
        "subject": "技術(shù)部10月報(bào)表",
        "content": "<p>各位領(lǐng)導(dǎo)、同事：</p><p>附件為技術(shù)部2024年10月報(bào)表，請(qǐng)查收。</p>",
        "attachments": ["./monthly_reports/技術(shù)部_10月報(bào)表.xlsx"]
    },
    {
        "receivers": ["market@company.com", "manager2@company.com"],
        "subject": "市場(chǎng)部10月報(bào)表",
        "content": "<p>各位領(lǐng)導(dǎo)、同事：</p><p>附件為市場(chǎng)部2024年10月報(bào)表，請(qǐng)查收。</p>",
        "attachments": ["./monthly_reports/市場(chǎng)部_10月報(bào)表.xlsx"]
    }
]

# 調(diào)用函數(shù)
batch_send_emails(smtp_config, email_data)
    

import pandas as pd
import openpyxl
from docx import Document
import PyPDF2
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.header import Header
import os
import win32com.client  # 需安裝pywin32：pip install pywin32
from datetime import datetime

def excel_to_pdf(excel_path, pdf_path):
    """
    將Excel文件轉(zhuǎn)換為PDF（調(diào)用Excel進(jìn)程，保證格式一致）
    :param excel_path: Excel文件路徑
    :param pdf_path: PDF保存路徑
    """
    excel = win32com.client.DispatchEx("Excel.Application")
    excel.Visible = False
    excel.DisplayAlerts = False  # 禁用警告
    try:
        workbook = excel.Workbooks.Open(excel_path)
        # 轉(zhuǎn)換為PDF（Quality=17表示高質(zhì)量）
        workbook.ExportAsFixedFormat(0, pdf_path, Quality=17)
        print(f"已將{excel_path}轉(zhuǎn)換為PDF：{pdf_path}")
    except Exception as e:
        print(f"Excel轉(zhuǎn)PDF失?。簕e}")
    finally:
        workbook.Close(SaveChanges=False)
        excel.Quit()

def monthly_report_automation(config):
    """
    月度報(bào)表全鏈路自動(dòng)化
    :param config: 配置字典，含數(shù)據(jù)目錄、模板路徑、SMTP信息等
    """
    # 1. 初始化目錄（按年份/月份/部門）
    now = datetime.now()
    year = now.year
    month = now.month
    base_dir = f"{config['base_dir']}/{year}/{month}"
    excel_dir = f"{base_dir}/Excel"
    pdf_dir = f"{base_dir}/PDF"
    archive_dir = f"{base_dir}/歸檔"
    for dir_path in [excel_dir, pdf_dir, archive_dir]:
        os.makedirs(dir_path, exist_ok=True)
    
    # 2. 讀取各部門提交的原始數(shù)據(jù)（標(biāo)準(zhǔn)化模板）
    raw_data_dir = config["raw_data_dir"]
    raw_files = [f for f in os.listdir(raw_data_dir) if f.endswith(".xlsx") and not f.startswith("~$")]
    if not raw_files:
        print("原始數(shù)據(jù)目錄下無有效文件")
        return
    
    # 3. 批量生成標(biāo)準(zhǔn)化Excel報(bào)表
    report_template = config["report_template"]
    email_data_list = []
    for file in raw_files:
        # 讀取原始數(shù)據(jù)
        raw_path = os.path.join(raw_data_dir, file)
        raw_df = pd.read_excel(raw_path, sheet_name="原始數(shù)據(jù)")
        
        # 數(shù)據(jù)校驗(yàn)（示例：檢查是否有缺失字段）
        required_fields = ["項(xiàng)目", "金額（元）", "備注"]
        if not all(field in raw_df.columns for field in required_fields):
            print(f"{file}缺失必要字段，跳過")
            continue
        
        # 提取部門名稱（假設(shè)文件名格式：部門_原始數(shù)據(jù).xlsx）
        dept_name = os.path.splitext(file)[0].replace("_原始數(shù)據(jù)", "")
        
        # 加載報(bào)表模板，生成標(biāo)準(zhǔn)化報(bào)表
        wb = openpyxl.load_workbook(report_template)
        ws = wb.active
        ws["A1"] = f"{dept_name}{year}年{month}月報(bào)表"
        ws["A1"].font = openpyxl.styles.Font(name="微軟雅黑", size=16, bold=True)
        ws.merge_cells("A1:D1")
        
        # 寫入數(shù)據(jù)
        for row_idx, (_, row) in enumerate(raw_df.iterrows(), 4):
            ws.cell(row=row_idx, column=1, value=row_idx-3)  # 序號(hào)
            ws.cell(row=row_idx, column=2, value=row["項(xiàng)目"])
            ws.cell(row=row_idx, column=3, value=row["金額（元）"])
            ws.cell(row=row_idx, column=4, value=row["備注"])
        
        # 保存Excel報(bào)表
        excel_path = f"{excel_dir}/{dept_name}_{year}年{month}月報(bào)表.xlsx"
        wb.save(excel_path)
        
        # 4. 轉(zhuǎn)換為PDF
        pdf_path = f"{pdf_dir}/{dept_name}_{year}年{month}月報(bào)表.pdf"
        excel_to_pdf(excel_path, pdf_path)
        
        # 5. 整理郵件數(shù)據(jù)
        # 讀取收件人配置（假設(shè)config["receivers_config"]是收件人字典）
        receivers = config["receivers_config"].get(dept_name, config["default_receivers"])
        email_data = {
            "receivers": receivers,
            "subject": f"{dept_name}{year}年{month}月報(bào)表",
            "content": f"<p>各位領(lǐng)導(dǎo)、同事：</p><p>附件為{dept_name}{year}年{month}月報(bào)表（Excel+PDF），請(qǐng)查收。</p>",
            "attachments": [excel_path, pdf_path]
        }
        email_data_list.append(email_data)
        
        # 6. 歸檔文件
        archive_excel_path = f"{archive_dir}/{dept_name}_{year}年{month}月報(bào)表.xlsx"
        archive_pdf_path = f"{archive_dir}/{dept_name}_{year}年{month}月報(bào)表.pdf"
        os.copy(excel_path, archive_excel_path)
        os.copy(pdf_path, archive_pdf_path)
    
    # 7. 批量發(fā)送郵件
    smtp_info = config["smtp_info"]
    smtp = smtplib.SMTP_SSL(smtp_info["smtp_server"], smtp_info["smtp_port"])
    smtp.login(smtp_info["sender"], smtp_info["password"])
    for email_data in email_data_list:
        msg = MIMEMultipart()
        msg["From"] = Header(smtp_info["sender_name"], "utf-8")
        msg["To"] = Header(";".join(email_data["receivers"]), "utf-8")
        msg["Subject"] = Header(email_data["subject"], "utf-8")
        msg.attach(MIMEText(email_data["content"], "html", "utf-8"))
        
        # 添加附件
        for attach_path in email_data["attachments"]:
            if os.path.exists(attach_path):
                with open(attach_path, "rb") as f:
                    attach = MIMEText(f.read(), "base64", "utf-8")
                    attach["Content-Type"] = "application/octet-stream"
                    attach["Content-Disposition"] = f'attachment; filename="{Header(os.path.basename(attach_path), "utf-8").encode()}"'
                    msg.attach(attach)
        
        smtp.sendmail(smtp_info["sender"], email_data["receivers"], msg.as_string())
        print(f"已發(fā)送郵件至：{email_data['receivers']}")
    smtp.quit()
    print("全鏈路自動(dòng)化完成！")

# 配置信息
config = {
    "base_dir": "./月度報(bào)表自動(dòng)化",
    "raw_data_dir": "./原始數(shù)據(jù)",
    "report_template": "./報(bào)表模板.xlsx",
    "smtp_info": {
        "smtp_server": "smtp.exmail.qq.com",
        "smtp_port": 465,
        "sender": "admin@company.com",
        "sender_name": "行政部",
        "password": "your_password"
    },
    "receivers_config": {
        "技術(shù)部": ["tech_manager@company.com", "ceo@company.com"],
        "市場(chǎng)部": ["market_manager@company.com", "ceo@company.com"],
        "財(cái)務(wù)部": ["finance_manager@company.com", "ceo@company.com"]
    },
    "default_receivers": ["admin@company.com", "ceo@company.com"]
}

# 執(zhí)行全鏈路自動(dòng)化
monthly_report_automation(config)
    

`def get_merged_cell_value(ws, row, col):
“”“獲取合并單元格的值”“”
for merged_range in ws.merged_cells.ranges:
if row in merged_range.min_row:merged_range.max_row and col in merged_range.min_col:merged_range.max_col:
# 返回合并范圍的起始單元格值
return ws.cell(row=merged_range.min_row, column=merged_range.min_col).value

`import fitz # PyMuPDF
???????def merge_pdfs_with_chinese(pdf_paths, save_path):
“”“合并包含中文的PDF文件”“”
doc = fitz.open()
for pdf_path in pdf_paths:
with fitz.open(pdf_path) as sub_doc:
doc.insert_pdf(sub_doc)
doc.save(save_path)
doc.close()
print(f"合并完成：{save_path}")`

`msg = MIMEMultipart()
msg[“From”] = Header(“行政部admin@company.com”, “utf-8”) # 規(guī)范發(fā)件人名稱
msg[“To”] = Header(“技術(shù)部經(jīng)理tech_manager@company.com”, “utf-8”)
msg[“Subject”] = Header(“技術(shù)部10月報(bào)表”, “utf-8”)

def safe_excel_to_pdf(excel_path, pdf_path): excel = None workbook = None try: excel = win32com.client.DispatchEx("Excel.Application") excel.Visible = False excel.DisplayAlerts = False workbook = excel.Workbooks.Open(excel_path) workbook.ExportAsFixedFormat(0, pdf_path, Quality=17) except Exception as e: print(f"轉(zhuǎn)換失?。簕e}") finally: if workbook: workbook.Close(SaveChanges=False) if excel: excel.Quit() # 強(qiáng)制釋放COM對(duì)象（可選，進(jìn)一步避免殘留） import pythoncom pythoncom.CoUninitialize()