pip install openpyxl import openpyxl wb = openpyxl.load_workbook('example.xlsx') sheet = wb['Sheet1'] sheet = wb[0] import datetime date_value = sheet['A1'].value date = datetime.datetime.date(date_value) time_value = sheet['B1'].value time = datetime.datetime.time(time_value) import datetime now = datetime.datetime.now() sheet['A1'].value = now.date() sheet['B1'].value = now.time() wb.save('example.xlsx')