I have multiple Excel files in a directory and I am looking to combine all of them into a single file where each file is its own worksheet. I found this solution but it does not keep formatting.
The Excel files I am loading are not in a normal table format where pd.read_excel() will work. Also in openpyxl documentation, Workbook.copy_worksheet() can only be used to create copies within a single workbook.
All of the solutions I have found seem to iterate over every row/column and writes the cell value to the new worksheet, which does not carry the formatting.
