import os, pandas as pd from openpyxl import load_workbook input_folder = r"d:\input" output_file = r"d:\output\合并交易流水.xlsx