代码Python实现Excel数据合并

import os from openpyxl import Workbook, load_workbook # 定义路径和保存的新文件名 dir_path = 'F:/code_test/fenlei' new_file_name = 'merged.xlsx' # 初始化一个新的工作簿对象 merged_book = Workbook() merged_sheet = merged_book.active # 遍历目录下的所有xlsx文件 for filename in os.listdir(dir_path): if filename.endswith('.xlsx'): file_path = os.path.join(dir_path, filename) print(f"Reading data from {file_path}") # 读取文件中的工作表 file_book = load_workbook(file_path) file_sheet = file_book.active # 遍历数据行并将它们复制到新的工作表中 for row in file_sheet.iter_rows(values_only=True): merged_sheet.append(row) # 将数据保存到新文件中 merged_book.save(os.path.join(dir_path, new_file_name)) print("All files have been merged and saved to " + new_file_name)