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

import pandas as pdfrom 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 = Nonecurrent_first_level = Nonecurrent_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 sysimport pandas as pdfrom docx import Documentfrom PyQt6.QtWidgets import QApplication, QWidget, QVBoxLayout, QPushButton, QFileDialog, QLabel, QMessageBoxclass 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_pathif __name__ == '__main__':    app = QApplication(sys.argv)    window = ExcelToWordApp()    window.show()    sys.exit(app.exec())