从SQL SERVER数据库查询列表获得数组，导入WORD模板转换为pdf文件，最后合并文件

import docx
from docx import Document
import pandas as pd
import pyodbc
conn = pyodbc.connect('Driver={SQL Server Native Client 11.0};'
                      'Server=数据库IP;'
                      'Database=初始数据库名;'
                      'UID=用户;'
                      'PWD=密码;')
cursor = conn.cursor()
cursor.execute("SELECT wlmc,tm,CONVERT(VARCHAR(10),lrrq,23) AS lrrq FROM e_jc_jyjl WHERE khhth= 'SK-ZBA23050402' GROUP BY wlmc,tm,lrrq")
rows = cursor.fetchall()

# 指定Word模板文件
word_file_path = 'F:\\Python\\jyjl\\template3.docx' #指定的模板

# 定义列表
ColA = []
for row in rows:
    ColA.append(row[0])

ColB = []
for row in rows:
    ColB.append(row[1])

ColC = []
for row in rows:
    ColC.append(row[2])

# 待替换变量和具体值
for i in range(len(ColA)):
        # 复制Word模板
    document = docx.Document(word_file_path)
    replace_dict = {
    'E-XXT8-L10-200-BR-M20-C': ColA[i],
    '110850': ColB[i],
    'SJRQ': ColC[i]

             }
    for paragraph in document.paragraphs:
        for key, value in replace_dict.items():
            if key in paragraph.text:
                for run in paragraph.runs:
                    if key in run.text:
                        run.text = run.text.replace(key, value)

                        # 保存每个替换后的Word
    new_file = f'F:\\Python\\jyjl\\output\\output{i + 1}.docx'
    document.save(new_file)

# 合并多个Word文件
import os
import glob
from docx2pdf import convert
from PyPDF2 import PdfFileMerger

# 从word转换为pdf文件
docx_files = glob.glob('F:\\Python\\jyjl\\output\\output*.docx')
pdf_files = []
for docx_file in docx_files:
    pdf_file = os.path.splitext(docx_file)[0] + '.pdf'
    convert(docx_file, pdf_file)
    pdf_files.append(pdf_file)

# 删除文件word
for file in docx_files:
   os.remove(file)

#开始合并pdf文件
from PyPDF2 import PdfReader, PdfWriter
# 获取当前文件夹路径
cur_path = os.path.dirname(__file__)

# 使用 glob 获取文件列表
pdfFiles = glob.glob(os.path.join(cur_path,"F:\\Python\\jyjl\\output\\output*.pdf"))

# 创建一个列表,包含每个PDF文件的对象
pdfObjects = [PdfReader(open(fname, 'rb')) for fname in pdfFiles]

# 初始化PdfWriter对象,用于写入合并后的PDF
pdfWriter = PdfWriter()

# 循环每个PDF对象
for pdf in pdfObjects:

    # 循环每个PDF对象中的页
    for page in pdf.pages:
        # 添加当前页到PdfWriter对象
        pdfWriter.add_page(page)
     # 关闭PDF文件
    pdf.stream.close()
    del pdf
# 用PdfWriter对象写入结果PDF
pdfWriter.write("F:\\Python\\jyjl\\output\\merged_output.pdf")

# 关闭每个输入文件
for pdf in pdfFiles:
    os.remove(pdf)

#关闭数据库链接
cursor.close()
conn.close()