I have multiple Excel files in a directory that are all formatted the same. I.E. They all share the same column structure and all only contain 1 sheet.
I would like to take the contents of each of those excel files and add them to a Target excel file in a different directory.
I have everything but the “Append” content part working. The contents of each of the Excel files are not getting written to the Target file…