import pandas as pd
df=pd.read_excel('D:\project\引出数据_销售订单.xlsx')
#data=df.head()
#print("获取前五行:\n{0}".format(data))
df2=pd.read_excel("D:\project\引出数据_销售订单.xlsx")
df2[['*单据编号 # billno','*单据日期 # billdate','*客户.名称 # customerid.name']]=df2[['*单据编号 # billno','*单据日期 # billdate','*客户.名称 # customerid.name']].fillna(method='ffill')#method=ffill 向下填充
outpathfile='D:/project/sellorder_temp.xlsx'
df2.to_excel(outpathfile)