I tried to use a copy sheet activity but I am getting an error , any idea how to solve this ? Thanks. 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 com…

Hope it helps [image] Excel.Copy Paste Range and copy Sheet is not working Activities Hi @jekora , Can you try these ? Regards Balamurugan.S

Hi @ecaballes , I only need to copy sheet from the same excel file.

I think copy excel sheet is not supporting for 2013 excel version. @AhmedKutraphali

I think you can use write range see sample below Main.xaml (7.8 KB) test.xlsx (10.5 KB)

i see, This is Excel Bug, for workaround [image] Copy Sheet activity throwing exception Help Hi @rchernysh , Can you try this to copy the sheet? Regards Balamurugna.S

do you have any idea or alternative ?

Hi @AhmedKutraphali Did u tried to copy the sheet using Balareva activitiy?

Copy sheet error UIPath

Help Activities

ecaballes (Ecaballes) February 24, 2021, 3:12am 9

i see,
This is Excel Bug,

for workaround

Topic		Replies	Views
Error : Copy Sheet: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel._Workbook' Activities excel , activities , error	3	1369	May 11, 2021
Copy Sheet activity throwing exception Help	14	10179	May 5, 2020
Exception: 0x8001010E when copy paste sheet in excel Help activities , studio	5	4495	April 1, 2019
Copy Sheet Error Help excel , question	5	2910	June 11, 2020
Copy sheet - RemoteException wrapping System.InvalidCastException: Unable to cast COM object of typ Activities excel , selector , uiautomation , activities , data_scraping , string , question	3	1180	October 25, 2022

Copy sheet error UIPath

Related topics