I need to add a new line from an excel file to a dict that has a date value, but this date value was entered in text format in the excel file's cell f. This is my code to accomplish that; the datetime issue is present.
however, it was put into the Excel file in text format.
Declaration_dict = Excel_Dict(r"\\path_to_excel_file.xlsx")
for row in Declaration_dict:
if row['statut'] == 'OK':
line_declaration = (row['Cle_modifiee'], row['via'], row['Reference'], datetime.fromisoformat(row['Date']).strftime("%d/%m/%Y"), row['Detail'], row['NOM'], row['User'], row['Metier'], row['Equipe'], row['Libelle'])