0

I have a folder full of Excel workbooks with each workbook having a different number of sheets. I have a dictionary with key:value pairs being the key = workbook file path name and the value = a list of sheets associated with each workbook key in pairs.

Is it possible to use pandas to open these workbook files with a for loop somehow? I have been searching the internet for an answer to this question, but I am not able to find anything and I am wondering if this is possible.

Thank you.

I would like to open these workbooks and sheets en mass.

Jessica
  • 23
  • 2
  • Does this answer your question? [Import multiple excel files into python pandas and concatenate them into one dataframe](https://stackoverflow.com/questions/20908018/import-multiple-excel-files-into-python-pandas-and-concatenate-them-into-one-dat) – Laurent Nov 05 '22 at 09:00

0 Answers0