List files in specified directory without subdirectories

Question

How can I only go through files without files in subfolders? The code below traverses all excel files, including those in subfolders.

dirpath=Path(pl.PureWindowsPath(values['-FIN-']))
for path in dirpath.rglob("*.xls*"):

Answer 1

Employ the glob method rather than rglob, and use the is file() method to determine whether the path is a file or a directory.

from pathlib import Path
import os

dirpath = Path(values['-FIN-'])
for path in dirpath.glob("*.xls*"):
    if path.is_file():
        print(path)