[Python] 여러개의 엑셀 파일을 한번에 CSV 파일로 변환하는 방법

import time
import pandas as pd
from watchdog.observers import Observer
from watchdog.events import FileSystemEventHandler

class ExcelToCSVHandler(FileSystemEventHandler):
    def __init__(self, watch_folder):
        self.watch_folder = watch_folder
        self.processed_files = set()

    def on_created(self, event):
        if not event.is_directory and event.src_path.lower().endswith(('.xlsx', '.xls')):
            self.convert_excel_to_csv(event.src_path)

    def on_modified(self, event):
        if not event.is_directory and event.src_path.lower().endswith(('.xlsx', '.xls')):
            self.convert_excel_to_csv(event.src_path)

    def convert_excel_to_csv(self, excel_filepath):
        filename, ext = os.path.splitext(os.path.basename(excel_filepath))
        csv_filepath = os.path.join(self.watch_folder, f"{filename}.csv")

        if excel_filepath not in self.processed_files and not os.path.exists(csv_filepath):
            try:
                df = pd.read_excel(excel_filepath)
                df.to_csv(csv_filepath, index=False, encoding='utf-8-sig')
                print(f"'{os.path.basename(excel_filepath)}'을(를) '{os.path.basename(csv_filepath)}'로 변환했습니다.")
                self.processed_files.add(excel_filepath)
            except Exception as e:
                print(f"'{os.path.basename(excel_filepath)}' 변환 중 오류 발생: {e}")

def monitor_folder(folder_path):
    event_handler = ExcelToCSVHandler(folder_path)
    observer = Observer()
    observer.schedule(event_handler, folder_path, recursive=False)
    observer.start()
    try:
        while True:
            time.sleep(1)
    except KeyboardInterrupt:
        observer.stop()
    observer.join()

if __name__ == "__main__":
    watch_folder = input("CSV 파일로 변환할 엑셀 파일이 있는 폴더 경로를 입력하세요: ")
    if os.path.isdir(watch_folder):
        print(f"'{watch_folder}' 폴더를 감시합니다...")
        monitor_folder(watch_folder)
    else:
        print("유효하지 않은 폴더 경로입니다.")</code></pre>

pip install pandas watchdog