将多个xlsx文件合并为一个文件

import pandas as pd
import openpyxl
from openpyxl import Workbook
from tencentcloud.cos import CosConfig
from tencentcloud.cos import CosS3Client

# 配置腾讯云COS的访问密钥
secret_id = 'your_secret_id'
secret_key = 'your_secret_key'
region = 'your_region'

# 创建COS客户端
config = CosConfig(Region=region, SecretId=secret_id, SecretKey=secret_key)
client = CosS3Client(config)

# 下载多个xlsx文件到本地
file_list = ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']
for file in file_list:
    response = client.get_object(
        Bucket='your_bucket',
        Key=file,
    )
    with open(file, 'wb') as f:
        f.write(response['Body'].get_raw_stream().read())

# 合并xlsx文件
merged_data = pd.DataFrame()
for file in file_list:
    data = pd.read_excel(file)
    merged_data = merged_data.append(data)

# 创建目标文件
target_file = 'merged.xlsx'
merged_data.to_excel(target_file, index=False)

# 上传目标文件到COS
with open(target_file, 'rb') as f:
    response = client.put_object(
        Bucket='your_bucket',
        Key=target_file,
        Body=f,
    )