Python Openpyxl调度将时间戳范围替换为字符串

pip install openpyxl

import openpyxl
from datetime import datetime

# 打开Excel文件
workbook = openpyxl.load_workbook('example.xlsx')

# 选择要操作的工作表
sheet = workbook['Sheet1']

# 遍历每个单元格
for row in sheet.iter_rows(min_row=2, max_row=sheet.max_row, min_col=1, max_col=sheet.max_column):
    for cell in row:
        # 判断单元格的值是否为时间戳范围
        if isinstance(cell.value, datetime):
            # 将时间戳范围转换为字符串
            cell.value = cell.value.strftime('%Y-%m-%d %H:%M:%S')

# 保存修改后的Excel文件
workbook.save('example_modified.xlsx')