Invoke code activity creates an issue

RPA Discussions
1

Hi All,

I am trying to close Active excel file using invoke code activity but getting below error.

Method not found: ‘Microsoft.CodeAnalysis.SyntaxTree Microsoft.CodeAnalysis.VisualBasic.VisualBasicSyntaxTree.ParseText(System.String, Microsoft.CodeAnalysis.VisualBasic.VisualBasicParseOptions, System.String, System.Text.Encoding, System.Collections.Immutable.ImmutableDictionary`2<System.String,Microsoft.CodeAnalysis.ReportDiagnostic>, System.Threading.CancellationToken)’.

2

Hi @rushabhshah1411

Have you inported Microsoft.Office.Interop.Excel
Namespace in import panel

3

Yes, I did tried that as well.

4

can you share your code

5

Hello Robinnavinraj,

I cannot share the code because it is on client machine and it restricts any sharing of code or document outside the environment.

Can we have another solution for this?

6

method not found issue occurs when you haven’t installed namespaces
find the method which is throwing error and install the correlated namespace

7

What Invoke code piece of code does is, it has 2 lines of code which basically checks for rows with space and trims them… using datatable concept.

Namespace is imported for the whole solution.

Dependencies added are:
UiPath.Excel.Activities = 2.11.4
UiPath.Mail.Activities = 1.12.3
UiPath.System.Activities = 21.10.3
UiPath.UIAutomation.Activities = 21.10.4

8

Hi @rushabhshah1411

no you have to import namespace in import panel
look at the below image for more reference

image
image873×249 10.5 KB

Thanks
Robin

9

Yes, I have the exact same thing at my end. I did imported it long time back when I faced the same issue. Now this issue has arise again.