import tkinter as tk
from tkinter import ttk
import openpyxl
 
def update_progress(progress_var, total_rows_processed, total_rows):
    """
    更新進(jìn)度條百分比
    progress_var: Tkinter 進(jìn)度變量
    total_rows_processed: 已處理行數(shù)
    total_rows: 總行數(shù)
    """
    progress = total_rows_processed / total_rows * 100
    progress_var.set(progress)
 
def process_sheet(sheet, progress_var, root, progress_label):
    """
    處理單個(gè) Sheet，將所有單元格轉(zhuǎn)為字符串格式，
    并處理合并單元格的值獲取。
    sheet: 要處理的工作表
    progress_var: Tkinter 進(jìn)度變量
    root: Tkinter 主窗口（用于刷新界面）
    progress_label: 進(jìn)度文本標(biāo)簽
    """
 
    total_rows_processed = 0          # 已處理行數(shù)
    total_rows = sheet.max_row       # 當(dāng)前 sheet 的行數(shù)
 
    # 遍歷所有行
    for row in sheet.iter_rows():
        # 遍歷行內(nèi)所有單元格
        for cell in row:
            # 判斷單元格是否屬于合并單元格
            if cell.coordinate in sheet.merged_cells:
                # 獲取該單元格所屬合并區(qū)域
                merged_range = sheet.merged_cells[cell.coordinate]
                # 獲取合并單元格左上角坐標(biāo)
                top_left_cell = merged_range.min_row, merged_range.min_col
                # 取左上角單元格的值
                value = sheet.cell(*top_left_cell).value
            else:
                # 非合并單元格直接取值
                value = cell.value
 
            # 將單元格內(nèi)容強(qiáng)制轉(zhuǎn)換為字符串
            cell.value = str(value)
 
        # 該行處理完成
        total_rows_processed += 1
 
        # 更新進(jìn)度條顯示
        update_progress(progress_var, total_rows_processed, total_rows)
        progress_label.config(
            text=f"Progress: {progress_var.get():.2f}%, Rows Processed: {total_rows_processed}/{total_rows}"
        )
        root.update_idletasks()  # 強(qiáng)制刷新界面
 
if __name__ == "__main__":
 
    file_path = "output_file.xlsx"  # Excel 文件路徑
    workbook = openpyxl.load_workbook(file_path)
 
    # 創(chuàng)建 Tkinter GUI 窗口
    root = tk.Tk()
    root.title("Excel 文本化轉(zhuǎn)換（含進(jìn)度條）")
    root.geometry("500x300")
 
    # 進(jìn)度條變量
    progress_var = tk.DoubleVar(value=0)
 
    # 進(jìn)度條控件
    progress_bar = ttk.Progressbar(root, mode="determinate",
                                   variable=progress_var, maximum=100)
    progress_bar.pack(pady=10)
 
    # 顯示文本的標(biāo)簽
    progress_label = tk.Label(root, text="Progress: 0.00%, Rows Processed: 0")
    progress_label.pack(pady=5)
 
    total_rows_processed = 0  # 總計(jì)處理行數(shù)
 
    # 遍歷所有 Sheet 逐一處理
    for sheet_name in workbook.sheetnames:
        sheet = workbook[sheet_name]
        total_rows = sheet.max_row
        process_sheet(sheet, progress_var, root, progress_label)
        total_rows_processed += total_rows
 
    # 所有 Sheet 處理完畢，顯示 100%
    update_progress(progress_var, total_rows_processed, total_rows_processed)
    progress_label.config(
        text=f"Progress: 100.00%, Rows Processed: {total_rows_processed}/{total_rows_processed}"
    )
    root.update_idletasks()
 
    # 保存修改
    workbook.save(file_path)
 
    # 顯示完成界面
    root.mainloop()

if cell.coordinate in sheet.merged_cells:

merged_range = sheet.merged_cells[cell.coordinate] top_left_cell = merged_range.min_row, merged_range.min_col value = sheet.cell(*top_left_cell).value

root.update_idletasks()

cell.value = str(value)