Read and combine data of dynamically created excel files

Hi Team,

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,
Vibhor Mahajan

Hi,

To merge two excel files you will have to use a microbot as this feature is not supported out of box by the product

Regards,
Amit