How to copy multiple sheets and merge to another sheet in excel file

How to copy multiple sheets and merge to another sheet in excel file.

I am getting below error:-
Copy Sheet: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).

Hi @rajat_dhammi

I have used join data table activity to merge two sheets and writing into 3rd sheet.

I think this might help your scenario.

Please find the attached workflow and input&output excel attached.

Thanks
Latika :slight_smile:
joinTables.xaml (6.8 KB) Input and Output.xlsx (12.3 KB)