ElectroNeek - Studio Pro V1.0 Cheat Sheet by electroneek

Implements a typical condit­ional statement. It allows you to follow your workflow through executing one of the two branches depending on the expression value (true or false). If the value is true, then it will execute the 'Yes' branch, otherwise the 'No' branch will be executed.

Implements a loop that is executed when a specified condition is met. By default, the 'Assign value to variable' activity is added when using the 'Do-while loop' activity. It enables you to quickly set the behavior of the loop body; for instance, by modifying a counter variable. However, the 'Assign value to variable' activity is not mandatory to use and can be replaced by any other set of other activi­ties. If the condition in the 'Do-while loop' activity is true then the 'Yes' branch is executed, otherwise the robot will execute the 'No' branch.

Enables you to assign a desired value to a variable.

Waits a specified amount of time before executing the next step in the workflow.

Invokes a subpro­gram: a separate file with a workflow constr­ucted in the 'Studio Pro'. The 'Error' branch is implem­ented to add some additional logic if an exception has occurred inside the subpro­gram.

Outputs the given inform­ation to a text file.

Prints a value to the 'Studio Pro' console.

Opens a specified applic­ation

An activity with a changeable text for descri­ptive purposes only.

Opens an input dialog to allow the user input a text. The 'Save value to variable' activity.

Prompts a pop-up window with a specified text. The window closes either after pressing the button

Selects file or folder through the Windows explorer

This function returns the password as a result. For computer and account security, all passwords should be stored only on your computer.

Returns the login corres­ponding to the selected credential from the “Crede­ntials” tab in the settings.

Appends text to a specified file.

Reads the content of a text file. The 'Save value to variable' activity appears automa­tically when choosing the 'Read file text' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Copies a content of one file to another or downloads a file from the specified URL. Both HTTP and FTP protocols are supported. If you copy to a file that doesn't exist, then the robot will create a new file automa­tic­ally.

Creates a new file in the specified destin­ation. The content of the new file can also be set.

Deletes the specified file of any desired extension.

Checks if a specific file exists in the specified directory. If the file exists, then the 'Yes' branch is executed, otherwise the 'No' branch will be executed.

Extracts inform­ation about a specified file. The 'Save value to variable' activity appears automa­tically when choosing the 'File inform­ation' activity. It automa­tically saves the value to a variable. The activity is not mandatory to use and can be removed from the workflow.

Moves a file to a specified destin­ation.

Overwrites a text file by deleting the old content and replacing it with new content.

Extract all files' names in a directory and stores them in an array. The 'Save value to variable' activity appears automa­tically when choosing the 'List directory files' activity. It automa­tically saves the value to a variable. However, he activity is not mandatory to use and can be removed from the workflow.

Creates a folder by the specified path and name.

Compresses specified files into a zip archive.

Extracts files from a zip-ar­chive and places them to a specified folder.

Waits for a specific event with files in a folder

Reads emails from a Microsoft account.

Sends an email using a Microsoft account.

Reads email messages from a specified Outlook account.

Sends an email message from a specified Outlook account.

Implements the command prompt functi­ona­lity.

Checks if the specified process is running. If at least one instance of the process is running the bot will execute the 'Yes' branch, otherwise the 'No' branch will be executed.

Stops the specified process. If more than one instance of the process is running, all of them will be stopped

Logs the current user out, restarts, hibernates or shuts the computer down.

Reads the clipboard content and saves it to a single file or multiple files (depending on the content of the clipbo­ard). The files are automa­tically placed to the 'C:\Us­ers­\<U­ser­nam­e>­\Ele­ctr­oNeek' folder.

Clears the clipboard content.

Copies the given variable’s value to the clipboard as a text.

Opens the browser and automa­tically navigates to the specified URL. To open the browser with the user settings, click the 'Elect­roNeek Bot Runner' icon in the tray, select 'Setti­ngs', then click 'Browser' and select the 'Load user profile with cookies, extensions etc.' option.

Closes the browser opened via the 'Studio Pro'.

In the browser opened via the 'Studio Pro', searches for an iframe by the specified selector and saves the found result with a specific number. To interact with elements inside the iframe in the other activities from the 'Browser' section, the tab and iframe number must be specified.

Executes JavaScript code on the opened page

Allows you to set relations between elements with data you want to extract and performs scraping.

Simulates a user input from the keyboard in the browser opened via the 'Elect­roNeek Studio Pro'.

Emulates sending keyboard shortcuts to a specific interface element.

