import pandas as pddef write_batches_to_excel(data, batch_size, filename):"""将数据分批写入Excel文件。:param data: 二维列表,其中每个子列表代表一行数据:param batch_size: 每个批次包含的数据行数:param filename: 输出Excel文件的名称"""writer = pd.ExcelWriter(filename)for i in range(0, len(data), batch_size):# 获取当前批次的数据batch_data = data[i:i + batch_size]# 将批次数据转换为DataFramedf = pd.DataFrame(batch_data)# 第一次写入时包含表头if i == 0:df.to_excel(writer, sheet_name='Sheet1', index=False, header=False)else:df.to_excel(writer, sheet_name='Sheet1', index=False, header=False, startrow=writer.sheets['Sheet1'].max_row)writer.close()# 示例用法
data = [['A0', 'B0', 'C0'],['A1', 'B1', 'C1'],['A2', 'B2', 'C2'],['A3', 'B3', 'C3'],['A4', 'B4', 'C4'],['A5', 'B5', 'C5'],['A6', 'B6', 'C6'],['A7', 'B7', 'C7'],
]batch_size = 3
filename = "D:\\desktop\\1234.xlsx"write_batches_to_excel(data, batch_size, filename)