解决python 读取excel时 日期变成数字并加.0的问题

import xlrd
from datetime import datetime
from xlrd import xldate_as_datetime, xldate_as_tuple
filename = r'C:\Users\Administrator\Desktop\niceloo\10月\流水.xlsx'
rbook = xlrd.open_workbook(filename)
table = rbook.sheets()[0]
rows = table.nrows
cols = table.ncols
print("行数为%s \n列数为%s"%(rows,cols))
row = table.row_values(1)
print(row)

real_date_1 = datetime(*xldate_as_tuple(row[0],0)).strftime('%Y-%m-%d')
print(real_date_1)

real_date_2 = xldate_as_datetime(row[0],0).strftime('%m/%d')
print(real_date_2 )