原因:最后需要使用writer.close()或write.save()保存文件并释放文件句柄才能正常打开
writer = pd.ExcelWriter(filename, engine='openpyxl', mode='w')
df.to_excel(writer, index = False)
#writer.close()
原因:最后需要使用writer.close()或write.save()保存文件并释放文件句柄才能正常打开
writer = pd.ExcelWriter(filename, engine='openpyxl', mode='w')
df.to_excel(writer, index = False)
#writer.close()