Reads messages from an email starting from a specified date. The 'Save value to variable' activity appears automa­tically when choosing the 'Read emails' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Sends a message via an email.

Waits for a specific email.

Applies a set of actions to each email for the selected account

Finds and clicks on the image on the screen.

Finds the image on the screen and returns an array of coordi­nates of the found matches (top left corner).

Takes a screenshot of the entire screen or active window and saves it to file.

Waits a specified amount of time (seconds) for the provided image to appear on the screen. If the image appeared then it will execute the 'Yes' branch, otherwise the 'No' branch will be executed. The activity reacts the same way in case multiple images are found.

Maximizes the specified element if possible

Minimizes the specified interface element if possible

Brings the specified element to the foreground

Closes a window by its selector or its child element

Extracts the value of the specified attribute in a selector. The 'Save value to variable' activity appears automa­tically when choosing the 'Get element property' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Extracts the 'Value' attribute from a selector. The 'Save value to variable' activity appears automa­tically when choosing the 'Get element value' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Gets an element coordi­nates and size using the element's selector. The 'Save value to variable' activity appears automa­tically when choosing the 'Get position' activity. It automa­tically saves the value to a variable. The activity is not mandatory to use and can be removed from the workflow.

Changes the 'value' attribute of a selector

Checks whether the indicated element exists on the screen. The element is identified through its selector. The 'Yes' branch is executed if the element exists, and the 'No' branch if it does not.

Waits a specified amount of time for the selected element to appear. The element is identified through its selector. If the element appeared then it will execute the 'Yes' branch, otherwise the 'No' branch will be executed.

Waits a specified amount of time for the selected element to vanish. If the element vanished then the bot will execute the 'Yes' branch, otherwise the 'No' branch will be executed. If the element was not found at start of the activity then then an exception will be thrown.

Enters a text to a focused or an indicated through selector element. The text may contain special keys. To enter special keys from the keyboard, such as ~,%, ^, &, (,), +, you need to put these characters in curly braces, for example, {%}.

Emulates sending keyboard shortcuts to a specific interface element.

Reads the content of a Word file. The 'Save value to variable' activity appears automa­tically when choosing the 'Read Word file' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Overwrites the content of a Word document. If the document doesn't exist, then the robot will create a new file automa­tic­ally.

Appends data to a Word document. If the document doesn't exist, then the robot will create a new file automa­tic­ally.

Replaces words in double braces in a word file with the desired values

Reads the content of an Excel file. The 'Save value to variable' activity appears automa­tically when choosing the 'Read Excel file' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Writes data to an Excel file.

Adds a row to the end of an Excel sheet.

Inserts or deletes a row on specified address

Gets the value of the range from Excel file

Writes specified values to a specified range in Excel file

Gets the value the row from Excel file

Updates the value the row from Excel file

Reads the value of a specified cell in an Excel document

Updates the content of a specified value in an Excel document

Executes a .vbs macro in the specified Excel file. Make sure to enable the "­trust access to the VBA project object model" option before using the activity.

Inserts empty column or deletes a column on specified address

Gets the value of a column from Excel file

Add the column to the end of Excel file

Updates the column of Excel file

Sorts range in Excel file by columns

Clicks on the specified interface element. The element is identified by its selector, which is generated automa­tically when hovering over the element.

Clicks on the screen­-point located at the given coordi­nates. The reference point of the coordi­nates is located at the top-left corner, so the horizontal axis is directed from left to right while the vertical axis is from top to bottom.

Get the value of checkbox state

Set the checkbox state

Selects an item from a drop-down list

Blocks user mouse and keyboard input commands so that the bot can perform its actions without

Unblocks the user input when it was blocked by the 'Block input' activity.

Reads an attribute of the specified element in the browser opened via the 'Studio Pro'.

Modifies a specified attribute in a given web-page element

Reads the 'value' attribute or the text between tags of the specified element in the browser opened via the 'Studio Pro'.

Sets the 'value' attribute of the specified element in the browser opened via the 'Studio Pro'.

Checks whether the specified element in the browser opened via the 'Studio Pro' exists. The 'Yes' branch is executed if the element exists, otherwise the robot will follow the 'No' branch.

Waits a specified amount of time for the specified element to appear in the browser opened via the 'Studio Pro'. If the element appeared then it will execute the 'Yes' branch, otherwise the 'No' branch will be executed.

Waits a specified amount of time for the specified element to vanish in the browser opened via 'Studio Pro'. If the element vanished then the bot will execute the 'Yes' branch, otherwise the 'No' branch will be executed. If the element was not found at start of the activity then then an exception will be thrown.

