需要与导入的csv完全相同地导出csv

import csv

def export_csv(input_file, output_file):
    with open(input_file, 'r', encoding='utf-8-sig') as infile, \
         open(output_file, 'w', encoding='utf-8-sig', newline='') as outfile:
        reader = csv.reader(infile)
        writer = csv.writer(outfile)
        
        for row in reader:
            writer.writerow(row)

# 使用示例
input_csv = 'input.csv'
output_csv = 'output.csv'
export_csv(input_csv, output_csv)

import csv

def export_csv_with_special_chars(input_file, output_file):
    with open(input_file, 'r', encoding='utf-8-sig') as infile, \
         open(output_file, 'w', encoding='utf-8-sig', newline='') as outfile:
        reader = csv.reader(infile)
        writer = csv.writer(outfile, quoting=csv.QUOTE_ALL)  # 强制所有字段加引号
        
        for row in reader:
            writer.writerow(row)

# 使用示例
input_csv = 'input_with_special_chars.csv'
output_csv = 'output_with_special_chars.csv'
export_csv_with_special_chars(input_csv, output_csv)