import pptx
print(pptx.__version__)

from pptx import Presentation

# 1. 創(chuàng)建演示文稿對(duì)象
prs = Presentation()

# 2. 選擇一種版式（0是標(biāo)題幻燈片版式）
title_slide_layout = prs.slide_layouts[0]
slide = prs.slides.add_slide(title_slide_layout)

# 3. 獲取占位符，設(shè)置標(biāo)題和副標(biāo)題
title = slide.shapes.title
subtitle = slide.placeholders[1]  # 索引1通常為副標(biāo)題占位符

title.text = "Python PPT自動(dòng)化之旅"
subtitle.text = "從入門到精通"

# 4. 保存文件
prs.save('第一個(gè)PPT.pptx')
print("PPT已保存為：第一個(gè)PPT.pptx")

for i, ph in enumerate(slide.placeholders):
    print(f"占位符 {i}: {ph.placeholder_format.idx} - {ph.name}")

from pptx import Presentation
from pptx.util import Inches, Pt
from pptx.enum.text import PP_ALIGN

prs = Presentation()
# 添加空白版式（索引6通常為空白）
blank_slide_layout = prs.slide_layouts[6]
slide = prs.slides.add_slide(blank_slide_layout)

# 添加文本框：left, top, width, height（英寸）
left = Inches(1)
top = Inches(1)
width = Inches(8)
height = Inches(2)
textbox = slide.shapes.add_textbox(left, top, width, height)
tf = textbox.text_frame

# 寫入多段文本并設(shè)置樣式
p = tf.paragraphs[0]
p.text = "歡迎學(xué)習(xí)Python-PPT自動(dòng)化"
p.alignment = PP_ALIGN.CENTER

run = p.runs[0]
run.font.size = Pt(36)
run.font.bold = True
run.font.color.rgb = (0, 51, 102)  # 深藍(lán)色

# 添加新段落
p2 = tf.add_paragraph()
p2.text = "掌握核心技能，解放重復(fù)勞動(dòng)"
p2.alignment = PP_ALIGN.CENTER
p2.font.size = Pt(20)
p2.font.italic = True

prs.save('文本框示例.pptx')
print("文本框PPT已生成。")

from pptx import Presentation
from pptx.util import Inches

prs = Presentation()
slide = prs.slides.add_slide(prs.slide_layouts[6])  # 空白版式

img_path = 'chart.png'  # 請(qǐng)?zhí)鎿Q為你的圖片路徑
left = Inches(2)
top = Inches(1)
# 插入圖片同時(shí)可以指定寬高，也可省略讓圖片保持原始比例
pic = slide.shapes.add_picture(img_path, left, top, width=Inches(6))
print(f"插入圖片：{img_path}，寬度自動(dòng)調(diào)整為6英寸")

prs.save('圖片示例.pptx')

from pptx import Presentation
from pptx.util import Inches, Pt

prs = Presentation()
slide = prs.slides.add_slide(prs.slide_layouts[6])

rows, cols = 4, 3
left = Inches(1.5)
top = Inches(1.5)
width = Inches(7)
height = Inches(3)
table_shape = slide.shapes.add_table(rows, cols, left, top, width, height)
table = table_shape.table

# 設(shè)置列寬
table.columns[0].width = Inches(2)
table.columns[1].width = Inches(2.5)
table.columns[2].width = Inches(2.5)

# 填充數(shù)據(jù)并設(shè)置表頭樣式
data = [
    ["產(chǎn)品", "銷量（件）", "銷售額（萬元）"],
    ["冰箱", "1200", "360"],
    ["洗衣機(jī)", "980", "245"],
    ["空調(diào)", "1500", "600"]
]

for i, row_data in enumerate(data):
    for j, cell_text in enumerate(row_data):
        cell = table.cell(i, j)
        cell.text = cell_text
        # 表頭加粗居中
        if i == 0:
            for paragraph in cell.text_frame.paragraphs:
                paragraph.font.bold = True
                paragraph.font.size = Pt(14)
                paragraph.alignment = 1  # 居中

print("表格數(shù)據(jù)寫入完成，共{}行{}列。".format(len(data), len(data[0])))
prs.save('表格示例.pptx')

from pptx import Presentation
from pptx.chart.data import CategoryChartData
from pptx.enum.chart import XL_CHART_TYPE
from pptx.util import Inches

prs = Presentation()
slide = prs.slides.add_slide(prs.slide_layouts[6])

# 準(zhǔn)備圖表數(shù)據(jù)
chart_data = CategoryChartData()
chart_data.categories = ['一季度', '二季度', '三季度', '四季度']
chart_data.add_series('產(chǎn)品A', (19.2, 21.4, 16.7, 24.5))
chart_data.add_series('產(chǎn)品B', (22.8, 24.2, 19.6, 26.0))

# 添加簇狀柱形圖
x, y, cx, cy = Inches(1), Inches(1.5), Inches(8), Inches(5)
chart_frame = slide.shapes.add_chart(
    XL_CHART_TYPE.COLUMN_CLUSTERED, x, y, cx, cy, chart_data
)

chart = chart_frame.chart
chart.has_legend = True
chart.legend.include_in_layout = False # 不影響圖表區(qū)域
chart.has_title = True
chart.chart_title.text_frame.text = "2025年產(chǎn)品銷售趨勢"

print("圖表已生成，類型：簇狀柱形圖")
prs.save('圖表示例.pptx')

from pptx import Presentation

prs = Presentation('季度匯報(bào)模板.pptx')  # 需存在
print(f"演示文稿共 {len(prs.slides)} 頁\n")

