pip install python-docx openpyxl matplotlib

from docx import Document
from docx.shared import Pt, RGBColor
from docx.enum.text import WD_ALIGN_PARAGRAPH

# 創(chuàng)建文檔對(duì)象
doc = Document()

# 添加標(biāo)題
title = doc.add_paragraph()
title_run = title.add_run("2023年第一季度銷售報(bào)告")
title_run.font.name = "黑體"
title_run.font.size = Pt(22)
title_run.font.bold = True
title.alignment = WD_ALIGN_PARAGRAPH.CENTER

# 添加日期
date_para = doc.add_paragraph("生成日期：2023-04-01")
date_para.alignment = WD_ALIGN_PARAGRAPH.RIGHT

from openpyxl import load_workbook

# 讀取Excel數(shù)據(jù)
wb = load_workbook("sales_data.xlsx")
sheet = wb.active
data = []
for row in sheet.iter_rows(values_only=True):
    data.append(row)

# 創(chuàng)建表格（行數(shù)=數(shù)據(jù)行數(shù)，列數(shù)=數(shù)據(jù)列數(shù)）
table = doc.add_table(rows=len(data), cols=len(data[0]))
table.style = "Table Grid"  # 應(yīng)用帶邊框的樣式

# 填充表格
for i, row in enumerate(data):
    for j, cell in enumerate(row):
        table.cell(i, j).text = str(cell) if cell is not None else ""

# 調(diào)整列寬（示例：第一列寬度為2厘米）
for cell in table.columns[0].cells:
    cell.width = Pt(400)  # 1厘米≈28.35Pt，400Pt≈14.1mm，此處調(diào)整為更合適的值如Pt(200)

import matplotlib.pyplot as plt
import numpy as np

# 提取數(shù)據(jù)（示例：產(chǎn)品A的三個(gè)月銷量）
products = [row[0] for row in data[1:]]  # 跳過標(biāo)題行
jan_sales = [row[1] for row in data[1:]]
feb_sales = [row[2] for row in data[1:]]
mar_sales = [row[3] for row in data[1:]]

# 創(chuàng)建折線圖
plt.figure(figsize=(8, 5))
x = np.arange(len(products))
plt.plot(x, jan_sales, label="1月", marker="o")
plt.plot(x, feb_sales, label="2月", marker="s")
plt.plot(x, mar_sales, label="3月", marker="^")
plt.xticks(x, products)
plt.xlabel("產(chǎn)品")
plt.ylabel("銷量（件）")
plt.title("第一季度銷售趨勢(shì)")
plt.legend()
plt.grid(True)

# 保存圖表為圖片
chart_path = "sales_chart.png"
plt.savefig(chart_path, dpi=300, bbox_inches="tight")
plt.close()

# 插入圖片到Word
from docx.shared import Inches
doc.add_picture(chart_path, width=Inches(6))

doc.save("sales_report.docx")

from docx.shared import RGBColor

# 定義標(biāo)題樣式
style = doc.styles["Normal"]
font = style.font
font.name = "宋體"
font.size = Pt(12)

# 自定義段落樣式
custom_style = doc.styles.add_style("Highlight", 1)  # 1表示段落樣式
custom_style.font.color.rgb = RGBColor(255, 0, 0)  # 紅色
custom_style.font.bold = True

# 應(yīng)用樣式
para = doc.add_paragraph("重要提示：", style="Highlight")

from docx import Document

# 加載模板
doc = Document("template.docx")

# 在模板的指定位置插入內(nèi)容（需提前在模板中插入占位符，如"{{data}}"）
for para in doc.paragraphs:
    if "{{data}}" in para.text:
        para.text = para.text.replace("{{data}}", "動(dòng)態(tài)生成的內(nèi)容")

import pdfkit

# 將Word轉(zhuǎn)換為HTML（需先安裝pandoc）
doc.save("temp.docx")
os.system("pandoc temp.docx -o temp.html")

# HTML轉(zhuǎn)PDF
pdfkit.from_file("temp.html", "output.pdf")

from docx.oxml.ns import qn
from docx.shared import Pt


run = doc.add_paragraph().add_run("中文測(cè)試")
run.font.name = "宋體"
run._element.rPr.rFonts.set(qn("w:eastAsia"), "宋體") # 關(guān)鍵設(shè)置
run.font.size = Pt(12)

table = doc.add_table(...)
tbl = table._tbl
tblPr = tbl.get_or_add_tblPr()
tblLayout = tblPr.get_or_add_tblLayout()
tblLayout.type = "fixed" # 固定布局
tblW = tblPr.get_or_add_tblW()
tblW.w = "5000" # 表格寬度（單位：緹，1厘米≈567緹）
tblW.type = "dxa"
# 允許跨頁(yè)斷行需通過Word的"表格屬性"設(shè)置，代碼中可通過以下方式模擬
# 實(shí)際需手動(dòng)在Word中設(shè)置或使用更復(fù)雜的XML操作

plt.figure(figsize=(10, 6), dpi=300) # 增大尺寸和DPI
# ...生成圖表代碼...
plt.savefig("chart.png", dpi=300, bbox_inches="tight", transparent=True)