Error executing RPA

Help Forum
, ,
1

Hi!,

When I run my RPA, the UiPath compiler gives me the following error:

Unexpected error has occurred during the library compilation process:
The assembly compilation returned the following errors:

  • (1,6664): error CS0234: The type or namespace name ‘Workbook’ does not exist in the namespace ‘Microsoft.Office.Interop.Excel’ (are you missing an assembly reference?)
  • (1,6790): error CS0234: The type or namespace name ‘Workbook’ does not exist in the namespace ‘Microsoft.Office.Interop.Excel’ (are you missing an assembly reference?)
  • warning CS1701: Assuming assembly reference ‘System.Linq.Expressions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ used by ‘System.Activities’ matches identity ‘System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ of ‘System.Linq.Expressions’, you may need to supply runtime policy
  • warning CS1701: Assuming assembly reference ‘System.Linq.Expressions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ used by ‘System.Activities’ matches identity ‘System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ of ‘System.Linq.Expressions’, you may need to supply runtime policy
  • warning CS1701: Assuming assembly reference ‘System.Linq.Expressions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ used by ‘System.Activities’ matches identity ‘System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ of ‘System.Linq.Expressions’, you may need to supply runtime policy
  • warning CS1701: Assuming assembly reference ‘System.Linq.Expressions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ used by ‘System.Activities’ matches identity ‘System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ of ‘System.Linq.Expressions’, you may need to supply runtime policy
  • warning CS1701: Assuming assembly reference ‘System.Linq.Expressions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ used by ‘System.Activities’ matches identity ‘System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ of ‘System.Linq.Expressions’, you may need to supply runtime policy
  • warning CS1701: Assuming assembly reference ‘System.Linq.Expressions, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ used by ‘System.Activities’ matches identity ‘System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ of ‘System.Linq.Expressions’, you may need to supply runtime policy

I have all the dependencies added from the manage packages.

Does anyone have a solution to this problem?

2

@omar.vega,

Is Excel installed on your machine? As per error message, something wrong with the Excel activity you are using.

3

Hi @ashokkarale,

If I have Excel installed on my machine, I’ll share an image with you.

I’ll also share with you the image of my UiPath and the version.

image
image1919×1038 132 KB

4

Try importing below mentioned assemblies from Imports Panel

System.Linq
System.Linq.Expressions
Microsoft.Office.Interop.Excel

5

Go to manage packages and see if UiPath.Excel.Activities is installed or not. If installed - Downgrade / Upgrade the current version and see if the error is still coming

6

@omar.vega

Looks like a dependency issue

Is it a new process or a process which is converted from legacy?

As a first go try to go to c:\users\username\.nuget and delete the folder .nuget and then reopen the project and check

Cheers

7

I’ve been doing the activities you recommended, but none of them have worked for me. Any other suggestions or ideas you might have?

I would greatly appreciate it.