I want to combine dynamically created excels into one excel file. The format of these excels will be same but the number of files that will be generated is not constant.
I tried using the search functionality to get the paths of the files from the folder but after that using import datatable doesn’t work and it requires configuring headers.
Also tried using excel merge but it combines the sheet from excel.
Could you please help on this.
Thanks and Regards,