def rename_and_move_files(self):
    if not self.source_folder or not self.rules_folder:
        self.log_text.append('請確保已選擇源文件夾和規(guī)則文件夾！')
        return

    try:
        excel_file = os.listdir(self.rules_folder)[0]
        df = pd.read_excel(os.path.join(self.rules_folder, excel_file))

        for index, row in df.iterrows():
            old_name = row['源文件名']
            new_name = row['新文件名']

            old_file_path = os.path.join(self.source_folder, old_name)

            if os.path.isfile(old_file_path):
                new_file_path = os.path.join(self.target_folder, new_name)
                shutil.move(old_file_path, new_file_path)
                self.log_text.append(f"文件 '{old_name}' 已重命名為 '{new_name}' 并移動至文件夾【修改后】。")
            else:
                self.log_text.append(f"文件 '{old_name}' 未找到，保留在文件夾【數(shù)據(jù)源】。")
        self.log_text.append("文件重命名和移動操作完成！")
    except Exception as e:
        self.log_text.append(f"出現(xiàn)錯誤: {e}")

# -*- coding: UTF-8 -*-

import os
import pandas as pd
import shutil

def select_folder(prompt):
    folder = prompt
    if not os.path.isdir(folder):
        print(f"文件夾路徑 '{folder}' 無效，請重新輸入。")
        return select_folder(prompt)
    return folder

def rename_and_move_files(source_folder, rules_folder, target_folder):
    if not os.path.exists(target_folder):
        os.makedirs(target_folder)

    try:
        # 讀取Excel文件（假設只有一個Excel文件）
        excel_file = os.listdir(rules_folder)[0]
        df = pd.read_excel(os.path.join(rules_folder, excel_file))

        # 遍歷Excel的每一行
        for index, row in df.iterrows():
            old_name = row['源文件名']
            new_name = row['新文件名']

            # 構建源文件的完整路徑
            old_file_path = os.path.join(source_folder, old_name)

            if os.path.isfile(old_file_path):
                # 構建新的文件路徑
                new_file_path = os.path.join(target_folder, new_name)

                # 移動并重命名文件
                # shutil.move(old_file_path, new_file_path)
                # 復制并重命名文件
                shutil.copy(old_file_path, new_file_path)
                print(f"文件 '{old_name}' 已重命名為 '{new_name}' 并移動至文件夾【{target_folder}】。")
            else:
                print(f"文件 '{old_name}' 未找到，保留在文件夾【{source_folder}】。")
        print("文件重命名和移動操作完成！")
    except Exception as e:
        print(f"出現(xiàn)錯誤: {e}")

def main():
    source_folder = select_folder('待命名數(shù)據(jù)源')
    rules_folder = select_folder('命名規(guī)則')
    target_folder = '修改后'

    rename_and_move_files(source_folder, rules_folder, target_folder)

if __name__ == '__main__':
    main()