How to list out specific excel files

How to list out specific excel files - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: How to list out specific excel files (/thread-24906.html)

How to list out specific excel files - ajay_pal7 - Mar-10-2020

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

RE: How to list out specific excel files - deanhystad - Mar-10-2020

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

RE: How to list out specific excel files - Larz60+ - Mar-10-2020

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