Python 将从excel获取的日期格式转换为字符串时间

  
    def get_data(self, sheet, header, row, key):
        maintenance_field = {
            "get_date": "date2"
        }
        val = maintenance_field[key]
        if val in header:
            id = header.index(val)
            if id:
                value = sheet.row_values(row)[id]
                # 单元类型ctype：empty为0，string为1，number为2，date为3，boolean为4， error为5
                type = sheet.cell_type(row, id)
                if value and type == 2:
                    value = int(value)
                elif type == 3:
                    date_formatted = datetime(1900, 1, 1) + timedelta(days=value-2) # value 需要减2，否则日期会向前推2天
                    value = date_formatted.strftime('%Y/%m/%d')
                    value = value.split('/')[0] + '/' + value.split('/')[1].replace('0', '') + '/' + \
                            value.split('/')[2].replace('0', '')
                return value
            else:
                return None

date_formatted = datetime(1900, 1, 1) + timedelta(days=value-2)  # 需要注意的是， value 需要减2，否则日期会向前推2天
value = date_formatted.strftime('%Y/%m/%d')