How to merge the 2 excel sheet without using Merge Data-table activity?

Hi all,

  1. Merge the separate EXCEL files to a single EXCEL file
  2. The individual excel names should be the sheet name in the merged excel file
  3. Merged file should be named as ‘result’

can any one help me…

Use read range on each sheet, merge the tables and write range to a new sheet. Not sure there are any activties for deleting sheets sho you m,ight have to use UI automation to delete the old sheets

1 Like

I am having 6 Sheet to read. then I want a single excel sheet by different sheet Name(that is readied excel sheet).

Using this activity you can merge the 2 excel sheet without using datatable.