Recognizes an image text using the Microsoft OCR techno­logy. Available formats for recogn­ition: JPEG, GIF, PNG and BMP

Recognizes an image text using the Google OCR techno­logy. Available formats for recogn­ition: JPEG, PNG, BMP, GIF and SVG.

Recognizes an image text using the ABBYY Cloud OCR techno­logy. Either images or pdf files can be processed.

This activity enables you to specify a document which will be used as the recogn­ition template. The document will be displayed as an image where, with a graphical tool, уou will be able to select areas, where the text should be recognized from, and specify the corres­ponding variables which will store the recogn­ition results. Works with recogn­ition result from Yandex and Microsoft recogn­ition activi­ties.

Extracts the text layer from a pdf file and saves it as a string

Converts a pdf file to an image or to a set of images in case of multiple pages in the pdf file

Extract selected pages from the PDF file to a new PDF file.

Gets number of pages in PDF file.

Combines files from folder to a single multip­le-page PDF file. Supported file formats: pdf, docx, xlsx, rtf, tiff, bmp, jpeg, jpg, gif, png, html, xps, html

Establ­ishes a connection to the database.

Executes a database query.

Reads a content of a Google Sheets table in the specified range. To make the activity work, you need to provide the platform access to the Google services (right click on the 'Elect­roNeek Bot Runner' in the bottom right tray - ''Sett­ings' - 'Google' - Authen­ticate Google servic­es').

Changes a content of cells within the specified range. To make the activity work, you need to provide the platform access to the Google services (right click on the 'Elect­roNeek Bot Runner' in the bottom right tray - ''Sett­ings' - 'Google' - Authen­ticate Google servic­es').

Adds values to the first completely empty line in a table. To make the activity work, you need to provide the platform access to the Google services (right­-click on the 'Elect­roNeek Bot Runner' in the bottom right tray - ''Sett­ings' - 'Google' - Authen­ticate Google servic­es').

Returns the current date and time

Performs an action with the specified input date (adding or subtra­cting a time unit) and returns a new date.

Calculates the time difference between two dates.

Converts an input variable with a date to a string of a specific format.

Waits for a specific time.

Sends an HTTP request with the specified parame­ters. The 'Save value to variable' activity appears automa­tically when choosing the 'HTTP request' activity. It automa­tically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Performs an OAuth 2.0 author­iza­tion. Returns access token to use in other activi­ties.

Enables you to write and execute a JavaScript code. All variables created in this activity will remain local. Global variables can be used and modified inside this activity.

Executes a Python script with parame­ters. Set path to venv folder to activate a virtual enviro­nment.

Checks if a specified portion of text exists in another text.

Extracts the portion of text between two words in a given text.

Reads a table from Excel, Google Sheets, or CSV file

Runs a loop through a specified table's rows and performs activities the user placed inside the loop. To address the table's columns on each iteration, variables are automa­tically generated on the basis of a table's header specified as the template

Removes all empty rows in a table

Saves a table to an Excel file, a CSV file, or a Google Sheets document

Downloads a file from the Google Drive and saves it to a specified folder.

Uploads a file to Google Drive and saves it to a specified folder.

Create a Google Drive folder in the specified parent folder.

Finds and clicks on the image on the screen

Finds the image on the screen and returns an array of coordi­nates of the found matches (top left corner)

Takes a screenshot of the entire screen or active window and saves it to file

Waits a specified amount of time (seconds) for the provided image to appear on the screen. If the image appeared, it will execute the 'Yes' branch; otherwise, the 'No' branch will be executed. The activity reacts the same way in case multiple images are found.

Sends text to a specified terminal area

Reads the content of a specified terminal area

Waits for a text in a specified terminal area

Recognizes an image text using the Klippa technology and user-p­rovided creden­tials

Recognizes an image text using the Nanonets technology and user-p­rovided creden­tials

Recognizes an image text using the Microsoft Form Recognizer technology and user-p­rovided creden­tials

Recognizes an image text using the Amazon­Tex­tract technology and user-p­rovided creden­tials

Recognizes an image text using the Captur­eFast technology and user-p­rovided creden­tials

Clicks the specified element in the browser opened via the 'Studio Pro'.

Hovers the mouse cursor over the specified element in the browser opened via the 'Studio Pro'.

Moves an element on a webpage to another element.

Extracts available options for the specified dropdown list and selects a value chosen by the user.