读取xmsx文件，将里面的时间+1 或者 -1 修改并保存

import os

import openpyxl
from datetime import datetime, timedelta


def get_files_in_directory(directory):
    return [f for f in os.listdir(directory) if os.path.isfile(os.path.join(directory, f))]


if __name__ == '__main__':
    directory = "file/source/"  # 替换为你的目录路径
    files = get_files_in_directory(directory)
    print(files)
    for file in files:
        workbook = openpyxl.load_workbook('file/source/{}'.format(file))
        worksheet = workbook['Sheet1']  # 将'Sheet1'替换为您要修改的工作表名称

        num = 1
        data_row_count = worksheet.max_row
        while num < data_row_count:
            num += 1
            cell = worksheet['I{}'.format(num)]  # 选择要修改的单元格，这里以A1为例
            date = datetime.strptime("{}".format(cell.value), "%Y-%m-%d %H:%M:%S")
            date = date.replace(year=2023, month=9, day=15)

            # 日期前一天后一天
            cell_j = worksheet['J{}'.format(num)]
            cell_k = worksheet['K{}'.format(num)]
            cell_l = worksheet['L{}'.format(num)]

            date_j = date + timedelta(minutes=1)
            cell_j.value = date_j  # 将单元格的值更改为新值

            date_k = date - timedelta(minutes=1)
            cell_k.value = date_k  # 将单元格的值更改为新值

            cell_l.value = date  # 将单元格的值更改为新值

        workbook.save('file/tager/out_{}'.format(file))  # 将文件名替换为原始文件名（不需要扩展名）