你可以这么做

xslx_files=[]
files = os.listdir(file_path)
    print(len(files)) <--gets counts of all files in subdirctory too
 for f in files:
  if (f.endswith('.xlsx')):
    xslx_files.append(f)
print(len(xslx_files))