python: excel 换行符(_x000D_)

data4 = dataframe1.loc[4:34]
for idx, datavalue in data4.iterrows():
    #strnum=Common.Utils.Utils.getAnnualLeave(data)
    print("[{}]: {}".format(idx, datavalue))
    slist=datavalue.tolist()
    hbll=BLL.EmpLoyeeHolidaysGet.EmpLoyeeHolidaysGet() #病假4小時_x000D_事假0.5小時 未处理
    #print(slist)
    for i in range(len(slist)):
        #strvalue=str(slist[i]).replace(r'\s+|\\n', ' ', regex=True)  _x000D_
        strvalue = str(slist[i]).replace('_x000D_', ' ')  # 规换单元格的换行符，否则处理不了正确数据
        strnums = hbll.getHolidays(strvalue)  # float str
        for sn in range(len(strnums)):
              print("str:",strnums[sn].HolidayName,strnums[sn].WorkTime)
 
    print("类型：",type(datavalue))
print("*************")