python工具第一篇excl表转word

将excl表按列转换到word中，具体看代码

import openpyxl
from docx import Document
from docx.shared import Inches

# 打开 Excel 文件
wb = openpyxl.load_workbook("test.xlsx")
ws = wb.active   # 获取第一个sheet页

# 创建 Word 文档
doc = Document()

# 添加一个表格
table = doc.add_table(rows=1, cols=ws.max_column)
hdr_cells = table.rows[0].cells
for i in range(ws.max_column):
    hdr_cells[i].text = ws.cell(row=1, column=i+1).value

# 逐列提取数据写入 Word 表格
for col_num in range(1, ws.max_column+1):
    col_text = []
    for row_num in range(2, ws.max_row+1):
        col_text.append(ws.cell(row=row_num, column=col_num).value)
    col_text = "\n".join(col_text)  # 转化为字符串类型
    row_cells = table.add_row().cells
    row_cells[0].text = col_text

# 保存 Word 文档
doc.save("output.docx")