read multiple .xlsx files and text files in a directory

[BNB]

Well, just an update, I have solved my issue with openpyxl but its just that openpyxl is not very helpful in saving images (as mentioned in its documentation) from original excel file and it disappears when you save the workbook.
Any other libraries that is compatible with xlsx files, can modify/append worksheets and save it in original form with images/formatting ?