Copy sheet error UIPath

Help Activities
, ,
1

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 component for the interface with IID '{000208DA-0000-0000-C000-000000000046}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).

image

2

https://imgur.com/a/fQDHiFd

3

Hope it helps

1 Like
4

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

5

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

6

I am using excel 2016 bro

7

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

9

i see,
This is Excel Bug,

for workaround

1 Like
10

do you have any idea or alternative ?

11

@NIVED_NAMBIAR

12

Hi @AhmedKutraphali

Did u tried to copy the sheet using Balareva activitiy?

13

there is no copy sheet in activity in Balareva . just copy workbook