如何通过 python 从 excel 复制/粘贴合并的单元格？

问：

我尝试使用 openpyxl 并遇到了很多麻烦，现在我正在尝试 pandas 并获得大量回溯。似乎复制粘贴合并的单元格很难而且非常具体，要么就是这样，要么我只是一个菜鸟。任何人都可以提供帮助提示或解决方案吗？

这是我与熊猫的代码

import os
import pandas as pd

# Set the paths for the interim and finals folders
interim_folder = r'C:\Users\Jake_\Downloads\Code\Interims'
finals_folder = r'C:\Users\Jake_\Downloads\Code\Finals'

# Get a list of all files in the interim folder
interim_files = os.listdir(interim_folder)

# Iterate over each file in the interim folder
for file_name in interim_files:
    # Check if the file is an Excel file
    if file_name.endswith('.xlsx'):
        interim_file_path = os.path.join(interim_folder, file_name)
        finals_file_path = os.path.join(finals_folder, file_name)

        # Read the interim Excel file using pandas with the xlrd engine
        interim_data = pd.read_excel(interim_file_path, sheet_name='Financial Report Interim Mar 10', engine='xlrd')

        # Copy the required data to a new DataFrame
        finals_data = pd.DataFrame()
        finals_data['Column B'] = interim_data.iloc[3:8, 1]  # Copy B4:B8
        finals_data['Column D'] = interim_data.iloc[5:201, 3]  # Copy D6:D200
        finals_data['Column E'] = interim_data.iloc[5:201, 4]  # Copy E6:E200
        finals_data['Column F'] = interim_data.iloc[5:201, 5]  # Copy F6:F200
        finals_data['Column G'] = interim_data.iloc[5:201, 6]  # Copy G6:G200

        # Write the data to the finals Excel file
        writer = pd.ExcelWriter(finals_file_path, engine='openpyxl')
        finals_data.to_excel(writer, sheet_name='Final Financial Report July 7', index=False)
        writer.save()

这是我得到的回溯

我想做什么：我在一个名为 interims 的文件夹中大约有 100 个文件 - 每个文件都有一个相应的文件，该文件与一个名为 finals 的文件夹同名。我想从名为“Financial Report Interim Mar 10”的特定工作表中从临时文件夹中的每个文件中复制特定的几个单元格，然后粘贴到名为“Final Financial Report July 7 July 7”的工作表中，该工作表位于 finals 文件夹中的相应文件中。已经尝试并失败了大约 6 个小时。

谢谢

尝试使用 openpyxl 和现在的 pandas，仍然没有运气。