pip install pywin32

pip install unoconv

import win32com.client as win32

# 啟動 WPS 文字
wps = win32.Dispatch("Kwps.Application")
wps.Visible = True  # 顯示窗口

# 新建文檔
doc = wps.Documents.Add()
doc.Content.Text = "Hello, WPS自動化!\n"

# 插入表格
table = doc.Tables.Add(doc.Range(), 3, 3)
table.Cell(1, 1).Range.Text = "Python"
table.Cell(1, 2).Range.Text = "WPS"

# 保存并關(guān)閉
doc.SaveAs(r"C:\test_wps.docx")
doc.Close()
wps.Quit()

import win32com.client as win32

# 啟動 WPS 表格
excel = win32.Dispatch("Ket.Application")
excel.Visible = True

# 新建工作簿
wb = excel.Workbooks.Add()
sheet = wb.ActiveSheet

# 寫入數(shù)據(jù)
sheet.Cells(1, 1).Value = "姓名"
sheet.Cells(1, 2).Value = "分?jǐn)?shù)"
sheet.Cells(2, 1).Value = "張三"
sheet.Cells(2, 2).Value = 95

# 插入公式
sheet.Cells(3, 1).Value = "平均分"
sheet.Cells(3, 2).Formula = "=AVERAGE(B1:B2)"

# 保存并退出
wb.SaveAs(r"C:\test_wps.xlsx")
wb.Close()
excel.Quit()

import win32com.client as win32

# 啟動 WPS 演示
ppt = win32.Dispatch("Kwpp.Application")
ppt.Visible = True

# 新建幻燈片
pres = ppt.Presentations.Add()
slide = pres.Slides.Add(1, 1)  # 第一張幻燈片

# 添加標(biāo)題
title = slide.Shapes.Title
title.TextFrame.TextRange.Text = "WPS自動化演示"

# 添加文本框
content = slide.Shapes.AddTextbox(1, 100, 200, 500, 100)
content.TextFrame.TextRange.Text = "使用Python控制WPS演示文稿！"

# 保存并退出
pres.SaveAs(r"C:\test_wps.pptx")
pres.Close()
ppt.Quit()

try:
    doc = wps.Documents.Open("不存在的文檔.docx")
except Exception as e:
    print(f"錯誤: {e}")

doc.Close(SaveChanges=False)
wps.Quit()

from docx import Document

doc = Document()
doc.add_paragraph("直接生成Word文檔內(nèi)容")
doc.add_table(rows=2, cols=2)
doc.save("test.docx")

from openpyxl import Workbook

wb = Workbook()
ws = wb.active
ws['A1'] = "Python"
ws['B1'] = "WPS"
wb.save("test.xlsx")

import subprocess

# 打開文檔
subprocess.run(["wps", "/path/to/document.docx"])

# 轉(zhuǎn)換為 PDF（需 WPS 支持）
subprocess.run(["wps", "--convert-to", "pdf", "document.docx"])