一次性写入
import pandas as pd
from openpyxl import Workbook# CSV 文件路径
csv_file = 'D:\\desktop\\output.csv'# XLSX 文件路径
xlsx_file = 'D:\\desktop\\output.output.xlsx'# 读取 CSV 文件
data = pd.read_csv(csv_file)# 将 DataFrame 写入 XLSX 文件
data.to_excel(xlsx_file, index=False)print(f"Data has been exported to {xlsx_file}")
分批写入
备注:chunksize 是 pandas.read_csv()和 pandas.read sql() 等读取数据的函数中的一个可选参数。它指定了每次从数据源中读取的数据块的大小。
import pandas as pd
from openpyxl import Workbook
from openpyxl.writer.excel import ExcelWriter# CSV 文件路径
csv_file = 'D:\\desktop\\output.csv'# XLSX 文件路径
xlsx_file = 'D:\\desktop\\11111.xlsx'# 创建一个新的工作簿
workbook = Workbook()
writer = pd.ExcelWriter(xlsx_file, engine='openpyxl')# 读取 CSV 文件,分批读取
chunksize = 9999
for i, chunk in enumerate(pd.read_csv(csv_file, chunksize=chunksize)):# 第一次写入时包含表头if i == 0:chunk.to_excel(writer, sheet_name='Sheet1', index=False, header=True)else:chunk.to_excel(writer, sheet_name='Sheet1', index=False, header=False, startrow=writer.sheets['Sheet1'].max_row)# 保存工作簿
writer.close()print(f"Data has been exported to {xlsx_file}")