InvokeCode Example

[abskulkarni (Abhijit)]

Hi
Can you direct me to a video tutorial / code example for InvokeCode activity?

[UiJules]

Hi,
You can find useful information (as a video tutorial/exercise) in UiPath Academy / Foundation training / Lesson 13 - Projext Organisation - Recap

[sfranzen (Steven Franzen)]

Hi,

The official training materials might not be up to date yet as this activity has only just been added to the Community edition. I can give a small example right here though. Just as with “Invoke Workflow”, you can specify arguments that will be accessible inside:

But instead of a workflow filename you enter Visual Basic code you want to execute, directly into an editor window. Suppose I want my code activity to randomly shuffle its string argument. I could program this as follows, which is a version of the Fisher-Yates algorithm:

Shuffling the alphabet:

Might give you ubcaojvhzixtfldywqpnekrsgm, or fawuyorqsxjkpiglbhvednmztc or indeed hnrjkaiysdtblxupfgzcovwqme.

[lasithdilshan20 (Lasitha Wijenayake)]

Hi,
I need to execute following VB script to move mouse cursor.

Private Sub MoveCursor()
   ' Set the Current cursor, move the cursor's Position,
   ' and set its clipping rectangle to the form. 

   Me.Cursor = New Cursor(Cursor.Current.Handle)
   Cursor.Position = New Point(Cursor.Position.X - 50, Cursor.Position.Y - 50)
   Cursor.Clip = New Rectangle(Me.Location, Me.Size)
End Sub

Please some one guide me to execute this code .

[lasithdilshan20 (Lasitha Wijenayake)]

@path @prassin6 @vvaidya

[vvaidya (Vinay Vaidya)]

I think the above code works only for winforms. Try below in code activity

Arguments:
pt - System.Drawing.Point

pt= New Point(Cursor.Position.X - 50, Cursor.Position.Y - 50)
Cursor.Position = pt

For size part, something like this should work

size = New System.Drawing.Size(10, 10)
pt= New System.Drawing.Point(Cursor.Position.X + 50, Cursor.Position.Y + 50)
Cursor.Position = pt
Cursor.Clip = New Rectangle(pt,size)

[lasithdilshan20 (Lasitha Wijenayake)]

@vvaidya
It is not working an error occurred.

 Invoke code : Error compiling code
error BC30451: 'Cursor' is not declared. It may be inaccessible due to its protection level. At line 1
error BC30451: 'Cursor' is not declared. It may be inaccessible due to its protection level. At line 1
error BC30451: 'Cursor' is not declared. It may be inaccessible due to its protection level. At line 2

[lasithdilshan20 (Lasitha Wijenayake)]

Main has thrown an exception

Source: Invoke code

Message: Error compiling code
error BC30451: ‘Cursor’ is not declared. It may be inaccessible due to its protection level. At line 1
error BC30451: ‘Cursor’ is not declared. It may be inaccessible due to its protection level. At line 1
error BC30451: ‘Cursor’ is not declared. It may be inaccessible due to its protection level. At line 2

Exception Type: ArgumentException

System.ArgumentException: Error compiling code
error BC30451: ‘Cursor’ is not declared. It may be inaccessible due to its protection level. At line 1
error BC30451: ‘Cursor’ is not declared. It may be inaccessible due to its protection level. At line 1
error BC30451: ‘Cursor’ is not declared. It may be inaccessible due to its protection level. At line 2

