腾讯云AI代码助手 | 满血DeepSeek实现一个Excel转Word工具

import pandas as pd
from docx import Document

# 读取 Excel 文件
file_path = "input.xlsx"
df = pd.read_excel(file_path)

# 处理合并单元格的空值，向下填充
df.fillna(method='ffill', inplace=True)

# 创建 Word 文档
doc = Document()

current_module = None
current_first_level = None
current_second_level = None  # 记录当前的二级功能点

for index, row in df.iterrows():
    module = row["功能模块"]
    first_level = row["一级功能点"]
    second_level = row["二级功能点"]
    key_point = row["功能要点"]
    workload = row["工作量（人天）"]
    price = row["单价"]

    # 添加一级标题（功能模块）
    if pd.notna(module) and module != current_module:
        doc.add_heading(module, level=1)
        current_module = module

    # 添加二级标题（一级功能点）
    if pd.notna(first_level) and first_level != current_first_level:
        doc.add_heading(first_level, level=2)
        current_first_level = first_level

    # 只有在 **第一行** 出现新 **二级功能点** 时，才添加三级标题
    if pd.notna(second_level) and second_level != current_second_level:
        doc.add_heading(second_level, level=3)
        current_second_level = second_level

    # 添加功能要点、工作量和单价（作为文本内容）
    doc.add_paragraph(f"功能要点: {key_point}")
    doc.add_paragraph(f"工作量: {workload} 人天")
    doc.add_paragraph(f"单价: {price}")

# 保存 Word 文件
output_path = "output.docx"
doc.save(output_path)
print("Word 文件已生成:", output_path)

import sys
import pandas as pd
from docx import Document
from PyQt6.QtWidgets import QApplication, QWidget, QVBoxLayout, QPushButton, QFileDialog, QLabel, QMessageBox

class ExcelToWordApp(QWidget):
    def __init__(self):
        super().__init__()

        self.initUI()

    def initUI(self):
        self.setWindowTitle("Excel 转 Word 工具")
        self.setGeometry(300, 300, 400, 200)
        layout = QVBoxLayout()
        self.label = QLabel("请选择 Excel 文件", self)
        layout.addWidget(self.label)
        self.btn_select = QPushButton("选择 Excel 文件", self)
        self.btn_select.clicked.connect(self.select_excel_file)
        layout.addWidget(self.btn_select)
        self.btn_generate = QPushButton("生成 Word 文件", self)
        self.btn_generate.clicked.connect(self.generate_word_file)
        layout.addWidget(self.btn_generate)
        self.setLayout(layout)
        self.excel_file = None

    def select_excel_file(self):
        file_dialog = QFileDialog()
        file_path, _ = file_dialog.getOpenFileName(self, "选择 Excel 文件", "", "Excel 文件 (*.xlsx *.xls)")
        if file_path:
            self.excel_file = file_path
            self.label.setText(f"已选择文件: {file_path}")

    def generate_word_file(self):
        if not self.excel_file:
            QMessageBox.warning(self, "错误", "请先选择 Excel 文件！")
            return

        try:
            output_file = self.convert_excel_to_word(self.excel_file)
            QMessageBox.information(self, "成功", f"Word 文件已生成:\n{output_file}")
        except Exception as e:
            QMessageBox.critical(self, "错误", f"生成 Word 文件失败:\n{str(e)}")

    def convert_excel_to_word(self, file_path):
        df = pd.read_excel(file_path)

        # 处理合并单元格的空值
        df.fillna(method='ffill', inplace=True)
        doc = Document()
        current_module = None
        current_first_level = None
        current_second_level = None  # 记录当前的二级功能点

        for index, row in df.iterrows():
            module = row["功能模块"]
            first_level = row["一级功能点"]
            second_level = row["二级功能点"]
            key_point = row["功能要点"]
            workload = row["工作量（人天）"]
            price = row["单价"]

            # 添加一级标题（功能模块）
            if pd.notna(module) and module != current_module:
                doc.add_heading(module, level=1)
                current_module = module

            # 添加二级标题（一级功能点）
            if pd.notna(first_level) and first_level != current_first_level:
                doc.add_heading(first_level, level=2)
                current_first_level = first_level

            # 添加三级标题（二级功能点）
            if pd.notna(second_level) and second_level != current_second_level:
                doc.add_heading(second_level, level=3)
                current_second_level = second_level

            # 添加功能要点、工作量和单价
            doc.add_paragraph(f"功能要点: {key_point}")
            doc.add_paragraph(f"工作量: {workload} 人天")
            doc.add_paragraph(f"单价: {price}")

        output_path = file_path.replace(".xlsx", ".docx")
        doc.save(output_path)
        return output_path

if __name__ == '__main__':
    app = QApplication(sys.argv)
    window = ExcelToWordApp()
    window.show()
    sys.exit(app.exec())