Python代码用最近提交的日期和时间覆盖excel中以前的日期和时间数据。

import datetime
import openpyxl

now = datetime.datetime.now()

workbook = openpyxl.load_workbook('your_excel_file.xlsx')

worksheet = workbook['your_worksheet']

date_time_range = worksheet['A1:A10']  # 假设数据在A1到A10单元格范围内

for cell in date_time_range:
    cell.value = now

workbook.save('your_modified_excel_file.xlsx')