at UiPath.Core.Activities.Workflow.CompilerRunner.Compile(String code, Int32 errLineOffset)
at UiPath.Core.Activities.InvokeCode.GetCompilerRunner(String userCode, List`1 args, String imps)
at UiPath.Core.Activities.InvokeCode.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

[vvaidya (Vinay Vaidya)]

Create Cursor argument of Type System.Windows.Forms.Cursor

[lasithdilshan20 (Lasitha Wijenayake)]

It’s working thanks a lot

[lasithdilshan20 (Lasitha Wijenayake)]

Hi I need to Execute following Code, Please guide me

Dim oWB As Excel.Workbook
        Dim oSheet As Excel.Worksheet
        Dim oRng As Excel.Range

        ' Start Excel and get Application object.
        oXL = CreateObject("Excel.Application")
        oXL.Visible = True

        Sheets(Sheets.Count).Activate

I need to select last sheet of the excel workbook

[sfranzen (Steven Franzen)]

Hi,

I tried this but am unable to get it to work. The error I get are the same as this:

Unable to create Excel Application Instance in Invoke Code activity

Scenario: Won’t able to create Excel Application Object in Invoke code. Though I use Microsoft.Office.Interop.Excel Namespace. Steps to reproduce: Current Behavior: error BC31539: Cannot find the interop type that matches the embedded type ‘Microsoft.Office.Interop.ExceI.AppIication’. Are you missing an assembly reference? At line O Exception Type: Argumentaception System.ArgumentException: Error compiling code error BC31539: Cannot find the interop type that matches the embedded type Ex…

[vvaidya (Vinay Vaidya)]

Please try this

Interop.Excel.Application is not defined

Do you have the below assembly in your xaml, if not add it manually and restart your project and try again. [image]

[1vivek12 (vivek verma)]

Hi why am i getting module member declaration expected?

[1vivek12 (vivek verma)]

Hi ,
I have written this code how can i make it work using invoke code activity please help

Imports System.IO

Module Module1

Private index1 As Integer = New StringHelper().GetIndexofSearchText("C:\Users\vivekver\Documents\UiPath\Nokia Automation\Configuration Manager Nokia 2nd\TEST.txt", "MRBTS-486203")
Private index2 As Integer = New StringHelper().GetIndexofSearchText("C:\Users\vivekver\Documents\UiPath\Nokia Automation\Configuration Manager Nokia 2nd\TEST.txt", "[TopologyNode: PLMN-PLMN/MRBTS-486215]")
Public index_Hotkey As Integer = New NoOfHotkeys().GetHotkey(index1, index2)

Public Class NoOfHotkeys
    Public Function GetHotkey(ByVal index1 As Int32, ByVal index2 As Int32)
        Dim index_Hotkey As Integer = index2 - index1
        Return index_Hotkey

    End Function

End Class
Public Class StringHelper

    Public Function GetIndexofSearchText(ByVal Filename As String, ByVal SearchText As String) As Integer
        Dim index As Integer = 0
        Dim lines As List(Of String) = File.ReadLines(Filename).ToList()
        For Each line In lines
            If line.Contains(SearchText) Then
                Return index
            End If

            index += 1
        Next

        Return index


    End Function
End Class

Sub Main()


End Sub

End Module

i want index_Hotkey as output to my uipath workflow.Please help

[1vivek12 (vivek verma)]

Hi the activity is to read text file line by line until it finds a string and simuntaneously increment a index to know row index of line till it finds the string.Please help

[venkat4u (venkat)]

Hi,

i am new to uipath and i am trying to use the invoke code activity to work on excel for that i have imported Microsoft.office.interop.excell through import tab in uipath studio but still gettting error for Excel.

could you pleae guide me how to use the external dll in invoke code.

[karthik_bethi (karthik)]

Hi,

Please refer the below tutorial.

UiPath Tutorial For Beginner - Invoke Code Activity

Thanks,
Karthik.

[blaze.1411 (Ravivarma Ramadas)]

Does Invoke code reduces the performance of the Robot process compared to Activities ??

I need with a justifying answer. kindly help me out.

[balupad14 (Balamurugan)]

Hi @blaze.1411,

May be. Because we have to see how we are writing the code. And it accepts VB.Net.
The activities has been handled object well. I am not sure that we can able to do all the things in the Invoke code.
I read the invoke code will get slow . I have seen a post the below.

Rename a file name using the Invoke Code activity

So this does exactly what the move file activity does, but uses InvokeCode instead (which is slower by definition) and relies on VB specific namespace instead of system one. What’s the purpose? Don’t get me wrong - its a nice and short example for InvokeCode, but the application of it makes me a little unease, because someone might actually use that in production.

Note
Some situation we can not avoid the Invoke code activity …

Regards
Balamurugan.S