read multiple .xlsx files and text files in a directory

[volcano63]

......
I would still look at pandas. I am not saying that there is anything wrong with the package you are using, but I had problems with a few when I needed to manipulate excel.

At the risk of facing fire and brimstone   , I would like to point out that pandas  - great package, BTW - may be intimidating for beginners.

And its functioning against Excel is not without flaws. When I saved a huge dataframe that contained a column of string digits, it (the column) was saved as numbers in Excel. Lucky for me, they were saved as integers - otherwise, my data would have been corrupted (like when it was converted to scientific form ).

pandas will not provide you with formatting options either.

Pandas is rock solid, and offers many more features

About "rock solid" - they have been making some changes that are not backward-compatible lately, I believe?! And occasionally you don't need "more features"

---

......
I would still look at pandas. I am not saying that there is anything wrong with the package you are using, but I had problems with a few when I needed to manipulate excel.

At the risk of facing fire and brimstone   , I would like to point out that pandas  - great package, BTW - may be intimidating for beginners.

And its functioning against Excel is not without flaws. When I saved a huge dataframe that contained a column of string digits, it (the column) was saved as numbers in Excel. Lucky for me, they were saved as integers - otherwise, my data would have been corrupted (like when it was converted to scientific form ).

pandas will not provide you with formatting options either.

Pandas is rock solid, and offers many more features

About "rock solid" - they have been making some changes that are not backward-compatible lately, I believe?! And occasionally you don't need "more features"