pip install wxPython    # 用于創(chuàng)建圖形界面
pip install openpyxl    # 用于處理Excel文件
pip install pypinyin    # 用于中文轉(zhuǎn)拼音

import wx
import openpyxl
from pypinyin import pinyin, Style
import os

class MainFrame(wx.Frame):
    def __init__(self):
        super().__init__(parent=None, title='Excel中文轉(zhuǎn)拼音縮寫(xiě)工具', size=(500, 300))
        self.init_ui()
        
    def init_ui(self):
        panel = wx.Panel(self)
        vbox = wx.BoxSizer(wx.VERTICAL)
        
        # 創(chuàng)建文件選擇按鈕
        select_btn = wx.Button(panel, label='選擇Excel文件')
        select_btn.Bind(wx.EVT_BUTTON, self.on_select)
        vbox.Add(select_btn, 0, wx.ALL | wx.CENTER, 20)
        
        # 創(chuàng)建狀態(tài)顯示文本框
        self.status_text = wx.TextCtrl(panel, style=wx.TE_MULTILINE | wx.TE_READONLY)
        vbox.Add(self.status_text, 1, wx.ALL | wx.EXPAND, 20)
        
        panel.SetSizer(vbox)
        self.Centre()
        
    def on_select(self, event):
        with wx.FileDialog(self, "選擇Excel文件", wildcard="Excel files (*.xlsx)|*.xlsx",
                         style=wx.FD_OPEN | wx.FD_FILE_MUST_EXIST) as fileDialog:
            
            if fileDialog.ShowModal() == wx.ID_CANCEL:
                return
            
            pathname = fileDialog.GetPath()
            try:
                self.process_excel(pathname)
            except Exception as e:
                wx.MessageBox(f'處理文件時(shí)發(fā)生錯(cuò)誤：{str(e)}', '錯(cuò)誤',
                            wx.OK | wx.ICON_ERROR)

    def get_pinyin_abbr(self, chinese_str):
        """獲取中文的拼音縮寫(xiě)"""
        if not chinese_str or not isinstance(chinese_str, str):
            return chinese_str
            
        # 獲取每個(gè)字的拼音首字母
        abbr = ''
        for p in pinyin(chinese_str, style=Style.FIRST_LETTER):
            abbr += p[0].upper()
        return abbr
    
    def process_excel(self, filepath):
        """處理Excel文件"""
        self.status_text.SetValue("開(kāi)始處理文件...\n")
        
        # 加載工作簿
        wb = openpyxl.load_workbook(filepath)
        ws = wb.active
        
        # 查找目標(biāo)列的索引
        project_col = None
        dept_col = None
        
        for col in range(1, ws.max_column + 1):
            cell_value = ws.cell(row=2, column=col).value  # 假設(shè)第2行是標(biāo)題行
            if cell_value == "項(xiàng)目名稱(chēng)":
                project_col = col
            elif cell_value == "部門(mén)":
                dept_col = col
        
        if not project_col or not dept_col:
            raise ValueError("未找到'項(xiàng)目名稱(chēng)'或'部門(mén)'列")
        
        # 轉(zhuǎn)換內(nèi)容
        changes = []
        for row in range(3, ws.max_row + 1):  # 從第3行開(kāi)始處理
            # 處理項(xiàng)目名稱(chēng)
            project_cell = ws.cell(row=row, column=project_col)
            if project_cell.value:
                original_project = project_cell.value
                project_cell.value = self.get_pinyin_abbr(original_project)
                changes.append(f"行 {row}: 項(xiàng)目名稱(chēng) '{original_project}' -> '{project_cell.value}'")
            
            # 處理部門(mén)
            dept_cell = ws.cell(row=row, column=dept_col)
            if dept_cell.value:
                original_dept = dept_cell.value
                dept_cell.value = self.get_pinyin_abbr(original_dept)
                changes.append(f"行 {row}: 部門(mén) '{original_dept}' -> '{dept_cell.value}'")
        
        # 生成新文件名
        file_dir = os.path.dirname(filepath)
        file_name = os.path.basename(filepath)
        new_file_name = f"pinyin_{file_name}"
        new_filepath = os.path.join(file_dir, new_file_name)
        
        # 保存新文件
        wb.save(new_filepath)
        
        # 更新?tīng)顟B(tài)
        status_msg = "\n".join(changes)
        self.status_text.AppendText(f"\n轉(zhuǎn)換完成！更改詳情：\n{status_msg}\n\n新文件已保存為：{new_filepath}")

def main():
    app = wx.App()
    frame = MainFrame()
    frame.Show()
    app.MainLoop()

if __name__ == '__main__':
    main()

class MainFrame(wx.Frame):
    def __init__(self):
        super().__init__(parent=None, title='Excel中文轉(zhuǎn)拼音縮寫(xiě)工具', size=(500, 300))
        self.init_ui()
        
    def init_ui(self):
        panel = wx.Panel(self)
        vbox = wx.BoxSizer(wx.VERTICAL)
        
        # 創(chuàng)建文件選擇按鈕
        select_btn = wx.Button(panel, label='選擇Excel文件')
        select_btn.Bind(wx.EVT_BUTTON, self.on_select)
        vbox.Add(select_btn, 0, wx.ALL | wx.CENTER, 20)
        
        # 創(chuàng)建狀態(tài)顯示文本框
        self.status_text = wx.TextCtrl(panel, style=wx.TE_MULTILINE | wx.TE_READONLY)
        vbox.Add(self.status_text, 1, wx.ALL | wx.EXPAND, 20)
        
        panel.SetSizer(vbox)
        self.Centre()

def on_select(self, event):
    with wx.FileDialog(self, "選擇Excel文件", wildcard="Excel files (*.xlsx)|*.xlsx",
                      style=wx.FD_OPEN | wx.FD_FILE_MUST_EXIST) as fileDialog:
        
        if fileDialog.ShowModal() == wx.ID_CANCEL:
            return
        
        pathname = fileDialog.GetPath()
        try:
            self.process_excel(pathname)
        except Exception as e:
            wx.MessageBox(f'處理文件時(shí)發(fā)生錯(cuò)誤：{str(e)}', '錯(cuò)誤',
                        wx.OK | wx.ICON_ERROR)

def get_pinyin_abbr(self, chinese_str):
    """獲取中文的拼音縮寫(xiě)"""
    if not chinese_str or not isinstance(chinese_str, str):
        return chinese_str
        
    # 獲取每個(gè)字的拼音首字母
    abbr = ''
    for p in pinyin(chinese_str, style=Style.FIRST_LETTER):
        abbr += p[0].upper()
    return abbr

def process_excel(self, filepath):
    """處理Excel文件"""
    self.status_text.SetValue("開(kāi)始處理文件...\n")
    
    # 加載工作簿
    wb = openpyxl.load_workbook(filepath)
    ws = wb.active
    
    # 查找目標(biāo)列的索引
    project_col = None
    dept_col = None
    
    for col in range(1, ws.max_column + 1):
        cell_value = ws.cell(row=2, column=col).value
        if cell_value == "項(xiàng)目名稱(chēng)":
            project_col = col
        elif cell_value == "部門(mén)":
            dept_col = col
    
    # 轉(zhuǎn)換內(nèi)容并保存
    # ... (詳細(xì)代碼見(jiàn)完整實(shí)現(xiàn))