for slide_no, slide in enumerate(prs.slides, 1):
    print(f"--- 第 {slide_no} 頁 ---")
    for shape in slide.shapes:
        if shape.has_text_frame:
            for paragraph in shape.text_frame.paragraphs:
                text = paragraph.text.strip()
                if text:
                    print("  " + text)
    print()

from pptx import Presentation

prs = Presentation('季度匯報(bào)模板.pptx')
old_text = "4200萬元"
new_text = "5180萬元（目標(biāo)超額完成）"

for slide in prs.slides:
    for shape in slide.shapes:
        if shape.has_text_frame:
            for paragraph in shape.text_frame.paragraphs:
                if old_text in paragraph.text:
                    # 安全替換整個(gè)段落文本
                    paragraph.text = paragraph.text.replace(old_text, new_text)
                    print(f"替換成功：'{old_text}' -> '{new_text}'")

prs.save('更新后的季度匯報(bào).pptx')
print("修改后的文件已保存。")

from pptx import Presentation
import copy

prs = Presentation('模板.pptx')
slide_to_delete = prs.slides[1]  # 要?jiǎng)h除第2頁

# 獲取幻燈片ID并構(gòu)建RId
rId = prs.slides._sldIdLst[1].get('{http://schemas.openxmlformats.org/officeDocument/2006/relationships}id')
# 從sldIdLst移除對(duì)應(yīng)元素
sldId = prs.slides._sldIdLst[1]
prs.slides._sldIdLst.remove(sldId)
# 刪除關(guān)系
prs.part.drop_rel(rId)
print("幻燈片已刪除")

prs.save('刪除幻燈片后.pptx')

prs = Presentation('公司模板.potx')
# 選擇特定的版式名稱（需在模板中定義）
layout = None
for ly in prs.slide_layouts:
    if ly.name == '內(nèi)容頁_圖表':
        layout = ly
        break
if layout:
    slide = prs.slides.add_slide(layout)
    slide.shapes.title.text = "銷售分析"
else:
    print("未找到指定版式")

slide = prs.slides[0]
notes_slide = slide.notes_slide
notes_slide.notes_text_frame.text = "這是講演備注：重點(diǎn)突出同比增長率。"
print("備注已添加")

from pptx import Presentation
from pptx.util import Inches, Pt
from pptx.enum.action import PP_ACTION

prs = Presentation()
slide = prs.slides.add_slide(prs.slide_layouts[6])

# 添加文本框并設(shè)置超鏈接
txBox = slide.shapes.add_textbox(Inches(2), Inches(2), Inches(4), Inches(1))
tf = txBox.text_frame
p = tf.paragraphs[0]
run = p.add_run()
run.text = "點(diǎn)擊訪問Python官網(wǎng)"
run.font.size = Pt(18)
run.font.color.rgb = (0, 0, 255)

# 創(chuàng)建超鏈接
run.hyperlink.address = "https://www.python.org"
print("超鏈接已設(shè)置。")

prs.save('超鏈接示例.pptx')

import openpyxl
from pptx import Presentation
from pptx.chart.data import CategoryChartData
from pptx.enum.chart import XL_CHART_TYPE
from pptx.util import Inches, Pt
from pptx.dml.color import RGBColor

# 1. 讀取Excel數(shù)據(jù)
wb = openpyxl.load_workbook('sales_data.xlsx')
ws = wb.active
headers = [cell.value for cell in ws[1]]
data_rows = []
for row in ws.iter_rows(min_row=2, values_only=True):
    data_rows.append(row)

# 2. 創(chuàng)建PPT，使用標(biāo)題和內(nèi)容版式
prs = Presentation()
layout = prs.slide_layouts[1]  # 通常為'標(biāo)題和內(nèi)容'

for name, q1, q2, q3, q4 in data_rows:
    slide = prs.slides.add_slide(layout)
    slide.shapes.title.text = f"{name} 季度業(yè)績"
    
    # 提取內(nèi)容占位符，先清除默認(rèn)文本，防止重疊
    content_placeholder = slide.placeholders[1]
    content_placeholder.text = ""  # 清空
    
    # 插入表格
    rows, cols = 2, 5
    left = Inches(1)
    top = Inches(2.2)
    width = Inches(8.5)
    height = Inches(1.2)
    table_shape = slide.shapes.add_table(rows, cols, left, top, width, height)
    table = table_shape.table
    
    # 表頭
    table.cell(0,0).text = "姓名"
    table.cell(0,1).text = "Q1"
    table.cell(0,2).text = "Q2"
    table.cell(0,3).text = "Q3"
    table.cell(0,4).text = "Q4"
    # 數(shù)據(jù)
    table.cell(1,0).text = name
    table.cell(1,1).text = str(q1)
    table.cell(1,2).text = str(q2)
    table.cell(1,3).text = str(q3)
    table.cell(1,4).text = str(q4)
    
    # 插入圖表
    chart_data = CategoryChartData()
    chart_data.categories = ['Q1', 'Q2', 'Q3', 'Q4']
    chart_data.add_series('銷售額(萬元)', (q1, q2, q3, q4))
    
    x, y, cx, cy = Inches(1.5), Inches(3.8), Inches(7), Inches(3.5)
    chart_frame = slide.shapes.add_chart(
        XL_CHART_TYPE.COLUMN_CLUSTERED, x, y, cx, cy, chart_data
    )
    chart = chart_frame.chart
    chart.has_legend = False
    
    print(f"已生成幻燈片：{name}")

output_path = '銷售業(yè)績報(bào)告.pptx'
prs.save(output_path)
print(f"所有幻燈片生成完畢，文件保存為：{output_path}")