Windows - file opened by another process, still can rename it in Python

Question

On Windows OS, just before doing some actions on my file, I need to know if it's in use by another process. After some serious research over all the other questions with a similar problem, I wasn't able to find a working solution for it.

os.rename(my_file.csv, my_file.csv) is still working even if I have the file opened with ... notepad let's say.

psutil ... it took too much time and it doesn't work (can't find my file path in nt.path:

for proc in psutil.process_iter():
    try:
        flist = proc.open_files()
        if flist:
            for nt in flist:
                if my_file_path == nt.path:
                   print("it's here")
    except psutil.NoSuchProcess as err:
      print(err)

Is there any other solution for this?

UPDATE 1

I have to do 2 actions on this file: 1. check if the filename corresponds to a pattern; 2. copy it over SFTP.

UPDATE 2 + solution

Thanks to @Eryk Sun, I found out that Notepad "reads the contents into memory and then closes the handle". After opening my file with Word, os.rename and psutil are working like a (py)charm.

Answer 1

If the program You use opens the file by importing it (like Excel would do it, for example), that means that it transforms Your data in a readable form for itself, without keeping a hand on the actual file afterwards. If You save the file from there, it either saves it in the programs own format or exports (and transforms) the file back.

What dou You want to do with the file? Maybe You can simply copy the file?