import pandas as pd
data = pd.read_excel(r'C:\Users\Desktop\sjcs.xlsx')
for i in range(0, data.shape[0]):
if data.iloc[i, 0] == 0:
new_data = data.iloc[i:i + 3]
write = pd.ExcelWriter('C:/Users/Desktop/new_data.xlsx', engine='openpyxl')
new_data.to_excel(write, header=None, index=False, startrow=0, startcol=0)
write.save()
write.close()
因为你每次都写到了 startrow=0, startcol=0 ,将上一次的覆盖了?
startrow=i+1