使用Python遍历文件夹并提取Excel列

import os
import pandas as pd

def extract_excel_column(folder_path, column_name):
    file_list = []
    for root, dirs, files in os.walk(folder_path):
        for file in files:
            if file.endswith(".xlsx") or file.endswith(".xls"):
                file_list.append(os.path.join(root, file))
    
    column_data = []
    for file_path in file_list:
        df = pd.read_excel(file_path)
        if column_name in df.columns:
            column_data.extend(df[column_name].tolist())
    
    return column_data

folder_path = "文件夹路径"
column_name = "要提取的列名"
result = extract_excel_column(folder_path, column_name)