如下：

python
import pandas as pd

# 读取Excel文件
file_path = "source.xlsx"  # Excel文件路径
df = pd.read_excel(file_path)

email_column = "客户接收报价单的邮箱"  # 替换为实际的邮箱列名

# 创建一个新的DataFrame，用于存放拆分后的结果
new_data = []

# 遍历原始数据
for index, row in df.iterrows():
    emails = str(row[email_column]).replace('，',',').split(",")  # 按逗号分隔多个邮箱
    for email in emails:
        new_row = row.copy()
        new_row[email_column] = email.strip()  # 去除邮箱的空格
        new_data.append(new_row)

# 转换为新的DataFrame
new_df = pd.DataFrame(new_data)

# 保存为新的Excel文件
output_file = "processed_file.xlsx"
new_df.to_excel(output_file, index=False)

print(f"数据已成功处理并保存为 {output_file}")