写入Excel时去掉时分秒

import pandas as pd

df=pd.read_excel("d:\\在制.xlsx")
df['交期']=pd.to_datetime(df['交期']).dt.date
print(df)
df.to_excel('d:\\在制new.xlsx',index=False)