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