this how to read all files with type in python 3

read_xlsx.py

# reading all files with type xlsx
import os, fnmatch
rootdir = '~/' # your root path 
for subdir, dirs, files in os.walk(rootdir):
    for file in files:
        if fnmatch.fnmatch(file, '*.xlsx'):
            print(os.path.join(subdir, file))