从多个csv文件中提取特定单元格，并将其复制到新的excel文件中

import pandas as pd
from openpyxl import Workbook

# 读取CSV文件并提取特定单元格
def extract_cells_from_csv(csv_file):
    df = pd.read_csv(csv_file)  # 读取CSV文件为DataFrame对象
    cell_value = df.iloc[row_index, col_index]  # 提取特定单元格的值
    return cell_value

# 创建新的Excel文件并复制单元格值
def copy_cells_to_excel(csv_files, excel_file):
    wb = Workbook()  # 创建工作簿对象
    ws = wb.active  # 获取默认工作表

    for csv_file in csv_files:
        cell_value = extract_cells_from_csv(csv_file)  # 提取特定单元格的值
        ws.cell(row=row_index, column=col_index, value=cell_value)  # 写入Excel文件的相应单元格

    wb.save(excel_file)  # 保存Excel文件
    wb.close()  # 关闭工作簿

# 定义CSV文件路径、行索引和列索引
csv_files = ['file1.csv', 'file2.csv', 'file3.csv']
excel_file = 'output.xlsx'
row_index = 0
col_index = 0

copy_cells_to_excel(csv_files, excel_file)  # 执行复制操作