How to open and loop through multiple excel workbooks?
Created originally on Bitbucket by osakoo (Osako Kodu)
Hello,
I have multiple excel files in a folder and I want to open each one of them and implement some code and close. Say I have 20 files: I want to open each one them, retrieve some values, do some processing, and then write to a single file. The 20 files may or may not be formatted the same way. My issue, specifically, is how to open multiple files without having to use
#!python
load_workbook()
for each one of them.
Thanks,