How to list out specific excel files

[ajay_pal7]

Hi


iam beginner to python. i want to list out xlsx & xlsm (i no need "xls" files) files from a directory (or including all subdirectories) using python


Regards
Ajay

[deanhystad]

A starting point:

import os

for file in os.scandir():
    if file.is_dir():
        print('/', file.name, sep='')
    else:
        print(file.name)

When I run this I see:

Output:
model.py
part_test.py
regex.py
sandbox.py
__init__.py
/__pycache__

Another interesting function in the os module are chdir(). You can read about them here: https://docs.python.org/2/library/os.html

[Larz60+]

or with pathlib:

>>> from pathlib import Path
>>> p = Path('.')
>>> excelfiles = [x for x in p.iterdir() if x.is_file() and (x.suffix == '.xlsx' or x.suffix == '.xlsm')]
>>> for filename in excelfiles:
...     print(filename.name)
... 
PreliminaryDataByCongressionalDistrict2002.xlsx
PreliminaryDataByCongressionalDistrict2004.xlsx
PreliminaryDataByCongressionalDistrict2006.xlsx
PreliminaryDataByCongressionalDistrict2008.xlsx
PreliminaryDataByCongressionalDistrict2010.xlsx
PreliminaryDataByCongressionalDistrict2012.xlsx
PreliminaryDataByCongressionalDistrict2014.xlsx