How to merge multiple sheets

I am having multiple sheets in a single excel. i want to merge all these sheets into new sheet in same excel.When trying to merge all the data is not written in that sheet. How do i do it?


Try below steps.

  1. First use Excel Application Scope activity and create one workbook variable for this. And then use varWB.GetSheets to get all sheets from Excel file.

      Excel Application Scope 
          ForEach item in varWB.GetSheets
               - Use Read Range activity and pass item under sheet name and store output in DataTable
               - Use Merge DataTable activity to merge all sheets data and pass output of Read Range activity

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Hi @sneha_arbole

This activity helps to merge the excel sheets from different files.


1 Like