帮我写一段python代码用于将多个excel表格合成一个

Sure! Here's a Python code snippet that combines multiple Excel worksheets into one:

import pandas as pd

# List of Excel files to be combined
excel_files = ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']

# Create an empty DataFrame to store the combined data
combined_data = pd.DataFrame()

# Iterate through each Excel file
for file in excel_files:
    # Read each sheet of the Excel file into a DataFrame
    sheets = pd.read_excel(file, sheet_name=None)
    
    # Iterate through each sheet in the Excel file
    for sheet_name, sheet_data in sheets.items():
        # Concatenate the sheet data to the combined data DataFrame
        combined_data = pd.concat([combined_data, sheet_data], ignore_index=True)

# Write the combined data to a new Excel file
combined_data.to_excel('combined_data.xlsx', index=False)

Make sure to replace 'file1.xlsx', 'file2.xlsx', 'file3.xlsx' with the actual file names or paths of your Excel files. The code reads each Excel file, iterates through each sheet, and concatenates the data into a single DataFrame. Finally, it writes the combined data to a new Excel file called 'combined_data.xlsx'