# How to build

**URL:** https://forum.electroneek.com/c/rpa-automation/how-to-build/74.md

[Latest](https://forum.electroneek.com/latest.md) · [Categories](https://forum.electroneek.com/categories.md) · [Tags](https://forum.electroneek.com/tags.md)

---

## [About the How to build category](https://forum.electroneek.com/t/about-the-how-to-build-category/704)

<div class="topic-metadata">

**Author:** [@d.motta](https://forum.electroneek.com/u/d.motta)\
**Replies:** 0

</div>

---

## [How to start a new row in excel sheet](https://forum.electroneek.com/t/how-to-start-a-new-row-in-excel-sheet/5006)

<div class="topic-metadata">

**Author:** [@mohammadAllan](https://forum.electroneek.com/u/mohammadAllan)\
**Replies:** 1\
**Last updated:** [August 19, 2024, 5:53pm UTC](https://forum.electroneek.com/t/how-to-start-a-new-row-in-excel-sheet/5006 "2024-08-19T17:53:08Z")

</div>

hey everyone, I’m new to RPA so please educate me. so I need to extract a web table that contains varying data to an excel sheet and I’m facing a problem that it overwrites all data in the same cell when it’s extracted s…

---

## [How does the "Command Prompt" activity ecosystem work in ElectroNeek?](https://forum.electroneek.com/t/how-does-the-command-prompt-activity-ecosystem-work-in-electroneek/3880)

<div class="topic-metadata">

**Author:** [@ElectroDev](https://forum.electroneek.com/u/ElectroDev)\
**Replies:** 1\
**Last updated:** [July 2, 2024, 12:53pm UTC](https://forum.electroneek.com/t/how-does-the-command-prompt-activity-ecosystem-work-in-electroneek/3880 "2024-07-02T12:53:09Z")

</div>

I’m running PowerShell scripts within the “Command Prompt” activity, but sometimes it takes a long time to load or doesn’t load at all. One key aspect causing the delay is when I add a library through the script—sometime…

---

## [Creating AI Agents in Electroneek](https://forum.electroneek.com/t/creating-ai-agents-in-electroneek/3832)

<div class="topic-metadata">

**Author:** [@Jack](https://forum.electroneek.com/u/Jack)\
**Replies:** 1\
**Last updated:** [June 11, 2024, 6:36pm UTC](https://forum.electroneek.com/t/creating-ai-agents-in-electroneek/3832 "2024-06-11T18:36:35Z")

</div>

Hi there. I am attempting to create AI agents with Electroneek. I see that from your documentation regarding the Process Hub, AI agents are indeed part of the platform: “This state-of-the-art platform enables organizati…

---

## [Using Login Cookies](https://forum.electroneek.com/t/using-login-cookies/3796)

<div class="topic-metadata">

**Author:** [@Jayjay](https://forum.electroneek.com/u/Jayjay)\
**Replies:** 2\
**Last updated:** [May 25, 2024, 12:33am UTC](https://forum.electroneek.com/t/using-login-cookies/3796 "2024-05-25T00:33:20Z")

</div>

I have used a couple of RPA tools in the past and most allow me to use my login cookies to log into my SAAS tool and perform a task. Does Electroneek have the ability to perform this such function?

---

## [Update Excel Cell using header](https://forum.electroneek.com/t/update-excel-cell-using-header/3751)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 1\
**Last updated:** [May 2, 2024, 4:27pm UTC](https://forum.electroneek.com/t/update-excel-cell-using-header/3751 "2024-05-02T16:27:25Z")

</div>

Hello. How can I set the column in the Update excel cell activity using the header? As far as I know, I can only specify letters for the columns. Is there a way to use the header?

---

## [The 'Wait for element' activity takes a lot of time to find a specific element in a Windows program](https://forum.electroneek.com/t/the-wait-for-element-activity-takes-a-lot-of-time-to-find-a-specific-element-in-a-windows-program/3756)

<div class="topic-metadata">

**Author:** [@ElectroDev](https://forum.electroneek.com/u/ElectroDev)\
**Replies:** 1\
**Last updated:** [May 2, 2024, 11:58am UTC](https://forum.electroneek.com/t/the-wait-for-element-activity-takes-a-lot-of-time-to-find-a-specific-element-in-a-windows-program/3756 "2024-05-02T11:58:54Z")

</div>

I have a problem where a specific element is already loaded, and the ‘Wait for element’ activity takes 20 seconds to find it. I use this activity 5 times in my workflow, which adds a waiting time of 100 seconds, more tha…

---

## [Is there a way to pick elements in a website like this?](https://forum.electroneek.com/t/is-there-a-way-to-pick-elements-in-a-website-like-this/3713)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 1\
**Last updated:** [March 5, 2024, 7:50am UTC](https://forum.electroneek.com/t/is-there-a-way-to-pick-elements-in-a-website-like-this/3713 "2024-03-05T07:50:48Z")

</div>

I’ve never seen this before. It’s a Service Now website that has something called macroponent and another thing called #shadow-root, and everything is inside of the macroponent. The bot simply cannot identify any of the …

---

## [Python in Automation processes](https://forum.electroneek.com/t/python-in-automation-processes/999)

<div class="topic-metadata">

**Author:** [@d.motta](https://forum.electroneek.com/u/d.motta)\
**Replies:** 0\
**Last updated:** [June 10, 2022, 3:33pm UTC](https://forum.electroneek.com/t/python-in-automation-processes/999 "2022-06-10T15:33:20Z")

</div>

Today, the versatility of the language allows us to use Python in a variety of environments, such as mobile applications or web development, hardware programming, artificial intelligence, ML and more. In addition, the Py…

---

## [How resilient should a bot be?](https://forum.electroneek.com/t/how-resilient-should-a-bot-be/3590)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 1\
**Last updated:** [January 12, 2024, 10:02am UTC](https://forum.electroneek.com/t/how-resilient-should-a-bot-be/3590 "2024-01-12T10:02:33Z")

</div>

I usually make my bots either restart execution or stop it altogether when they throw an error. The first option makes the bot resilient, but it repeats tasks from the start which may be unecessary and time-consuming. Th…

---

## [Can we integrate Electoneek with SAP](https://forum.electroneek.com/t/can-we-integrate-electoneek-with-sap/3603)

<div class="topic-metadata">

**Author:** [@HuseinVohra](https://forum.electroneek.com/u/HuseinVohra)\
**Replies:** 2\
**Last updated:** [November 22, 2023, 7:52am UTC](https://forum.electroneek.com/t/can-we-integrate-electoneek-with-sap/3603 "2023-11-22T07:52:38Z")

</div>

Hi, One of our prospect wants to know if output of Electroneek bot can be directly fed into SAP. If yes, can we get some sample around integration? Regards, Husein

---

## [Database SQL](https://forum.electroneek.com/t/database-sql/1377)

<div class="topic-metadata">

**Author:** [@d.motta](https://forum.electroneek.com/u/d.motta)\
**Replies:** 2\
**Last updated:** [October 25, 2023, 8:52am UTC](https://forum.electroneek.com/t/database-sql/1377 "2023-10-25T08:52:59Z")

</div>

We currently support the following database management systems: MySQL, MSSQL, PostgreSQL, and Oracle. Please take note that only 64-bit versions are supported; 32-bit versions could be unstable. How to connect to a Dat…

---

## [Email Automation](https://forum.electroneek.com/t/email-automation/1102)

<div class="topic-metadata">

**Author:** [@d.motta](https://forum.electroneek.com/u/d.motta)\
**Replies:** 4\
**Last updated:** [December 23, 2022, 11:09am UTC](https://forum.electroneek.com/t/email-automation/1102 "2022-12-23T11:09:35Z")

</div>

ElectroNeek provides ready-to-use integrated Email activities for Automation such as Microsoft Outlook, Microsoft 365, Google, Yahoo, iCloud, Yandex and others. This means users can easily choose default settings for any…

---

## [Excel Macros with ElectroNeek](https://forum.electroneek.com/t/excel-macros-with-electroneek/1258)

<div class="topic-metadata">

**Author:** [@d.motta](https://forum.electroneek.com/u/d.motta)\
**Replies:** 3\
**Last updated:** [July 8, 2023, 10:47pm UTC](https://forum.electroneek.com/t/excel-macros-with-electroneek/1258 "2023-07-08T22:47:28Z")

</div>

A macro must be written in a .vbs file with all corresponding macro creation rules. The ‘Execute macro’ activity can then be used to run the macro. The main difficulty for users when working with macros is that variable…

---

## [How can I use \[\*\] in XPath along with a variable?](https://forum.electroneek.com/t/how-can-i-use-in-xpath-along-with-a-variable/3340)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 5\
**Last updated:** [May 19, 2023, 1:30pm UTC](https://forum.electroneek.com/t/how-can-i-use-in-xpath-along-with-a-variable/3340 "2023-05-19T13:30:41Z")

</div>

I have a web page and with nested items. I’m using scrape structured data to get the data and then I loop through it and check for a condition with and If activity. If the condition is true, the bot expands that item, sc…

---

## [Convert PDF to XML via command prompt](https://forum.electroneek.com/t/convert-pdf-to-xml-via-command-prompt/3327)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 3\
**Last updated:** [May 4, 2023, 6:12pm UTC](https://forum.electroneek.com/t/convert-pdf-to-xml-via-command-prompt/3327 "2023-05-04T18:12:08Z")

</div>

Hello. I need to covert a PDF file into an XML file using Studio Pro. I know there isn’t an activity for that, so I though maybe I could do it using the command prompt. I have researched onilne, but all I’ve found so fa…

---

## [Insertar parrafos dinamicamente](https://forum.electroneek.com/t/insertar-parrafos-dinamicamente/3281)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 1\
**Last updated:** [April 5, 2023, 5:32pm UTC](https://forum.electroneek.com/t/insertar-parrafos-dinamicamente/3281 "2023-04-05T17:32:45Z")

</div>

¿Cuál sería el procedimiento correcto para que el bot me traiga como resultado estos párrafos cuando termine el bucle? Porque solamente me esta trayendo el último resultado y quiero que se acumule. El resultado real …

---

## [Vaciar todo el contenido de una hoja de Excel](https://forum.electroneek.com/t/vaciar-todo-el-contenido-de-una-hoja-de-excel/3271)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 2\
**Last updated:** [April 4, 2023, 2:55pm UTC](https://forum.electroneek.com/t/vaciar-todo-el-contenido-de-una-hoja-de-excel/3271 "2023-04-04T14:55:08Z")

</div>

Como el bot puede vaciar todo el contenido de una tabla Excel?

---

## [How to create an html table using the datatable and send it on email](https://forum.electroneek.com/t/how-to-create-an-html-table-using-the-datatable-and-send-it-on-email/3207)

<div class="topic-metadata">

**Author:** [@AnkitDwivedi](https://forum.electroneek.com/u/AnkitDwivedi)\
**Replies:** 2\
**Last updated:** [March 16, 2023, 2:08pm UTC](https://forum.electroneek.com/t/how-to-create-an-html-table-using-the-datatable-and-send-it-on-email/3207 "2023-03-16T14:08:51Z")

</div>

We are getting the data from database and want to send that data on mail in table format, but when I am sending it it’s coming as string and loosing the table format. How to create an html table using the data table and…

---

## [How can I make the robot get out of a For Each Row loop without breaking?](https://forum.electroneek.com/t/how-can-i-make-the-robot-get-out-of-a-for-each-row-loop-without-breaking/3183)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 2\
**Last updated:** [March 14, 2023, 10:54pm UTC](https://forum.electroneek.com/t/how-can-i-make-the-robot-get-out-of-a-for-each-row-loop-without-breaking/3183 "2023-03-14T22:54:59Z")

</div>

I have an excel file with multiple rows with information I need to use in the workflow. I’m using a For Each Row activity to gather the information and call several subprograms insdide the loop. Thing is, when an error h…

---

## [How can I pick an element from a specific tab?](https://forum.electroneek.com/t/how-can-i-pick-an-element-from-a-specific-tab/3157)

<div class="topic-metadata">

**Author:** [@cris-dsc](https://forum.electroneek.com/u/cris-dsc)\
**Replies:** 3\
**Last updated:** [March 14, 2023, 1:26pm UTC](https://forum.electroneek.com/t/how-can-i-pick-an-element-from-a-specific-tab/3157 "2023-03-14T13:26:13Z")

</div>

I want to pick an element from a specific tab in the browser. I know I can select the tab using its number, but I’d like to know if there is a way to do so using the tab name instead because the number might change depen…

---

## [Is there a way to automate a z/OS terminal application](https://forum.electroneek.com/t/is-there-a-way-to-automate-a-z-os-terminal-application/2396)

<div class="topic-metadata">

**Author:** [@Guillo](https://forum.electroneek.com/u/Guillo)\
**Replies:** 3\
**Last updated:** [February 27, 2023, 6:14pm UTC](https://forum.electroneek.com/t/is-there-a-way-to-automate-a-z-os-terminal-application/2396 "2023-02-27T18:14:35Z")

</div>

Got a new client who has several apps in a mainframe. Want to automate the workflows and those are built on an IBM z/OS system. Need to automate terminal 3270 emulator. Thanks in advance!

---

## [How to reduce multiple OR conditions in IF statement](https://forum.electroneek.com/t/how-to-reduce-multiple-or-conditions-in-if-statement/2353)

<div class="topic-metadata">

**Author:** [@Yoshi](https://forum.electroneek.com/u/Yoshi)\
**Replies:** 8\
**Last updated:** [February 27, 2023, 7:41am UTC](https://forum.electroneek.com/t/how-to-reduce-multiple-or-conditions-in-if-statement/2353 "2023-02-27T07:41:46Z")

</div>

I currently have a validation using an IF statement where it conditions workflow direction if the variable “hospital\_name” is equal to ‘Hospital Zambrano’. Now I need to add at least 10 more hospital names to that condit…

---

## [Create an array from excel range](https://forum.electroneek.com/t/create-an-array-from-excel-range/2372)

<div class="topic-metadata">

**Author:** [@Yoshi](https://forum.electroneek.com/u/Yoshi)\
**Replies:** 1\
**Last updated:** [February 22, 2023, 6:48am UTC](https://forum.electroneek.com/t/create-an-array-from-excel-range/2372 "2023-02-22T06:48:50Z")

</div>

Hi everybody I have an excel sheet from which I need to create several arrays using different ranges It is possible to create a variable whose value is an array extracted from a range in excel using the “calculate valu…

---

## [Read multiple text documents in PDF](https://forum.electroneek.com/t/read-multiple-text-documents-in-pdf/2326)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 6\
**Last updated:** [February 16, 2023, 4:43pm UTC](https://forum.electroneek.com/t/read-multiple-text-documents-in-pdf/2326 "2023-02-16T16:43:26Z")

</div>

I’m making a bot that reads multiple PDF files. How to use the loop to get these results? Thank you!!

---

## [Rename files in case the path contains spaces](https://forum.electroneek.com/t/rename-files-in-case-the-path-contains-spaces/2288)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 2\
**Last updated:** [February 9, 2023, 4:57pm UTC](https://forum.electroneek.com/t/rename-files-in-case-the-path-contains-spaces/2288 "2023-02-09T16:57:01Z")

</div>

I get an error when changing the name of a document, perhaps because a folder has space. What would be done in that case? Thank you!! “rename C:\\Users\\admin\\Documents\\bots\\Rename File\\RenameFile\\oldfile.pdf newfile.pdf…

---

## [Read file found?](https://forum.electroneek.com/t/read-file-found/2232)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 1\
**Last updated:** [February 6, 2023, 6:36am UTC](https://forum.electroneek.com/t/read-file-found/2232 "2023-02-06T06:36:57Z")

</div>

How to use the file found? function in electroneek. And once the file is found, it will be read the file automatically? Thank you!!

---

## [How to read Excel rows in a loop](https://forum.electroneek.com/t/how-to-read-excel-rows-in-a-loop/2225)

<div class="topic-metadata">

**Author:** [@Mabwa\_Neek](https://forum.electroneek.com/u/Mabwa_Neek)\
**Replies:** 0\
**Last updated:** [February 2, 2023, 6:00pm UTC](https://forum.electroneek.com/t/how-to-read-excel-rows-in-a-loop/2225 "2023-02-02T18:00:44Z")

</div>

To process an Excel file, it is expected that we need to read the row values from a particular column one by one on a loop. For example, imagine you have a column consisting of keywords that you want to input in the brow…

---

## [Using File Information](https://forum.electroneek.com/t/using-file-information/2147)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 6\
**Last updated:** [January 30, 2023, 11:30pm UTC](https://forum.electroneek.com/t/using-file-information/2147 "2023-01-30T23:30:15Z")

</div>

Once the bot has executed the File Information, how can you extract specific information like the name and length of the file? Thanks!

---

## [How to insert an image into the mail body?](https://forum.electroneek.com/t/how-to-insert-an-image-into-the-mail-body/1354)

<div class="topic-metadata">

**Author:** [@Jose\_Miguel\_Almonte](https://forum.electroneek.com/u/Jose_Miguel_Almonte)\
**Replies:** 4\
**Last updated:** [January 30, 2023, 6:58pm UTC](https://forum.electroneek.com/t/how-to-insert-an-image-into-the-mail-body/1354 "2023-01-30T18:58:26Z")

</div>

In JavaScript or HTML format.

[Next page](https://forum.electroneek.com/c/rpa-automation/how-to-build/74.md?page=1)
