Get list of files in a folder
Tonight's tip shows how to perform another basic task using a basic Python script. Using Python IDLE 3.4.2, we'll get a list of all of the Excel files in this directory:
Open Python IDLE and import the glob module.
>>> import glob
Then use this command to generate a list of the files with particular extension in the specified directory. >>> glob.glob("C:\FooFolder\python\*.xlsx")
These results are returned: