下面是python代码
import pandas as pd
import os
def csv_to_xlsx(csv_path, xlsx_path):
# 读取CSV文件
df = pd.read_csv(csv_path)
# 将数据写入XLSX文件
df.to_excel(xlsx_path, index=False, engine='openpyxl')
def batch_convert(input_directory, output_directory):
# 确保输出目录存在
if not os.path.exists(output_directory):
os.makedirs(output_directory)
# 遍历输入目录中的所有CSV文件
for filename in os.listdir(input_directory):
if filename.endswith(".csv"):
csv_path = os.path.join(input_directory, filename)
xlsx_path = os.path.join(output_directory, filename.replace('.csv', '.xlsx'))
csv_to_xlsx(csv_path, xlsx_path)
print(f"Converted {csv_path} to {xlsx_path}")
# 使用方法
input_directory = 'path_to_csv_files' # 替换为您的CSV文件目录
output_directory = 'path_to_save_xlsx_files' # 替换为您想保存XLSX文件的目录
batch_convert(input_directory, output_directory)
|