Overview

How-to Articles are easy-to-learn guides that provide step-by-step instructions on performing specific tasks or solving specific problems using ElectroNeek products.

Check the articles below organized by categories.

Excel

How to manipulate and format data in Excel, including reading, modifying, merging, and removing rows, and using conditional formatting and Macros.

Modifying Cell Format	Reading rows in a loop	Removing Blank Rows
Merging Table Data	Using conditional formatting with Macros	Managing Large Files

Arrays

How to work with this data structure, including calculating its length, getting an element's index, converting strings to JSON, and more.

Calculating the length	Getting the index of an element	Converting a string to JSON
Deleting values from arrays	Creating arrays with values

Programming

How to use programming and scripts in Studio Pro, including writing query text using an activity and running a NEEX file from the command prompt.

Writing a query	Running NEEX file from the Command Prompt

Text

How to manipulate information from text-based documents using Studio Pro, including removing special characters, selecting list items, and extracting data.

Removing Special Characters	Selecting a list item using a variable
Extracting Data from Documents

Strings

Specifying a directory in the "Calculate a Value" field	Using Multiple Hotkeys	Inserting Line Breaks
Adding Punctuation to Numbers	Using special characters in texts	Using Regex in Strings

Bots Management

How to improve your bot management, including creating and running NEEX files, duplicating workflows, and more.

Creating and running a NEEX file	Publishing duplicated workflows to SaaS Orchestrator
Managing Multiple Bot Runners	Running Scripts as Admin

Email

How to perform email-related tasks, such as attaching dynamic images, extracting tables, embedding images, and more.

Using HTML	Attaching Dynamic Images	Using multi-factor authentication in Microsoft emails
Attaching Several Documents	Saving a table to an Excel file	Embedding Images

Files

How to deal with file management, including moving files to a network folder, uploading files via FTP/HTTP, and managing file paths.

Moving files to a network folder	Uploading Files via FTP/HTTP
Managing Files Paths

Web Data

How to use Studio Pro to extract and interact with various types of data from web pages, such as images, elements, and values from address bars.

Getting images from a table	Clicking on an image using a screenshot	Closing a Browser Tab
Recognizing Web Elements	Going back to previous page	Getting the value from the address bar
Looping through similar elements on a page	Extracting data from a page

Miscellaneous

How to perform different types of actions such as hiding the status window, sending mobile messages, triggering bots using files, creating custom logs, and more.

Formatting Dates	Creating Custom Logs	Activating bots when a file appears
Hiding the Status Window	Sending Mobile Messages