• To download Process Bot DWmaker, first we have to go to the link intelgic.com
  

• Then click on the login button to sign up for your intelgic account.
  

• You can sign up to your intelgic account by using your email id or your Google account.

• If you want to sign up with an email id, click on the Sign up now button. You will go to the bellow page.

• Register your name, mail id and password then click on the “Create your account” button. Don’t forget to check the “I’m not a robot” box.
  

• You will get a mail on your registered email id to verify the email. Click on the “Verify this email” button.
  

• Now you will be logged in to your intelgic account.

• Now click on the pricing under RPA.
  

• Choose the pricing option you like.
  

• You will be redirected towards the intelgic dashboard, where you will see that your plan has been activated.
  

• Now check your mail, you will get a mail on your registered mail id with the details of license key with login id and login Url.

• Now click on the download option under RPA.

• Now you need to click on the DWmaker Download button.

• After successfully downloading the DWmaker check your Downloads folder and double-click “Process Bot Setup” to start the installation process

• It will give you the below dialogue box, click on the “Run anyway” option.
  

• Next your DWmaker installation process will start.
  

• Once the Process Bot DWmaker is installed successfully, click on the “close” button.
  

• Now you will find the DWmaker in your windows menu or in your desktop.or,

• Double click on DWmaker, now it will ask you for your activation code.
  

• You will find both the ACTIVATION CODE in your registered mail id. Copy the License Key and paste it in the ACTIVATION CODE box.

• Now you will receive notification as “your license has been activated successfully” in a pop window.
  

•  The DWmaker will ask you to create a folder to save your script,  click on Yes.
  

• Now your DWmaker is ready to open.This is how your DWmaker dashboard looks like.
  

• To login into Process bot one first you have to check your registered email id. Copy the Login ID. Then go to the Login URL and open the URL
  

• The URL will navigate you to the below page. Paste the copied Login ID and put the password you set for your Intelgic account.
  
  

• After login you will be navigated towards the below page. Click on the Robotic Process Automation (RPA).

• It will navigate you to the below page. Login with your registered Intelgic mail id and password.

• Once you logged in, You will be navigated to the Process Bot One window, which is as shown below. Click on the Machine/Host in the left side corner.
  

• As soon as you click on Machine/Host, we have two options under it.
• Standalone Host: In this environment one system can perform one task at a time. This service is available at Free Edition.
• Server: In this environment, multiple systems can perform multiple tasks at a time. This service is available at Pro and Starter Edition.
  

• The connection procedure for both options is the same.
• Once you click on Standalone Host, the Standalone Host window will appear, which is as shown below.
  

• Click on the Add option. You will get a pop-up window.
  

• Now go to the DWmaker that you have installed previously and click on the options button.
  

• Next, click on Settings Manager under Options.
  
  

• A Settings window will appear, click on the Orchestrator, it will take you to the Orchestrator settings window.
  

• You will find the Host Name and User Name here, copy and paste it in the Machine Name and User Name of the pop-up window of the Standalone Host and click on the Save button.
  

• Once you click on the Save button, your host will be created. Also a key number will be generated.
  

• Click on the key symbol and copy the number. Paste the number in the Host Key of the Orchestrator settings of DWmaker and click on the Connect To Server button. And click on the ok button of the pop-up window.
• 
  

• Once, the Process Bot One is connected with Dwmaker, you can see a green right mark before the Machine Name as shown below.
  

• In the Process Bot DWmaker, we have three buttons, such as Robots, Actions, and Options.
  

• Once you click on the Robot button, you will get the Robot List, Launch Robot, Import Robot, Save And Save As, Publish, Restart Process Bot, And Close Process Bot.
  • Robot List: If you click on the Robot List it will give the list of bots in your DWmaker.
  • Launch Robot: If you click on Launch Robot it will take you to the script files to launch your bots.
  • Import Robot: This option allows you to import the bots from script files to your workbook.
  • Save, Save As: This option allows you to save the automation command for your bots.
  • Publish: This will help to publish your robots.
  • Restart Process Bot, Close Process Bot: It helps to restart and close your process bot DWmaker.

• Next is the Action
• Once you click on the Action button, the DWmaker navigates you to its sub-categories such as Record, Schedule, and Run.
  

• Once you click on the Record button, the Screen Record pop-up window will open, it helps you to record the screen which is as shown below.
  

• Once you click on the schedule button, a schedule pop-up window will open, which helps you with the scheduling of time for triggering the bot.
  

• The Run button helps to run the scheduled robot.

• Now if you click on the Options button, you will get Variable Manager, Settings Manager, GitHubRepo and License.
  Variable Manager is used, if you want to define a variable before you start to write your automation command. You can do it by clicking on User Defined Variable and clicking on the Add option.
  

• There are also System Defined Variables which are predefined variables that already exist in the DWmaker.To see the System Defined Variables we have to click on the Print button under Miscellaneous Operation. A pop-up window will open. Click on the System/User Defined Variable.A list will appear, this is your System Defined Variable.

• Settings Manager is used for your DWmaker settings.

• GitHubRepo is used for tracking all our activity and doing modifications.

• And License button is for giving you information about your DWmaker

You can update the DWmaker every month, to get the updated version of the software.

Now, let us see the step-by-step process of updating DWmaker.

• Open the DWmaker application, click on the Options tab
  
• Next, click on the General tab, in the Settings pop-up window.
• Next, click on Check for updates.
  
  
• If the new version is available, then the DWmaker will show you the new version, click on the Update button as shown below.
  
• Once you click on the update button, the DWmaker will start updating.
  
• Once your DWmkaer is updated, you can see the updated version.

Variables are used to store and manipulate dynamic data, whether it is numeric or alphabetic. In simple terms, a variable is a name given to a storage location where data can be temporarily held for further use.

A variable is associated with a specific type, which determines the size and layout of its memory allocation, the range of values it can store, and the operations that can be performed on it.

The name of a variable can consist of letters, digits, and underscores, forming a valid combination.

A variable is a named storage location used to hold a value. It serves as a means for programmers to store and manipulate data. Variables can store various data types, including numbers, strings, and Boolean values.

The name of a variable can consist of letters, digits, and underscores, allowing for a valid combination.

To represent a specific value using DWmaker, you can utilize its variable command. To do this, you need to navigate to the DWmaker dashboard and select the “Variable” command option by clicking on it. See the image.

How to Create a new variable:

To create a new variable in DWmaker, you need to click on the “New Variable” command within the “Variable” section.

It will open a new property window. In this window, you can assign a variable name by entering it in the “Variable Name” box, and specify the variable value by entering it in the “Set variable with a value” box.

For example: Here, I will take a variable named “X” and assign a value of 25 to it.

After filling the required fields, click on Done. It will automatically generate the code line on the code window.

Print Variable

Now if you want to print X , bot will show you the value of the X that you just assigned.

For that click on the “Print” button under “Miscellaneous operation” button.

On the above screen, there is a property field “Please Enter the message to be displayed” where you need to input the name of the variable that you have created and whose value you want to print, and press “Done”.

Now click on the “Run” button under “Action” button.

It will show you 25.

Here’s another use case for the use of variables:

Here, we will take two variables, X and Y, and assign them values of 25 and 35 respectively. We will then perform the addition operation to calculate the sum of their values. See the image below.

Now, we will create a new variable named “TOTAL” and assign it the value of the sum of X and Y. To achieve this, we need to use square brackets “[ ]” to enclose the variables and use the plus sign “+” to perform the addition.

Now if you want print TOTAL, it will show the value.

Your code window will look like this.

After clicking the “Run” button, which is located under the “Action” section, the result will be displayed.

When the if statement is not true in the program then, it will execute with the else statement and print the result with the value of the else statement.

For this, go to the “Else” statement and press the “Done” button.

Put the else statement code within the end of the statement. As shown in the below image.

Now if the condition is true, the program will be executed with the if statement value. While, if the condition is not matched, then the program will return the value of the “else statement”.

To check the “else statement” in action, print the message with another value, under the else condition.

When the program runs, it will return the value of the else condition. As shown in the below image.

This is how you can easily implement conditional statements in a robotic program with the DWmaker.

What is Loop?

A loop is a set of instructions that is repeatedly executed until a given condition is met in computer programming. Typically, a process is carried out, such as obtaining and altering data, and then a condition is verified, such as whether a counter has reached a certain value. If it hasn’t, the following instruction in the sequence is a command to go back to the first instruction and repeat the process. The next instruction “falls through” to the next sequential instruction or branches outside the loop if the condition is met. A loop is a basic programming concept that is often utilized in program development. A loop is a sequence of statements that executes multiple times until the mentioned condition of a program becomes false.

Types of loops:

Basically, the programming languages have Loops of Various Types:

• A for loop is a loop that repeats itself a specified number of times.
• A while loop is one that repeats itself as long as an expression is true. A statement with a value is called an expression.
• A do-while loop, also known as a repeat till loop, repeats an expression until it turns false.
• A loop that repeats endlessly because it has no ending condition, the exit condition is never satisfied, or the loop is commanded to restart from the beginning is known as an infinite or endless loop.
• Although it is possible for a coder to employ an endless loop on purpose, novice programmers frequently make this error.
• Within any other for, while, or do-while loop, a nested loop occurs.

The DWmaker has the following commands:

• End Loop
• Exit Loop
• Loop Continues
• Loop Data Table
• Loop List
• Loop Number of Times

What is End Loop:

The forms end loop statement ends loops established by the begin/end program blocks associated with numerous forms statements, including unloading table, formdata, and table data.
endloop only terminates the loop in which it is run; no outside loops are ended if loops are nested. Following the ended loop, control is restored to the first statement. As a result, the end loop statement must be syntactically within the loop it is intended to end.
endloop cannot be used to specifically end a display loop. If a display loop is nested within a loop defined by a begin/end block, however, stopping the begin/end block stops the nested display loop.

What is Exit Loop:
If the condition of an iteration statement (for, while, or do-while statement) is removed, the loop will not finish until the user expressly quits it using a break, continue, goto, or another less visible manner, such as a call to exit().

The Dwmaker has an option called ExitLoop command, Whenever you want to exit the loop, you can click on the Exit Loop command under If Statements.

What is Loop Continues:

Inside loops, the continue command is utilized. When a continuous statement appears inside a loop, control goes to the beginning of the loop for the next iteration, bypassing the execution of statements within the loop’s body for the current iteration.

The Dwmaker has Loop Continuous command which can be used to continuos execution.

Click on the Loop Continuous command under Loop Statements

What is Loop Data Table:

The Loop Data Table command is used to loop each iteration of the given data table.

Additionally, to fetch any data from the excel file, using DWmaker, first, we need to access the “Data Table Automation” command, in addition, to creating an “Instance name” See the image.

Once you click on the “Data Table Automation” command, it will open a list of a few more sub-commands, from which you need to select “Assign Data Table Instance”. As shown in the below image.

Now, in the “Assign Data Table Instance” property window, provide a “Data Table Name” and an “Instance Name” and then press the “Done” button. See the below image.

Moving ahead, to read the data from an XML file. First, you need to create a table, where you can store the fetched record of a file.

To create a table, click on the “Excel Automation” command, and then select and click on the “Create Excel Data Table” option.

Now, fill the “Create Excel Data Table” property window with the required details as data table name, the path of the file that you want to read, and the specific sheet name of the respective excel file. See the below image.

Once inserting all the details in the property window, press the “Done” button.

Note: Use the same data table name and the instance name every time in the process.

Now, in the next step, to read the entire data of a table one after one, you need to implement a loop in it. For the successful implementation of a loop first, you need to set a new variable in the program.

To set a variable, go to the “Set Variable” command under the “Variable Scope”. See the below image.

Here, in the “Set Variable” property window you will be asked to insert a variable name and a variable value. See the below image.

Once providing the variable name and value, press the “Done” button.

Post setting a variable name and value, now it’s the time to apply a loop. For this, you need to go to the “Loop Statement” command and then click on the “Loop Data Table” option.

Now, input your table name in the respective field of the “Loop Data Table” property window, and then press the “Done” button.

In the next step to add conditions to the program, you need to apply a conditional statement in it. For this, go to the “If statements” command and select the option as “Begin if”.

Once clicking on the “Begin If” command option, you must provide some details in its property windows, such as the type of if command and the parameter value.

Now, press the “Done” button and see the code window, where you need to put the entire if statement code within the loop statement. You can do it by simply cutting and pasting the code. See the below image.

Now, in addition, to read the table, you need to access the “Read Table” command option, which you can get under the “Data Table” command. See the image.

In the “Read Table” property window, provide all the required details. See the below image.

Here, in the “column identification name” field, select column identification type as per your need to read the data.

In the “specify column name” field, insert the specific name of the column from where you want to read the excel. In our suggestion, you need to insert “0” here, as it reads the entire data of the sheet from start to end.

Provide a variable name where you want to receive the fetched data, in the third field of the property window. Once providing all the details, press the “Done” button.

Now, prior to moving towards the next step, cut the read table code line and paste it within the “if statement” code line, as shown in the below image.

Moving forward, to print the data, go to the “Miscellaneous Operations” and click on the “Show Massage” command.

Insert the variable in the “Show Message” property window where you want to fetch the data,  and then press the “Done” button. See the below image.

Now, cut and paste the Show Message code line just below to the Read Table code line within the “If Statement” code. See the below image.

Now, to increase the count of the prior created variable value, you again need to set a new variable value. For this, again go to the “Variable Scope” and select the “Set Variable” command option, like previous.

Now, provide the required details in the “Set Variable” property window.

Here, I inserted [VCount]+1 as the new variable value, because it helps the program to increase the variable count by 1 at each iteration.

Now press the “Done” button and put the respective command line within the loop code. See the below image.

Now save the process by clicking on the “Save” button and clicking on the “Run” button under the “Actions” tab, to see the robot in action.

Now you can see your robot will show all the data of the respective excel sheet one by one.

The Loop List command is used to loop the list items. Let us see, how to perform this operation with an example.

• The Get Workbook Sheets command returns the list of sheet names one by one in a message box as an output. Let us see the steps one by one.
• First, create an excel instance, Click on Create Excel Application under Excel Automation.
• And, enter the instance name and then click on Done.
  
  

• Next, click on the Open Workbook command under Excel Automation, once the Instruction Properties pop-up window will open enter the instance name and select the file path location, then click on Done.
  
• Next, click on the Get Workbook Sheets command under Excel Automation, once the  Instruction Properties pop-up window will open enter,
  • Instance name
  • Create an output list variable and then click on Done.
    

• To get the name of sheets one by one we have to create a loop using the loop statement command.
• Click on the Loop List command under Loop Statement and enter the loop variable name and then click on Done.
  
• Now, we have to print this output in a message box, click on the Show Message command under Miscellaneous Operation, once the Instruction Properties pop-up window will open, enter the output variable name and then click on Done.
  
• Click on Save to save this code.
  
• Now, go to the Action tab and click on Run.
• Once the robot runs, the sheet names will be printed on the message box one by one.
  
• Once you click on Ok, the next sheet name will be displayed.
  
• Again if you click on Ok, the third sheet name will be displayed, which is as shown below.
  
• In the same way, you can print any number of sheet names by using the Get Workbook Sheets command.

The Loop Number of Times command is used to loop the given variable in the number of times.

Let us see how to perform this operation by using the DWmaker automation tool.

Click on the Loop Number of Times command, once the instruction properties pop-up window will open enter how many times you want to loop the variable, and then click on Done.

Next, click on the Show Message command, once the Instruction Properties pop-up window will open, enter the variable or text you want to loop a number of times, and then click on Done.

Now, save the code and run, once the robot runs successfully, the given variable will be looped given number of times.

The output is as shown below.

Click on Ok, the next loop will be displayed again in the message box.

Additionally, to fetch any data from the excel file, using DWmaker, first, we need to access the “Data Table Automation” command, in addition, to creating an “Instance name” See the image.

Once you click on the Data Table Automation command, it will open a list of a few more sub-commands, from which you need to select “Assign Data Table Instance”. As shown in the below image.

Now, in the “Assign Data Table Instance” property window, provide a “Data Table Name” and an “Instance Name” and then press the “Done” button. See the below image.

Moving ahead, to read the data from an XML file. First, you need to create a table, where you can store the fetched record of a file.

To create a table, click on the “Excel Automation” command, and then select and click on the “Create Excel Data Table” option.

Now, fill the “Create Excel Data Table” property window with the required details as data table name, the path of the file that you want to read, and the specific sheet name of the respective excel file. See the below image.

Once inserting all the details in the property window, press the “Done” button.

Note: Use the same data table name and the instance name every time in the process.

Now, in the next step, to read the entire data of a table one after one, you need to implement a loop in it. For the successful implementation of a loop first, you need to set a new variable in the program.

To set a variable, go to the “Set Variable” command under the “Variable Scope”. See the below image.

Here, in the “Set Variable” property window you will be asked to insert a variable name and a variable value. See the below image.

Once providing the variable name and value, press the “Done” button.

Post setting a variable name and value, now it’s the time to apply a loop. For this, you need to go to the “Loop Statement” command and then click on the “Loop Data Table” option.

Now, input your table name in the respective field of the “Loop Data Table” property window, and then press the “Done” button.

In the next step to add conditions to the program, you need to apply a conditional statement in it. For this, go to the “If statements” command and select the option as “Begin if”.

Once clicking on the “Begin If” command option, you must provide some details in its property windows, such as the type of if command and the parameter value.

Now, press the “Done” button and see the code window, where you need to put the entire if statement code within the loop statement. You can do it by simply cutting and pasting the code. See the below image.

Now, in addition, to read the table, you need to access the “Read Table” command option, which you can get under the “Data Table” command. See the image.

In the “Read Table” property window, provide all the required details. See the below image.

Here, in the “column identification name” field, select column identification type as per your need to read the data.

In the “specify column name” field, insert the specific name of the column from where you want to read the excel. In our suggestion, you need to insert “0” here, as it reads the entire data of the sheet from start to end.

Provide a variable name where you want to receive the fetched data, in the third field of the property window. Once providing all the details, press the “Done” button.

Now, prior to moving towards the next step, cut the read table code line and paste it within the “if statement” code line, as shown in the below image.

Moving forward, to print the data, go to the “Miscellaneous Operations” and click on the “Show Massage” command.

Insert the variable in the “Show Message” property window where you want to fetch the data,  and then press the “Done” button. See the below image.

Now, cut and paste the Show Message code line just below to the Read Table code line within the “If Statement” code. See the below image.

Now, to increase the count of the prior created variable value, you again need to set a new variable value. For this, again go to the “Variable Scope” and select the “Set Variable” command option, like previous.

Now, provide the required details in the “Set Variable” property window.

Here, I inserted [VCount]+1 as the new variable value, because it helps the program to increase the variable count by 1 at each iteration.

Now press the “Done” button and put the respective command line within the loop code. See the below image.

Now save the process by clicking on the “Save” button and clicking on the “Run” button under the “Actions” tab, to see the robot in action.

Now you can see your robot will show all the data of the respective excel sheet one by one.

To write something in an excel file, first, go to the “Excel Automation” command on the Process Bot Suite DWmaker tool, and then click on the “Create Excel Application” option under it. See the image.

Next, create an instance name in the “Create Excel Application” property window, and then press the “Done” button. See the image.

Now, to write in an excel sheet, first, you need to create a workbook, which you can simply create by clicking on the “Add Workbook” command under “Excel Automation”. See the below image.

Now, again provide your instance name in the “Add Workbook” property window, and then press the “Done” button.

In the next step, you need to activate an excel-sheet/workbook in which you want to write. To do this, go to the “Activate Sheet” command, under the “Excel Automation.

In the “Activate Sheet” property window provide the instance name and the specific sheet name of the excel file that you want to activate to write within.

Now Press the “Done” button, and move to the next step, in which you need to select a cell within the excel sheet where you want to write.

To select a cell within the excel sheet, go to the “Set Cell” command under the “Excel Automation”. See the below image.

Now, provide the instance name, text to write, and the cell location where you want to write the next in your workbook, in the “Set Cell” property window, and then press the “Done” button.

Likewise, you can write multiple texts in an excel sheet using the “Set Cell” command as prior.

Now, you have to save this workbook, for this go to the “Save Workbook As” command under “Excel Automation”. See the image.

On the “Save Workbook As” property window, provide your instance name and the location where you want to save the file.

To get the file path, simply select and open the particular file then it will get the file path, then copy it.

Now paste it on the location field of the “Save Workbook As” property window. See the image.

Once done inserting all the details, press the “Done” button.

Now save the entire process using the “Save” button of the DWmaker tool and move towards running it by clicking on the “Run” button under the “Actions” tab.

Once you press this “Run” button, the robot will start working and show you the result.

For example, I created this program to write the text as “Shannon” in the excel sheet. Thus, it prints the result with the given text as shown in the below image.

Using the above-mentioned simple steps you can easily write in an excel sheet.

To append data in an existing excel sheet accessing the DWmaker tool. First, you need to create an instance that you can create using the “Create Excel Application” option under the “Excel Automation” command. See the image.

Give a unique instance name in the “Create Excel Application” property window, and then press the “Done” button. See the image.

Once creating an instance, open a workbook in which you can write.

To open a workbook, go to the “Open Workbook” option under “Excel Automation”. See the image.

Now, in the “Open Workbook” property window, provide your instance name and the path of the respective excel file in which you want to write or append any data.

Press the “Done” button, and move to the next step, in which you need to call the particular sheet name of an excel file in which you want to append any data.

To provide a sheet name, go to the “Activate Sheet” option under the “Excel Automation” command.

Now insert the instance name and the specific sheet name of the excel file in the “Activate Sheet” property window, and then press the “Done” button. See the image.

In the next step, to append the data you need to get the last row index count. For this, click on the“Get Last Row Index” option, and fill the property window with the required details. See the image.

Once providing all the details in the property window, press the “Done” button.

Moving ahead to increase the variable count by one, go to the “Variable Scope” command and click on the “Set Variable” option. See the below image.

In the “Set Variable” property window, provide the variable name that you have created prior, and then increase its count by 1 in the next field, as shown in the below image.

Now, press the “Done” button and then, click on the “Set Cell” command. See the image.

Now, provide all the required details in the “Set Cell” property window and then press the “Done” button. See the below image.

Now click on the “Save Workbook” option under the “Excel Automation” command. See the below image.

In the “Save Workbook” property window, insert your instance name in the respective field and then press the “Done” button. See the below image.

Now, save the process, by pressing the “Save” button, and run it by clicking on the “Run” button under the “Actions” tab.

Once you click on the “Run” button, your robot will start working and you can see the result in the respective excel file. See the below image.

Using the above steps you can easily append data in an excel sheet using the DWmaker.

How to insert columns in an excel sheet?

Additionally to insert columns in an excel file using the DWmaker tool, first, you need to access the “Excel Automation” command.

Now select and click on the “Create Excel Application” command option under the “Email Automation” and fill up the respective property window with the required details.

In the property window of “Create Excel Application”, provide an ‘instance name’ and then click on the “Done” button. See the image.

Here is the first code of your program to insert and delete a row and column of an excel sheet.

Now you need to open an excel sheet or excel workbook that you want to read. For this, go on to the “Open Workbook” command option under “Excel Automation”.

This “Open Workbook” command will open a property window, where you are required to provide the required details as for instance name and the path of the workbook that you want to read. See the below image.

Once filling in all the details, press the “Done” button.

Now in the next step, you need to activate the excel sheet, for that you need to access the “Activate Sheet” option under the “Excel Automation” command.

Fill up the “Activate Sheet” property window with the required details, as the instance name and the name of the respective excel sheet that you want to access.

Press the “Done” button and then the activate sheet code will be displayed on your code window.

Moving further to insert a new column in the excel sheet, select the “Insert delete columns” options under the “Excel Automation” command.

Now fill up the property window of the “Insert/Delete Columns” command, as shown in the image below.

Note: In the column range file of the “Insert/Delete Columns” command property window, you need to input the range of the specific column in the sheet, where you are looking to add a new column, and then press the “Done” button.

Here, in the “Select action to perform” field, I have selected the option “Insert” because here I am adding a new column in the sheet. Likewise, if we want to delete a column from the sheet we will then select the option “delete”.

Now, save the process using the “Save” button.

Once successfully saving the process, click on the “Run” button under the “Actions” tab, to check the program in working action.

Once running the program, see the respective excel sheet, as now it has two new columns.

In the above steps, you have learned to insert new columns in an excel sheet, likewise, we can delete columns from the excel sheet in a few simple steps.

How to delete Columns in an Excel Sheet?

To delete columns from an excel file using the DWmaker tool, first, you need to access the “Excel Automation” command.

Now select and click on the “Create Excel Application” command option under the “Email Automation” and fill up the respective property window with the required details.

In the property window of “Create Excel Application”, provide an ‘instance name’ and then click on the “Done” button. See the image.

Here is the first code of your program to insert and delete a row and column of an excel sheet.

Now you need to open an excel sheet or excel workbook that you want to read. For this, go on to the “Open Workbook” command option under “Excel Automation”.

This “Open Workbook” command will open a property window, where you are required to provide the required details as for instance name and the path of the workbook that you want to read. See the below image.

Once filling in all the details, press the “Done” button.

Now in the next step, you need to activate the excel sheet, for that you need to access the “Activate Sheet” option under the “Excel Automation” command.

Fill up the “Activate Sheet” property window with the required details, as the instance name and the name of the respective excel sheet that you want to access.

Press the “Done” button and then the activate sheet code will be displayed on your code window.

To delete columns, for the first, again you need to go to the  “Insert delete Columns” option under the “Excel Automation” command and fill the property window with the required details. See the image below.

Sheet Name: It will be the specific sheet within an excel file, in which you want to perform the delete column operation.

Column Range: It will be the single column or the range of multiple columns that you want to delete from an excel sheet.

Select action to perform: In this field, you need to select a specific option as insert or delete.

Here, I have selected the ‘Delete’ option in the “Select action to perform” field, because here I want to delete a column from the excel sheet.

Press the “Done” button, once successfully filling the property window, and then save the process using the “Save” button.

Now, your robot is ready to delete a column from the excel sheet, to check it in working status, run the robot using the “Run” button under the “Actions” tab.

As a result, you can see it has successfully deleted the respective column from the sheet.

These are the easy steps to delete columns from an excel sheet using DWmaker.

An excel sheet holds huge data, and sometimes we found some repeated or duplicate values in it. As you can see there are a few duplicate values in my excel sheet that are marked in red. See the image.

To resolve this, we manually remove these duplicate values from a sheet.

To remove these repeated or duplicate values from an excel sheet, using the process bot suite DWmaker tool, first, create an instance by accessing the “Create Excel Application” option under the “Excel Automation” command.

Now in the “Create Excel Application” property window, provide a unique instance name, and then click on the “Done” button. See the image.

Now, open the excel file from which you want to remove the duplicate values. For this go to the “Open Workbook” option under the “Excel Automation” command.

Insert your instance name and the file location which you want to operate and then press the “Done” button.

Moving forward with the process, now click on the “Remove Duplicate Range” option which is listed under the “Excel Automation” command.

Now, the “Remove Duplicate Range” property window ask you to insert some required details in the respective fields, where;

Sheet Name: This is the particular sheet in the excel file form in which you want to remove the duplicate values.

Enter the Range: This is the column range in an excel sheet from which you want to remove the duplicate values.

Now, click on the “Done” button and save the process by pressing the “Save” button.

To check the result of the process, go to the “Actions” tab and press the “Run” button.

Now, when you click on the “run” button the robot will start working and show the result by removing all the repeated values. See the image.

So, these are the simple steps to remove the duplicate values from an excel sheet using the DWmaker tool.

In order to arrange the columns in an excel sheet by re-ordering them, from one location to another, for example, here I have an excel sheet,

Now, you can see the column arrangement in the sheet is not proper, as the column “E” with S.No, should be the first column in the sheet, that means at column “A”. To resolve this we need to reorder the column location. 

To re-order the location of any single or multiple columns in an excel sheet using the Process Bot Suite DWmaker, first, go to the “Create Excel Application” option under the “Excel Automation”. See the image.

Now create an instance by giving a unique instance name here on the “Create Excel Application” property window. See the image.

Moving forward, open the excel-sheet/workbook, by simply accessing the “Open Workbook” command option, which is listed under the “Excel Automation”.

Provide your instance name and the excel file path in the “Open Workbook” property window, and then click on the “Done” button.

Now, click on the ”Reorder Columns” option under the “Excel Automation” command. See the image.

Now, insert all the required details in the “Reorder Columns” property window, where;

Enter Sheet Name: This is the name of the particular excel sheet, in which you want to implement the column reorder operation.

Enter Source Range: This is the present column range that you want to re-ordered.

Enter Designation Range: This is the specific column range in the sheet where you want to put the re-ordered column. 

Select Source Column Shift Direction: This is the location where you want to shift the source column.

Now, press the “Done” button and move towards saving the process by clicking on the “Save” button.

Once saving the process, press the “Run” button under the “Actions” tab. 

With the click of the “Run” button, the robot will start working and you can see the result in your excel file. See the image.

So, the above is the easy steps with which you can easily re-order columns in an excel sheet.

Cell formation is also a part of formatting in an excel sheet. To proceed with the cell formatting process in an excel sheet using the. First, let’s learn why we need this type of formatting implementation in an excel sheet?

Basically, an excel sheet accepts numbers individually, which means without any decimal point, as shown in the below image.

This happens due to the default setting of the excel sheet. Meanwhile, to insert numbers with decimal in an excel file, we have to make some manual changes in the formatting of the file, so that it can allow us to insert decimal values in an excel sheet, as seen in the below image.

To get such results in an excel sheet, first, select the entire range of the rows or columns in an excel sheet that you want to edit with decimal, and then click on the “Format” option. See the image.

Now, click on the “Format Cells” option and then go to the “Number” in its property pop-up.

Here, the by-default decimal place is 2, which we can set in the excel sheet as per our requirement.

Now, to do the same thing in the Process Bot Suite DWmaker, create an instance by accessing the “Create Excel Application” option under the “Excel Automation” command.

Once providing a unique instance name in the respective field, press the “Done” button.

Now go to the “Open Workbook” option and provide the instance name and the file path in which you want to implement the cell formatting command, in its property window. See the image.

Press the “Done” button and move to the next step.

Now, click on the “Format Cells” option, under the “Excel Automation” command. See the image.

The “Format Cells” property window will require you to provide some details, where,

Sheet Name: This is the name of the specific excel sheet in which you want to perform the cell format operation.

Enter the Range: Here, enter the range of the cells or rows of an excel sheet whose formatting you want to edit.

Select Cell Range Format Type: In this field, select an option as text or number that you want to edit with decimal.

Enter the Number Format: Here, provide the number format as how many digits you want to enter after a decimal. For example: 0.00, 0.0000, etc.

Select Horizontal Alignment Type: It’s ‘Left’ by default, while you can also select ‘Right’, ‘Center’, ‘Jutify’, etc, as you want.

Select Vertical Alignment Type: It’s ‘Top’ by default, while you can also select as ‘Right’, ‘Center’, ‘Justify’, etc, as you want.

Press the “Done” button and proceed to save the process, by simply clicking on the “Save” button.

Once successfully save the process, click on the “Run” button under the “Actions” tab to see the result.

When you run the robot it will start working and you can see the result in your excel sheet.

With the above steps, now you know how easily you can edit the formatting of cells in an excel sheet.

The Import Text File command is used to import the Data from text file to excel worksheet. The fields in the text file has been separted by the delimeters. usually, the delimeters include Tab, Space, and comma.

Let us see how to perform automation of Import Text File by using Dwmaker.

• Click on the Import Text File command under the Excel Automation in the Dwmaker.
• Once the Instruction Properties pop-up window will open,
  • Click on Select the text file to be import in Excel
  • Next, enter the start line number of the text file.
  • Select the type of Delimeter.
  • Next, enter the value of other delimeter, this will be applicable, only, if your text file contains more than one delimeter in it.
  •  Next, click on the Select a File under the Select the Import file Path and select the workbook file path location in which excel file you want to import the text file. and then click on Done.
  • Here , after running the robot, a new excelwill be created with the given name and new sheet has been added to it in the name of the text file.
    
    
  • Next, click on Save under the Robots tab and then go to the Actions tab and click on Run button.
  • Once the robot run successfully, therobot will craete a new excelfile in the given location and craetes a new sheet with the name of the text file and import all the data which is present in the text file.
  • Once the robot runs successfully, go to the given file path and verify, a new file has been created which is as shown below.
    
  • Now, click on the Myexcel file and open it,you can see the imported data in it which is as shown below.
    
  • This is how we can import data from text file to Excel worksheet.

In order to autofill any range of data in an excel sheet using the DWmaker tool, first, go to the “Excel Automation” command and then click on the “Create Excel Application” option. See the Image.

Now, provide a unique instance name in the “Create Excel Automation” property window. See the image.

Press the “Done” button and then click on the “Open Workbook” option, in order to open a respective excel sheet in which you want to autofill the data in the particular range. See the image.

Provide your instance name and the excel file path that you want to auto-fill in the “Open Workbook” property window, and then press the “Done” button. See the image.

Now, click on the “Auto Fill Range” option under the “Excel Automation” command. See the image.

Now, fill the “Auto Fill Range” property window, with the required details, where;

Source Range: This is the specific cell range within the excel sheet, from where you start entering the data, basically Source Range is Starting Point, in the Source Range field we have to provide a starting point.

Fill Range: Here in the fill range field, you have to provide a cell range up to which you want to enter the data in an Excel Sheet.

Now, press the “Done” button and save the process by clicking on the “Save” button. 

Once successfully save the robot, click on the “Run” button under the “Actions” tab. Then the robot will start working and you can see the result in your excel file.

So, the above is the most simple and easy process to autofill the data in a particular excel sheet, using the DWmaker tool.

• Our Process Bot DWMaker has provided a command called Copy Sheet using which we copy an excel sheet.
• In this section, let us see how we can copy an excel sheet from one excel file to another excel file or in the same excel file.
• Our first step is to open the Process Bot DWMaker.
• Select the Copy Sheet command under Excel Automation.
  
• Next, Instruction Properties pop-up window will open, 
  • Enter the file name under the select a file,
  • Enter the sheet name under Entering the sheet name from where you want to copy
  • Click on the drop-down list under the copy to the same file? Select yes, if you want to copy to the same file else select No.
  • Next, enter the Destination file name.
  • And, enter the name of the new sheet file and then click on Done as shown below.
• Now you can see a code written on the code window.
  
• Now, click on the Save to save this automation code, Once you click on the save you will navigate to the My Scripts folder, enter the name for this automation and then click on Save.
  
  
• Now, go to the Actions Tab and then click on the Run button.
  
• Here, I have copied the Myexcel.xlsx file from sheet1 to Contents written file to sheet4. Which is as shown below.
  
• In the same way, we can copy the sheet from one sheet to another sheet in the same file.

Lookup range stands for searching for a value in the middle of a range of possibilities.

Let us see how to search for a value in the given range step by step. Our first step is to create a workbook.

• Open DWmaker and then click on the Create Excel Application under Excel automation.
• Next, you will navigate to the Instruction properties window, enter the name of the Instance you want to create, under the Please enter the instance name.
• And then click on Done.
  
• Here, I have created an instance called Search_Instance.
• Our next step is to open a created workbook.
• Click on the Open Workbook under Excel Automation.
• As soon as you click on Open Workbook, you will navigate to the Instructions Properties
• Enter the Instance name which you have created early(Search_Instance)
• Next, click on the Insert Variable and select the file, in which file you want to open your search instance.
  
• Our next step is to look for the value in the given range, for that we have to use the Lookup range command.
• Click on the Lookup Range under Excel Automation.
• As soon as you click on the Lookup range, you will navigate to the Instructions Properties
• Enter the,
  • Instance name.
  • Enter the sheet name, in which sheet you want to search for the value.
  • Enter the range, for example, if you want to search for an apple in between A1 row to A4 row, then enter range as A1:A4
  • Enter the name of the value you want to search for.
  • Select the Search for All option, this will search for your value in the given range.
  • Enter the output variable name, this variable will store your value. And, it is always good practice to declare the variable as
  • Click on Done.
    
  • Next, We have to display the output using the show message
  • Click on the Show Message under Miscellaneous Operations.
  • Enter the variable name which you have already created to store your search value.
  • Click on Done.
    
  • Now, click on save to save this code and the complete code will look like below.
    
  • Now, click on the Action tab and then click on Run to run the above code.
    
  • Once you run the code, the cell number of the corresponding search value will be displayed in the Message Box pop-up window.
    
  • I was searching for Mango in the excel file, and hence the A4 is the right cell number where my search value is present.
    
  • If you have duplicate values in the excel file, and, if you select the First Occurrence under the Select Search For in the Lookup-Range Instructions Properties window, then the bot will display only the first occurrence of the search value.
  • In the below excel file, I have two duplicate values as A2 and A4.
    
  • Now, save and run the robot, you can see, only the first occurrence of the duplicate value will be print in the output message box.Note: After every edition of the code, you to save the code before running the code.
    
  • In the same way, if you select All in the Select Search For option in the Lookup Range Instructions Properties window.
    
  • Now save and run the robot, in the out you can see both the duplicate values will be displayed in the output Message Box.
    
  • Once you click on Ok, the next cell number will be displayed as shown below.
    
  • So, this is how we can find the value between a given range using the lookup range command.

• Merge Cells is a Microsoft Excel add-in, that merges values from columns, cells, and rows.
• Merge Cells is the finest aid for you if you need to get one cell out of multiple, merge columns row by row or rows column by column.
• Now let us see the process of merging cells step by step.
• Our first step is to create an instance, click on the Create Excel Application under Excel Automation.
• Enter the instance name under the Inert Variable in the Instruction Properties pop-up window and click on Done.
  
• Next, click on Open Workbook under Excel Automation and enter the instance name and click on Select a File and select the file path in which you want to merge the cells, and then click on Done.
• Next click on the Merge cells under Excel Automation, and then,
  • Enter the instance name.
  • Enter the sheet name in which sheet you want to merge the cells.
  • Enter the cell range to merge the cells, and then click on Done.
    
  • Now click on save to save this code.
  • Next, go to the Action Tab and then click on Run.
  • Now, go to the file and see, the given range cells are merged as shown below.
    
  • Now you can enter the text inside the merged cells.
    
  • This is how we can merge cells using excel automation.

The Set Cell command is used to replace the current cell value with the new cell value.

Let us see how to perform this operation step by step.

• First, we need to create an instance, click on Create Excel Application command under Excel Automation.
• Once, the Instruction Properties pop-up window will open,
  • Enter Instance name
    
• Next, click on Open Workbook, once the Instruction Properties pop-up window will open, enter the instance name and select the file and then click on Done.
  
• Next, we need to activate the sheet, in which we are performing the Set cell operation. I am using the below excel sheet which is as shown below.
  
• Next, click on Activate Sheet command, once the Instruction Properties pop-up window will open, enter instance name, sheet name, and click on Done.
  
• Next, click on the Set Cell command, once the Instruction Properties pop-up window will open, enter the below details which are present in the image.
  
• Now, save the code and go to the Actions tab and click on Run.
• Once the robot runs, successfully, the cell value of A4 (Elephant) will be replaced with Rat.
  

Sets the values of all cells in a specified range on a specified sheet in an Excel file, sets the data format for each column in the range and defines range column headers.

Let us see how to perform a set cell range using robot automation.

• Our first step is to create a data table instance, click on the Assign Data Table Instance under Create Data Table Automation.
• Next, the Instruction Properties pop-up window will open,
  • Enter the data table name and instance name, and then, click on Done.
    
  • Next, click on Create Excel Data Table under Excel Automation and
    • Enter data table name.
    • The workbook file path, and
    • Enter the sheet name which sheet you want to open and then click on Done.
      
    • Now, we have to check whether the data table has been created or not, for that we have to preview it.
    • Click on Preview Data Table under Data Table Automation and enter the required details.
      
    • Now, we have to write the data from the data table to an excel sheet, for that we need to create an excel sheet.
    • Click on the Create Excel Application, and enter the details in the Instruction Properties pop-up window.
      
    • We can enter the data into a new workbook or in our old workbook, here I am using my old workbook only.
    • Click on the Open Workbook command under Excel Automation and enter the following details
      
  • Now, we have to set the cell range to enter the data in the workbook, for that, click on the Set Cell Range under the Excel Automation and,
    • Enter the instance name.
    • Enter the source data table name.
    • Enter the sheet name in which sheet you want to enter the data. If you mention the sheet name which is already having data in it, then the data will be over-written.
    • Enter the start cell name, that from which cell you want to enter the data for example A/B/C/D..etc.
    • Enter the start row number, you can also choose from which row you want to start entering the data.
    • Next, click on Done.
      
  • Now, save the code and go to the Action tab and click on Run.
  • Once the robot starts running, the excel will open which contains the data, which is as shown below.
    
  • If you verify the above image, the data has been started from A cell 8th row.
  • This is how we can set the cell range to enter the data table.

The appearance of individual characters in the text is altered by using the Set Font command.

Let us see how to set font using excel automation step by step.

• Our first step is to create an excel instance.
• Click on the Create Excel Application command under Excel Automation, and enter the instance name and then click on Done.
  
  
• Next, we have to open a workbook, click on the Open Workbook under Excel Automation.
• As soon as you click on Open Workbook, the Instruction Properties pop-up window will open, Enter,
  • Instance name
  • Enter the workbook file path.
  • Click on Done.
    
• After selecting the workbook, click on the Set Font command under Excel Automation.
• As soon as you click on Set Font, the Instruction Properties pop-up window will open. Enter the Instance name, Sheet name, Enter cell range, for example, A1:D1
  
• Next, click on the Select Font Style drop-down and select which font style you want.
  
• Next, select the size of the font by clicking on the Select Font Size drop-down and select the Yes/No from the Select Underline Option and then click on Done.
  
• Now, Click on Save to save the code and then go to the Action tab and click on Run.
  `
• In the above image, you can see that the cell from A1 to D1, font style, and font size have been changed as we had given in the Instruction Properties Window.

• The Get Cell command returns the value of the given cell number.
• Let us see how to get the value of the given cell by using excel automation.
• Our first step is to create an excel instance, click on the Create Excel Application command under Excel Automation.
• And, enter the instance name and then click on Done.
  
• Next, we have to open the workbook, click on the Open Workbook command under Excel Automation and then enter,
  • Instance name
  • Click Select File and select the file path location, from which file you want to get the cell value.
  • And then click on Done.
    
  • Next, click on the Get Cell command and enter the following details in the Instruction properties pop-up window.
  • Enter the instance name, and enter cell location, which means the cell number from which cell you want to get the cell value. For example, A1, B2, C3, etc.
  • For example, look at the below image. I have an excel sheet. I want to print the cell value “Technical Content Writer” so that I am giving the cell location as B2.
    
  • Next, create a variable, which will hold the cell value in it.
  • Click on Done.
    
  • Our next step is to print this call value on the output screen.
  • So, click on the Show Message command under Miscellaneous Operations and enter the variable name you have created to hold the cell value in it. Click on Done.
    
  • Now, click on Save to save this code.
  • Go to the Action tab and click on Run.
    
    
  • Once the robot runs, the cell value will be printed in a pop-up message box window. Which is as shown below.
    

The Get Last Row Index command gives us the last row number. Let us see how to perform this operation step by step.

• Our first step is to create an excel instance.
• Click on the Create Excel Application under Excel Automation.
• Enter the instance name and then click on Done.
  
• Next, we have to open the workbook, click on the Open Workbook command under Excel Automation.
• Once the Instruction Properties window will open, enter the instance name, and then select the file path.
  

  Note: If your excel file is having more than one sheet and if you want to get the index value in the particular sheet, then you can add the Activate sheet command after Open Workbook.

  • My excel file has two sheets in it, so I am using the Activate sheet command to get the last row index in a specified sheet.
  • Click on Activate sheet under Excel Automation, in the Instruction Properties pop-up window, enter the below details.
    • Enter the instance name
    • Enter the sheet name
    • Click on Done.
      
    • Next, click on the Get Last Row Index under Excel Automation.
    • Once the Instruction Properties window will open, enter the instance name, enter the column number to get the index number of the same.
    • And, create a variable to hold the index number. Click on Done. 
      
      
    • Now, we have to print the last row index number in the message box as an output.
    • Click on the Show Message command under Miscellaneous Operations.
    • Once the Instruction Properties window will open, enter, Variable name which you have created, and then click on Done.

      

    • Now, save the code and then go to the Action tab and click on Run.
      
    • So my last row index value is 10.
    • You can verify by opening your excel sheet.
      

The Get Range color returns the name of the given cell color. Let us see how to perform this operation using excel automation.

• Our first step is to create an instance, click on Create Excel Application under Excel Automation.
• Once, the Instruction Properties pop-up window will open, enter the instance name and click on Done.
  
• Next, click on the Open Workbook command under Excel Automation, and enter the instance name and select the file path location and then click on Done.
  
• Here I am using the below excel sheet.
  
• Next, click on Get Range Colour, under Excel Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Sheet name
  • Enter the cell range
  • Enter the output variable name to get the color name, click on Done.
    
• Now we have to print the output in the message box, so click on the Show Message under Miscellaneous Operations and then enter the variable name in the Instruction Properties pop-up window and then click on Done.
  
  
• Now, click on Save to save the code.
• Go to the Action tab and then click on Run.
  
  
• Once the robot runs, you can see the output in the Message box as shown below.
  
• This is how we can perform Get Range Colour.

The Get Workbook Sheet by Index command will return the sheet name with respect to the given index value.

• • Let us see the steps to perform this operation using excel automation.
  • Our first step is to create an instance, click on the Create Excel Application under Excel Automation and enter the instance name and then click on Done.
    

• Next, click on Open Workbook and then enter the instance name and then enter the file path location and then click on Done.
  

• Here I am using the below excel file, which has three sheets namely, January, February, and March.
  
• I am going to print the March by giving the sheet index as 3.
• Next, click on the Get Workbook by sheet Index under Excel Automation, Once the Instruction Properties window will open enter,
  • Instance name
  • Enter the Index of Sheet, which means, you need to enter the Index of the sheet which you want to print in the output.
  • If you have three sheets in your excel file, and you want to print the 2nd sheet name, then enter the sheet of the index as 2.
  • Next, create a variable to hold the output value.
  • Click on Done.
    

• Next, click on Show Message under Miscellaneous Operations.
• Once the Instruction Properties pop-up window will open, enter the output variable and then click on Done.
  
• Now, click on Save.
• Next, go to the Action tab and then click on Run.
  
• Once the robot runs, the index of the sheet will be displayed on the Message Box.
  

The Get Workbook Sheets command returns the list of sheet names one by one in a message box as an output. Let us see the steps one by one.

• • First, create an excel instance, Click on Create Excel Application under Excel Automation.
  • And, enter the instance name and then click on Done.
    
    

• Next, click on the Open Workbook command under Excel Automation, once the Instruction Properties pop-up window will open enter the instance name and select the file path location, then click on Done.
  
• Next, click on the Get Workbook Sheets command under Excel Automation, once the  Instruction Properties pop-up window will open enter,
  • Instance name
  • Create an output list variable and then click on Done.
    

• To get the name of sheets one by one we have to create a loop using the loop statement command.
• Click on the Loop List command under Loop Statement and enter the loop variable name and then click on Done.
  
• Now, we have to print this output in a message box, click on the Show Message command under Miscellaneous Operation, once the Instruction Properties pop-up window will open, enter the output variable name and then click on Done.
  
• Click on Save to save this code.
  
• Now, go to the Action tab and click on Run.
• Once the robot runs, the sheet names will be printed on the message box one by one.
  
• Once you click on Ok, the next sheet name will be displayed.
  
• Again if you click on Ok, the third sheet name will be displayed, which is as shown below.
  
• In the same way, you can print any number of sheet names by using the Get Workbook Sheets command.

The Worksheet Table Range command returns the worksheet table range.

Let us see, how we can perform this operation in Excel Automation.

• First, we need to create an excel worksheet table.
• Open your excel file and then select data present in the table and then go to the Insert and click on the Table symbol.
• Or you can also use Ctrl+T as a shortcut.
  
• Now, go to the DWmaker and click on the Create Excel Application command under Excel Automation, Once the Instruction Properties window will open, enter the instance name and click on Done.
  
• Next, we need to open the workbook, click on the Open Workbook command, once the Instruction Properties window will open, enter,
  • Instance name
  • Select the file path location
    

• Next, Click on the Get Worksheet Range under Excel Automation, once the Instruction Properties window will open, enter,
  • Instance name
  • Sheet name
  • Worksheet Table name
  • Output variable name
  • Click on Done.
    
    

• Next, click on the Show Message under Miscellaneous Operations, Once the Instruction Properties pop-up window will open, enter, output variable name.
  
• Now, save the code and go to the Action tab and then click on Run.
  
• Once the Robot runs, the worksheet table range will be print on the Message Box.
  
• You can verify by looking at the below excel file.
  

The Go-To Cell command takes you to the given cell location.

Let us see, how to perform this operation step by step.

• Our first step is to create an excel instance, click on the Create Excel Application under Excel Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Select the file path location.
  • Click on Done.
    

• Next, click on the Open Workbook under Excel Automation, Once the Instruction Properties pop-up window will open, enter the instance name and select the file path location, and then click on Done.
  
• Next, click on Activate Sheet under Excel Automation, Once the Instruction Properties window will open, enter the instance name and sheet name and then click on Done.
  
• Next, click on Go To Cell command under Excel Automation, Once the Instruction Properties pop-up window will open, enter the instance name and enter the cell location.
• And, then click on Done.
  
• Now, click on the Save to save this code.
• Next, go to the Action tab and then click on Done.
  
• Once the robot runs, open the excel file, you can see that the robot is pointing to the given cell location.
  

The Create Worksheet Table command creates a worksheet table with the given table name in the given sheet.

Let us see how to perform this operation step by step.

• Our first step is to create an instance.
• Click on the Create Excel Application under Excel Automation, Once the Instruction Properties pop-up window will open, enter the instance name and click on Done.
  
• Here, I am using the below data which is present in the excel sheet.
• To create a worksheet table, the data must be present in the given sheet, or else you will end up with an error.
• Next, click on the Open Workbook command under Excel Automation, once the Instruction Properties pop-up window will open, enter the instance name and select the file path location.
  
• Next, click on the Activate Sheet command under Excel Automation, once the Instruction Properties pop-up window will open, enter the instance name and sheet name, in which sheet you want to create a worksheet table.
  
• Next, click on the Create Worksheet Table under Excel Automaton, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Sheet name
  • Enter the range (Example: A1:D8)
  • And, enter the table name to be created.
  • Click on Done.
    
• Now, click on Save to save the code.
• Go to the Action tab and then click on Run.
  
• Once the robot runs, the worksheet table will be created in the given range.
  

The Cell Border command adds a border to the individual or to the whole table according to the given cell range.

Let us see, how to perform this operation in DWmaker using Excel Automation.

• The first step is to create an Instance.
• Click on Create Excel Application under Excel Automation.
• Once, the Instruction Properties window will open, enter the instance name and click on Done.
  
• Next, click on the Open Workbook command, once the Instruction Properties window will open, enter the instance name, click on select a file and select the excel file, in which file you want to put cell border.
  
• Our next step is, click on the Cell Border command, once the instruction properties pop-up window will open, enter the required details as shown in the below image.
  
• Now, save the code and go to the Actions tab and click on Run.
• Once the robot runs successfully, open the excel file and see, the given cell range cells’ color has been changed to red color.
  

The Delete Cell command is used to delete a single cell or multiple cells in the given range.

• Our first step is to create an excel instance, click on the Create Excel Application under Excel Automation.
• Once, the Instruction Properties pop-up window will open, enter the instance name and click on Done.
  
• Next, click on the Open Workbook command under Excel Automation, Once the Instruction Properties pop-up window will open, enter the instance name and click on the Select a File and select the file path location.
  
• Now, click on Activate Sheet under Excel Automation, Once the Instruction Properties window, enter the instance name and sheet name within the workbook, you want to delete the cell.
  
• Now, click on Delete Cell, under Excel Automation, Once, the Instruction Properties window will open, enter the below details which are present in the image.
  
• Now click on Save and then go to the Actions tab and click on Run.
• Once the robot runs successfully, the given range cell will be deleted from the workbook.
  

The Insert or Delete Table Column command is used to insert or delete columns in the worksheet table.

Let us see what are the steps involved in this process.

• Here we can create a new worksheet and perform an insert or delete table column action or
• We can insert/delete table columns from your old worksheet table.
• Here I am using my old worksheet table which is as shown below.
  
  

• Our next step is to create an excel instance, click on the Create Excel Application, Once the Instruction Properties pop-up window will open, enter,
  • Instance name and click on Done.
    
    

• Next, Click on the Open Workbook command under Excel Automation, once the Instruction Properties pop-up window will open, enter the instance name and click on Select a File and select the file path location.
  
  
• Next, click on Activate Sheet, once the Instruction Properties window will open, enter the instance name and sheet name and click on Done.
  
  
• Next, click on Insert/Delete Table Column command under Excel Automation, Once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Sheet name
  • Column number position(for example A column means 1, B means 2, etc…)
  • Column Header name
  • Table Name
  • Select action to be performed(Insert/Delete)
  • Click on Done.
    
    
• Now save the code and go to the Action tab and click on Run.
  
• Once the robot runs successfully, the new column has been inserted into the given worksheet table.
  
  
• In the same way, we can also delete the column from the worksheet table.
• Click on the Insert/Delete table column code line in the DWmaker, select the Delete option from the Action to perform, and select the column name.
  
• Here I want to delete the Fiber column, so enter the column name as Fiber as shown below.
  
• Now, save the code and run.
• Once the robot runs successfully, the given column will be deleted from the worksheet table.
  

The Insert or Delete Table Row command is used to insert or delete rows in the worksheet table.

Let us see what are the steps involved in this process.

• Here we can create a new worksheet and perform an insert or delete table row action.
• We can insert/delete a table row from your worksheet table.
• Here I am using my old worksheet table which is as shown below.
  
  

• Our next step is to create an excel instance, click on the Create Excel Application, Once the Instruction Properties pop-up window will open, enter,
  • Instance name and click on Done.  
    
    

• Next, click on the Open Workbook command under Excel Automation, once the Instruction Properties pop-up window will open, enter the instance name and click on Select a File and select the file path location
  
  
• Next, click on Activate Sheet, once the Instruction Properties window will open, enter the instance name and sheet name and click on Done.
  
  
• Next, click on Insert/Delete Table Row command under Excel Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Sheet name
  • Row index position
  • Table Name
  • Select action to be performed(Insert/Delete)
  • Click on Done.
    
    
• Now save the code and go to the Action tab and click on Run.
• Once the robot runs successfully, the new row has been inserted into the given worksheet table.
  
• The row number will always be started from zero(0), so, the row will be added to the 3rd row.
  
• In the same way, we can also delete the row from the worksheet table.
• Click on the Insert/Delete table row code line in the DWmaker, select the Delete option from the Action to perform, and select the row name.
  
• Here I want to delete the 2nd row, so, enter the row index number.
  
  
• Now, save the code and run.
• Once the robot runs successfully, the given row will be deleted from the worksheet table.
  

The Save Workbook command is used to save the workbook. Let us see what are steps are involved in this operation.

First, create an instance, click on Create Excel Application. Once an Instruction Properties pop-up window will open, enter the instance name and click on Done.

• Next, click on the Open Workbook command, once the Instruction Properties window will open, enter the instance name, and select the file path location.
  
• Next, click on Activate Sheet command under excel automation, once, the Instruction Properties pop-up window will open, enter, instance name, and sheet name, which you wanted to activate.
  
• Next, click on the Save Workbook command under, Excel Automation, once the Instruction Properties pop-up window will open, enter the instance name and click on Done.
  
• Now, save the code and go to the Actions tab, and click on Run, once the robot runs successfully, the excel file will be saved with its original name after editing.

The Create Pivot Table command is used to create a pivot table. Where a pivot table in Microsoft Excel is a tool that allows you to quickly summarise large datasets (with a few clicks). You can utilize a Pivot Table even if you’re completely unfamiliar with Excel. Creating reports is as simple as dragging and dropping row/column headers.

Let us automate this process using the DWmaker automation tool.

• Our First step here is to create an excel application, click on Create Excel Application command, once the Instruction Properties pop-up window will open, enter the Instance name and them click on Done.
  
• Next, click on Open Workbook command, once you navugate to the Instruction Properties pop-up window, enter the workbook file path location and then click on Done.
  
• In this example i am using below data table to create a pivot table.
  
• Next click on Active Sheet command, once you navigate to the Instruction Properties pop-up window, enter the sheet name from which sheet your extracting data from the data table to carete a Pivot table.
  
• Next, click on Create Pivot Table command, once the Instruction Properties pop-up window will open, enter:
  • Instance Name
  • Enter the source Data Cells Rnage
  • Enter the sheet name.
  • Next, ener the column name and function, here you can add column which you wanted to create a pivot table and you can ignore rest column names.
  • Next, enter the destination sheet name. Which is as shown below.
    
  • Next, click on Done.
  • Click on Save Workbook command, once the Instruction Properties pop-up window will open enter teh instance name and then click on done.
  • In this example i am going to create pivot table for Years, sales and ratings.
  • Where I wnat the min of the year which is present in the table and Wants to get the sum of the total sales and Sum of the total ratings
  • Now save the robot and run.
  • Once the robot run successfully, the robot will craete a pivot table in the destination sheet by using the data prsent in the given data table from the given sheet name which is as shown below.
    
  • This is how we can create a pivot table by using the data which vailable in the data table and can summerise the values easily.

The Save Workbook As command is used to save the current workbook with a new name. Let us see what are steps are involved in this operation.

• First, create an instance, click on Create Excel Application. Once an Instruction Properties pop-up window will open, enter the instance name and click on Done.
  
• Next, click on the Open Workbook command, once the Instruction Properties window will open, enter the instance name, and select the file path location.
  
• Next, click on Activate Sheet command under Excel Automation, once, the Instruction Properties pop-up window will open, enter the instance name, and sheet name, which you wanted to activate.
  
• Next, click on the Save Workbook As command under, Excel Automation, once the Instruction Properties pop-up window will open, enter the instance name and enter the file path location with the new file name and then click on Done.
  
• Now, save the code and go to the Actions tab, and click on Run, once the robot runs successfully, the excel file will be saved with its new name after editing.
  

Cognitive Automation Process is a pre-trained automation technology, it automates specific business processes and accepts less data before making an impact.

Say “No Manual” to manual document processing. Our cognitive technology is ready to take over your manual and boring document processing work. It can capture data from any unstructured documents like invoices.

Invoice capture (also known as invoice data extraction or invoice OCR) is the process of obtaining structured data from invoices to process them mechanically/Automatically. For most businesses, invoice capture was the first back-office operation to be automated with AI.

For Example, Employee onboarding bots and other cognitive automation tools can aid by automating a variety of tasks in a rapid, efficient, predictable, and error-free manner. Before they even sit at their desk for the first time, this can entail generating computer credentials and Slack logins automatically, enrolling new recruits in department-specific pieces of training, and organizing recurrent meetings with their managers.

The Parse Invoice command is used to create an Invoice Instance in the Process Bot One. Now let us see, how to create an instance of invoice and train your bot:

• Login to your Process Bot One using your login credentials.
• Click on the Cognitive Bot.
• Once you click on the Cognitive Bot, you will navigate to the Invoice Instance List, which is as shown below.
  
• To create a new instance, click on the + Instance
• Next, Add invoice instance page will open, which is as shown below.
  
• Enter the name of the instance under the Learning Instance Name.
• Next, upload the sample invoice document, which you want to train to your bot.
• You can upload a maximum of 10 invoice documents at once to train your bot.
• In the image below, I have uploaded one invoice document.
  
• Scroll down the Add invoice instance page, you will find Standard Form Fields and Standard Table Fields
• Where the standard form fields are related to the invoice and the standard form field values are always unique. For example, Invoice Number, Invoice date, Invoice Owner, etc.
• And, the Standard table fields are related to the item/product. For example, Item description, Item quantity.
• Now, select the standard form fields which are present in your invoice document.

• In the below image I have selected the fields, which are present in my invoice document.
• In the same way, I have selected the standard table fields, which are as shown below.
  
• In case your invoice is having any standard form fields or standard table fields and if the option is not present in the orchestrator then you can mention that in the other fields(optional) and click on the Add as Form/ Add as Field
• After adding all the details click on the Create instance and analysis button, as shown in the image below.
  
• Next, the Data page will open, which contains three parts as Fields, Fields Value, and an Invoice image that we have uploaded. Which is as shown below.
  
• Here, we are going to train our bot by creating an invoice instance. The first step is to select the field under the fields list.
• Next, select the field from the Fields list and,
  • Then move your cursor on the invoice,
  • And select the same field value in the image and draw a rectangle box,
  • So that the value will be automatically added under the respective field in the Fields Values drop-down list.
• For example, if you select Invoice Number in the fields, then you have to draw a rectangle box on the invoice number in the invoice.
• In the below image you can see that I have selected the Invoice number and drawn a rectangle box on the invoice number in the invoice image, then automatically, the invoice number will be copied to the invoice number in the values of the field.
  
• As soon as you draw a rectangle on the invoice number, automatically the numbers will be captured under the Fields Values.
• Next, click on the Instance and Analysis, so that the details will be added to your bot.

Note: If you have multiple items in your invoice then, you can select either first or second row items to train your bot.

• Now, you can see the list of instances created. This is as shown in the below image.
  
• This is how you can create and train your bots.
• Our next step is to parse the created instance and extract the parsed data from the Process Bot One to Process Bot DWmaker.
• What is parsing: The process of examining a string of symbols, whether in normal language, computer languages, or data structures, according to the principles of formal grammar is known as parsing, syntax analysis, or syntactic analysis.
• To obtain an invoice parse, the Process Bot One should be always connected with the Process Bot DWmaker.
• Now, open the Process Bot DWmaker and click on the Parse Invoice under the Cognitive Automation drop-down list, which is as shown in the below image.
  
• Once you click on the Parse Invoice, the Instruction Properties pop-up window will open which is as shown in the below image.
• 
• Now, click on the Select AI Bot drop-down list and select the Invoice as shown below.
  
• Next, click on the Select Instance drop-down and select an Instance from the drop-down list, to which instance data you want to parse.
  
• Next, we have to select a file(a sample Invoice document) to parse data. So, click on the Select a File under Select the appropriate file.
• Enter variable name(The variable name should not contain space), In the below image I have created a variable name asParsed_Data.

Note: It is always good practice to declare a variable in the below syntax format.

v.Variable_Name

• And then click on the Done button.
  
  

• Next, select the Show Message option under Miscellaneous Operation.
  
  
• As soon as you click on the Show Message, and Instruction Properties pop-up window will open, enter the variable name under the insert variable and click on Done.

Note: The variable name should be always enclosed in a square bracket[].

• Next, click on Save on the Process Bot DWmaker.
  
• Next, click on the Action Tab, and then click on the Run button.
  
  
• Once you click on the Run, the robot will start working and the Message box pop-up window will open.
• Which contains the parsed data of the Invoice.
  
• You can also select which code you want to execute or if you don’t want to execute, then, you can disable the code from being executed.
• In the below image, I have three codes, right-click on the code which you want to disable and then, select the disable selected code option, then the selected code will not execute.
• In the same way, you can enable, disable or Pause Before Execution, Cut Selected action(s), Copy Selected Action(s), Paste Selected Action(s).
  

Email automation is the capability to send relevant information to subscribers via time or activity-driven emails. Email automation may be used for a variety of objectives. 

Email automation makes email marketing more effective, customized, and relevant, whether it’s a triggered workflow that helps nurture new leads, birthday greetings that add a personal touch, or automatic blog updates that take the work out of staying in contact with your audience.

One of the most efficient techniques of interacting with prospective customers and followers who have a genuine interest in following a business or brand’s updates is to use automation for email campaigns. You won’t have to miss another chance to create leads, sales, or money using email automation solutions.

The DWmaker is associated with three Email automation commands. Which are listed below:

1. IMAP Get Mail: This Command Permits the user to read all the emails in their inbox, these emails can be read or unread as well.
2. POP3 Get Email: This command will allow users to read all the emails using a robotic process.
3. Send SMTP Email: This command option will allow a user to send responses to the email.
4. Outlook Get Email: This command option will read your email from outlook.
5. Send Outlook Get Email: This command option will send an email to ur recipient.

Let us see how to use these commands in Email Automation:

The IMAP Get Mail command is used to check all the read or unread emails in your inbox. Now let us check for the new messages using the DWmaker tool. Click on Email Automation command, you can see the sub-commands which are as shown in the below image.

Click on the IMAP Get Email command, once you navigate to the Instruction Properties pop-up window, which contains the below details.

• IMAP Server Name: In this field, you need to insert the IMAP server name of your specific mailing domain whose emails you want to automate. Each email domain such as Yahoo, Hotmail, Gmail, etc, has its own IMAP server name.
• Port: Likewise, the server names each email domain as yahoo, Hotmail, Gmail, etc. has its own port. So, in the port field, you need to provide the port of the email domain whose emails you want to automate.
• SSL/TLS: Here, you need to select an option as SSL or TLS. This will indicate that the specific email domain is secured with SSL or not.
• Username: In this field, you need to insert the respective email id or username whose email you want to automate.
• Password: Here, insert the password for the specific email id.
• Select Message Option: Here, you can select what kind of email you want to automate either read, unread, or all.
• Select Message Format: In this field option, you need to provide as you want to read an email with text format or HTML, if you choose HTML here, you can simply read the email with newsletter or images as well.
• Filter by Subject: Here, enter an email subject, so that the tool will show you only the results with the respective email subjects. This email subject can be a sentence, reference code or id, a single word, etc.
• Email Datewise filter Options: This option helps you to filter emails according to the given date.
• Enter Date to filter/ Insert Variable: You can enter the date, which you wanted to filter or, click on the select file to create a variable to hold the given date.
• Save Attachment In: In this field, you need to input a path or location of a particular folder, in your computer system, where you want to save the attached files of the emails.
• Now enter all the details in the IMAP Get Email, instruction property window as shown below, and then click on Done.
  
  
• Now we have to print the email in the output message box, click on Show Message options under Miscellaneous Operations, which is as shown below.
  
  
• Once the Instruction properties pop-up window will open, click on Insert Variable. 
• Once you click on the Insert Variable, a pop-up window will open, which contains some predefined variables available in the dropdown list.
  
  • By using these commands you can simply create single or multiple options separately. 
    • From Email: this predefined variable provides you the name or email of the email sender.
    • To Email: This predefined variable helps you to get the email id of the receiver.
    • Email Subject: with this, you will get the email subject.
    •  Email Body: This predefined variable will help you print the email content.
    • Email Date Time: This predefined variable will help you to get the date and time of a particular email.
    • Attachment Path: With this, you will get the path or location of the file or folder within your computer system from where you want to attach a file to an email.
    • Attachment File: With this, you will get the attached file with an email. 
• Once done filling in all the required details and print the message using the “Show Message” property window, press the “Done” button.
• Now save the process by clicking on the “Save” button and run the program by pressing the “Run” button under the “Actions” tab
• Once you run the robot it will show you the required result in the sow message pop-up window.

Post Office Protocol (POP3) is an acronym for Post Office Protocol. It lets you utilize your email inbox like a post office, with emails being downloaded to your computer and then deleted from the mail server. When you use the POP3 protocol to access your emails, a copy of the emails is produced and saved locally on your computer.

• Similar to IMAP, the POP3 Get Email also helps to automate emails via a robotic process, but this POP3 allows users to read only “Unread” emails. To read an email with the POP3 Get Email method, select and click on the “POP3 Get Email” command option, which is listed under the “Email Automation”. See the image.
  
  Once you click on POP3 Get Email, the Instruction Properties pop-up window will open, enter all the required details and then click on Done.
  
  
• Here on the “POP3 Get Email” property screen, we have:
  • POP3 Server Name: In this field, you need to insert the POP3 server name of your specific mailing domain whose emails you want to automate. Each email domain such as Yahoo, Hotmail, Gmail, etc, has its own POP3 server name.
  • Port: Likewise, the server names each email domain as yahoo, Hotmail, Gmail, etc. has its own port. So, in the port field, you need to provide the port of the email domain whose emails you want to automate.
  • SSL/TLS: Here, you need to select an option as SSL or TLS. This will indicate that the specific email domain is secured with SSL or not.
  • Username: In this field, you need to insert the respective email id or username whose email you want to automate.
  • Password: Here, insert the password for the specific email id.
  • Select Message Format: In this field option, you need to provide as you want to read an email with text format or HTML, if you choose HTML here, you can simply read the email with newsletter or images as well.
  • Save Attachment In: In this field, you need to input a path or location of a particular folder, in your computer system, where you want to save the attached files of the emails.
    
  • Now save the code and go to the Actions tab and click on the Run
  • Once the robot runs successfully, the robot will show you all the unread emails in your mail inbox.

Simple Mail Transfer Protocol (SMTP) is an application used by mail servers to send, receive, and/or relay emails between senders and receivers. Let us see how to use Send SMPT Email command in DWmaker.

Click on the Send SMTP EMail command under Email automation, once the Instruction properties pop-up window will open, enter all the details and then click on Done.

The SMTP Instruction property window contains:

• Host Name: In this field, you need to insert the hostname of your specific mailing domain. Each email domain such as Yahoo, Hotmail, Gmail, etc, has its own host server name.
• Port: Likewise, the hostnames of each email domain as yahoo, Hotmail, Gmail, etc. have their own host server port. So, in the port field, you need to provide the port of the email domain whose emails you want to automate.
• Username: In this field, you need to insert the respective email id or username whose email you want to automate.
• Password: Here, insert the password for the specific email id.
• From Email: Here you need to insert the email address of the sender.
• To Email: In this field, you are required to insert the email address of an individual to whom you want to send a reply.
• Subject: Here, you need to insert the email subject.
• Body: In this field, you need to fill in the email content that you want to send in the reply.
• Attachment Path: In this field, you can add the location of the file that you add and send with the email.
• Enter all the details and then click on Done.

• Now, save the code and go to the Actions tab and click on Run.
• Once the robot runs successfully, the robot will send a replay to the given email.

The Outlook Get Email command is used to read the email from your outlook. Let us see how to perform this operation using the DWmaker automation tool.

Click on the Outlook Get Email command under Email Automation, once the Instruction Properties pop-up window will open, enter the details as shown below:

• Enter the Outlook email account id: enter your outlook email id here.
• Enter the folder name(Default is Inbox): enter your email folder name, here, by default it will take folder name as Inbox.
• Enter the subfolder name.
• Select Message format: click on the drop-down list and select the HTML/ Text
• Next, click on the Mark as Read drop-down list and select whether yes/no, if you select yes, then the messages it will going to read will be marked as read, or else this will skip your read emails.
• And then, click on the Read unread emails only drop-down and then select yes/no.
• Next, enter the subject name to filter the email via subject, here you need to mention the exact subject line.
•  Next, you have an email date wise filter option, which you can select from the below available options
  
• Next, enter the date to filter.
• Next, click on the Select File /Insert File and select the file path location to save the attachments in your local drive.
• Now click on Done.
  
• You can see an unread mail in my outlook inbox which is as shown below.
  
• Once you save the code, the automatic loop will be created which is as shown below.
  
• Now click on the Run button.
• The core will be run successfully.
• Now, go to the outlook and verify, the email will now be marked as read.
  
• This is how an outlook get email command helps users to perform tedious tasks.

The Send Outlook Email command is used to send an email to single or multiple recipients with attachments.

Let us see how to perform this automation using the DWmaker automation tool.

• Click on the Send Outlook email command under the Email Automation command.
• Once the Instruction Properties pop-up window will open, enter the details as shown below.
  • Enter the sender’s email address: Here you need to enter the outlook email address.
  • Enter the recipient email address, if you want to send to multiple recipients, then you can separate email id with a semicolon(;)
  • Next, you can enter the Cc, Bcc, subject line, and the Body of the email.
  • Next, select the email body type from the drop-down list.
  • Next, attach the files/documents if you have them, and then click on Done.
    
  • Now save the code and click on run.
  • Once the robot runs successfully, the email which you have written will be sent to the given recipient.
  • To verify, check with your recipient’s email.
    
  • This is how you can easily send emails to multiple recipients using Send outlook email command.

A text file is a separate Notepad file kept on our computer system in which we may store and preserve any line of data (single or many). These text files can include data such as numbers, non-executable files including letters, symbols, and a combination of letters and numbers, and non-executable files containing letters, symbols, and a combination of letters and numbers. It allows you to create and save text files without any particular formatting, and these files may be saved using (.txt extension).

We can perform Read text files and Write text files operations using the DWmaker automation tool.

• The Write Text File is used to write the text in the given text file. Click on the Write Text File command under Text File Operation.
• Now the “Write Text File” property window will ask you to provide some details in the respective fields. Where, in the first field, you need to provide the file path or a file name in which you want to write some text. While in the second field you need to provide the text that you want to write in a file, and in the third field, you are requested to select a particular option as “Append” or “Overwrite”. Here;
  • Append The new text that you want to write in a file. “Append” also keeps the previous text of the file as well and shows the result with the old text of the file along with the newly added text as well.
  • Overwrite: If you select the overwrite option, then it will remove the old text and show results only for the new text.
• Once the Instruction Properties pop-up window will open,
  • Indicate the file path location
  • Indicate the text to be written
  • Select the overwrite option
  • And then click on Done.
    
  • Now, save the code and go to the Actions tab and then click on Run.
  • Once the robot runs successfully, the given text will be written in the text file.
    

    In the same way, if you select overwrite option, the current text will be replaced with the new text.
    

  • Save the code and Run, the old text will be replaced with the new one.
    

• The read text file is used to read the given text file. Click on the Read Text File under the Text File Operations, which is as shown below.
  
  Once you click on Read Text File, An Instruction Properties pop-up window will open, click on Select File, and enter the file path location and then predefine a variable where the test file is present.
  
• Now, click on Show Message under Miscellaneous Operations, once the Instruction Properties window will open enter, a pre-defined variable name, and then click on Done.
  

• Now, save the code and then go to the Actions tab and click on Run.

• Once the robot runs successfully, the text which is present in the text file will be displayed on the output Message Box.
  

• The Write Text File is used to write the text in the given text file. Click on the Write Text File command under Text File Operation.
• Now the “Write Text File” property window will ask you to provide some details in the respective fields. Where, in the first field, you need to provide the file path or a file name in which you want to write some text. While in the second field you need to provide the text that you want to write in a file, and in the third field, you are requested to select a particular option as “Append” or “Overwrite”. Here;
  • Append The new text that you want to write in a file. “Append” also keeps the previous text of the file as well and shows the result with the old text of the file along with the newly added text as well.
  • Overwrite: If you select the overwrite option, then it will remove the old text and show results only for the new text.
• Once the Instruction Properties pop-up window will open,
  • Indicate the file path location
  • Indicate the text to be written
  • Select the overwrite option
  • And then click on Done.
    
  • Now, save the code and go to the Actions tab and then click on Run.
  • Once the robot runs successfully, the given text will be written in the text file.
    

    In the same way, if you select overwrite option, the current text will be replaced with the new text.
    

  • Save the code and Run, the old text will be replaced with the new one.
    

A file is an abstract datatype. To correctly define a file, we must examine the actions that may be performed on it. File operation is the process of accessing the file within a computer system, a user can perform many operations in a file as create, delete, download, read, rename a file or so much. To perform such operations with a robotic automation process we have multiple command options in our DWmaker.

DWmaker is associated with the below commands to perform automation operations such as:

Check Path Exists:

• The Check Path Exists command helps us to verify whether the file path exists or not.
• Open Dwmaker and click on Check Path Exists under File Operations.
  
• Once the Instruction Property pop-up window will open, enter,
  • File path location
  • Insert a pre-defined variable name to hold the file path
  • Next, we have to display the output in the output message box, if the given path exists then the robot will return True else return False.
  • Click on the Show Message option under Miscellaneous Operations, once the Instruction properties pop-up window will open, enter pre-defined variable name inside the square bracket as shown below.
    
  • Now save the code and, go to the Actions tab and click on Run.
  • Once the robot runs successfully, the result will be displayed on the output message box.
    
  • I will change the file path location, and execute the code.
    
  • Now, save the code and run.
  • The output is as shown below.
    
  • This is how we can check whether the given file path exists or not using simple automation steps.

• The Create File command helps us to create a new file in the given location.
• Let us see, what are the steps involved in this process.
• Our first step is to click on Create File command under File Operations.
• Once the Instruction Properties pop-up window will open, enter,
  • Folder path location to create a file.
  • Enter the file name with extension
  • Click on Done.
    

The create Folder command helps us to create a folder in the given location. Let us see what are steps need to be followed.

• Open DWaker and click on Create Folder under File Operation.
• Once the InstructionProperties pop-up window will open, enter
  • Indicate the path to create a folder then click on Done.
    

  • Now, save the code and go to the Actions tab and then click on Run.

  • Once the robot runs successfully, the new folder has been created in the given location.
    

  • This is how you can create a new folder using the DWmaker automation tool.

The Download File command helps us to download the given file.

• Indicate the path of the source file URL: In this field, you need to insert the specific location or web URL of the file that you want to download.
• Indicate the download file directory path: Here, you need to insert a particular location of a directory or folder of your system, where you want to keep the downloaded file.
• Indicate the download file name with extension: Here, insert a unique name with which you want to save the file along with an extension such as “.txt”, “.pdf”, “.png”, etc, of a file that you are downloading.
• Select the variable to receive the download status: Here, insert a variable name in which you want to get the result.

• Click on the Download File command under File Operations, once the Instruction Properties pop-up window will open, enter,

  • Indicate the source file path
  • Indicate the download file directory path
  • Indicate the download file name with extension
  • Select the variable to receive the download status.
  • Next, click on Done.
    

  • Now save the code and go to the Actions tab and click on Run.

    Once the robot runs successfully, the file will be downloaded to the given location. Which is as shown below.
    

  • This is how we can easily download any file in the given location using the DWmaker automation tool.

The Delete File command is used to delete files in the given folder.

• Click on the Delete File command under File Operation, once the Instruction Properties Pop-up window will open, enter the file path location and then click on Done.
  

• Save the code and go to the Actions tab and then click on Run.

• Once the Robot runs successfully, the given file will be deleted.

The File Change Triggers helps Either in private or nonprivate firms, sometimes individuals are required to work by sharing their PCs where they have to get in knowledge if there is any new activity that has been done in their system such as creating or deleting any particular file, etc.

So, to get such updates using the DWmaker, select and click on the “File Change Trigger” option listed under the “File Operation” command. See the image.

• Now, the File Change Trigger property window will ask you to insert some details in it, where:
  • Enter the folder path containing files: Here, provide the directory/folder path of a file in your computer that you want to monitor.
  • Enter the file name to monitor: Here, enter the name of a specific file/folder that you want to monitor. Also, make sure to insert a file name followed by a wildcard operation such as *. For example, (Filename*). Such operations indicate that the file name will start with specific text and are also allowed to read any files like doc file, notepad file, given to the case-sensitive Documentation, etc.
  • Select file change type: Here, a few different options are listed in a dropdown, you can choose one as per your need.
  • All: Selecting this option you will update each activity that has been done in the particular file/folder.
  • Created: This option will update you only if a new file has been created.
  • Deleted: This option will update you only if any file will be deleted from the directory.
  • Changed: This option will update you only if something has been changed in the file.
  • Renamed: This option will only update you if a file goes renamed.
  • Enter the variable name to receive monitoring results: Here, provide a variable name in which you want to get the updates.
    
  • Next, click on the Show Message command under Miscellaneous Operations, and enter the predefined variable name under the insert variable.
    
  • Now, save the code and go to the Actions tab and then click on Run.
  • Once the robot runs successfully, if you make any changes to the given file, you will get a notification in the output message box.
    

• The Move/Copy file helps to move your file from one place to another file or copy file from one file to another place.
• Click on Move/Copy file under File Operation as shown below
  
  
• Once the Instruction Property window will open, enter the below details as shown in the below image and click on done.
  

• Next, save the code and go to the Actions tab and then click on Run.

• Once the robot runs successfully, the given has been moved to the given location.
  

• This is how we can easily move or copy files from one location to another location using the DWmaker automation tool.

The Read folder command is used to read a given folder. To read a folder, using the DWmaker tool, first, we need to create a data table instance because the robot requires a virtual data table to return the list of files contained in a folder in the form of a well-managed table with including the file name, file size, and date of a file created.

• To create a data table instance, click on the Assign Data Table, under the Data Table Automation command, which is as shown below.
  

• Once the Instruction Properties, a pop-up window will open, enter all the required details and click on Done.
  

• Next, click on the Read Folder command under File Operation and enter all the details and then click on Done.
  

• Next, click on the Preview Data Table under Data Table Automation and enter the required details.
  
• Next, Save the code and go to the Actions tab and click on Run.
• Once the robot runs successfully, the preview data table will be printed as shown below.
  

The Rename File command is used to Rename or Change the name of a particular file using DWmaker automation. Click on the Rename File option under file operation, which is as shown below.

Once the Instruction Properties, a pop-up window will open, enter the required details as shown in the below image.
 

Next, click on Save and then go to the Actions tab and then click on Run.

Once the robot runs successfully, the file name will be changed to the given name.

The Zip/Unzip command is used to zip/unzip the given file. First will see how to zip a given file.

How to Zip File:

• Click on Zip file, under File Operation, once the Instruction Properties pop-up window will open, enter a file path to zip a file and then enter the file path to save the zipped file.
• And, then click on Done.
  
• Now, Save the code and then, go to the Actions tab and click on Done.
• Once the robot runs successfully, the given has been saved in the given location as a zipped file.
  

• The Unzips file is used to unzip the given file.
• Click on Unzip a File command under File Operation, once the Instruction Properties pop-up window will open, enter the file path location of the zip file and then enter the file path to extract the zipped file.
• And, then click on Done.
• Now save and code and go to the Actions tab and then click on Done.
  
• Once the robot runs successfully, the zipped file has been extracted in the given file location as shown below.
  
• Once the robot runs successfully, the zipped file has been extracted in the given file location as shown below.

The Wait for File is a signal-in activity that checks for file creation, modification, or deletion events during the process execution. The process instance suspends and waits for the specified change to occur before resuming when this activity is completed.

For example, whenever we open or download a file on the webserver then sometimes it may take a few times to open that particular file. This file loading time just depends on the size of that file.

While if a file is not available on the PC then it will not get opened by the robotic automation process. In such cases, we provide a specific time to the robot to check the computer system and then open it in the given time interval if it exists in the PC.

To use this operation in DWmaker, first, click on the Wait for File option under the File Operation command, which is shown below.

Once, the Instruction Properties pop-up window will open, enter, required details, and then click on Done.

• Now save the code and go to the Actions tab and click on Run.
• Once the robot runs successfully, the given file will open after the given time of interval.

Document Automation works by pulling data and text from a variety of sources and inserting them into predefined areas of document templates (Word file).

Document Automation in DWmaker

Document Automation is actually a process to create and add required text formatting in a word document file using the robotic process. DWmaker tool has a list of multiple commands, to assist a user in regards to make any kind of required edits in the document file. This command mentions the following.

• Create a document
• Read and write a document
• Append Document data and more.

The Read Document command is used to read given documents using the DWmaker automation tool.

Let us see what are the steps present in this process.

• First, click on the Read Document command under Document Automation. Once the Instruction Properties pop-up window will open, enter the file path location and then enter the user variable name to receive the extracted data.
  
• Next, click on the Show Message command under Miscellaneous Operations, once the Instruction Properties pop-up window will open, enter the variable name in the square bracket[] and then click on Done.
  
• Next, save the code and then go to the Actions tab and then click on Run.
• Once the robot runs successfully, the content which is present in the given document will be displayed on the output message box

The write document command is used to write the content into the given document.

• Under the Document Automation command, you can see a list of sub-command available.
• From here, you need to select the Create Document Application command option, because, in order to write in a document file, first we need to create an instance for the document.
• Enter the Instance Name and then click on Done. Which is as shown below.
  
  
• Next, to write into the document, click on the Write Document command under Documentation Automation.
• Once the Instruction Properties pop-up window will open, enter
  • The content Name
  • Enter the Content
  • Select Alignment
    
  • Here, you can enter any number of content like a single word, a line of code, or a paragraph, etc.
  • Next, we need to save this document, click on the Save Document command under Documentation Automation.
  • Once the Instruction Properties pop-up window will open, enter
    • The Instance name
    • And, select the file path to save the document.
    • And then, click on Done.
      
    • Here, you can enter any number of content like a single word, a line of code, or a paragraph, etc.
    • Next, we need to save this document, click on the Save Document command under Documentation Automation.
    • Once the Instruction Properties pop-up window will open, enter
      • The Instance name
      • And, select the file path to save the document.
      • And then, click on Done.
    • Now, save the code and then go to the Actions tab and then click on Run.
    • Once the robot runs successfully, the document has been created with the given content.
      
    • This is how you can write into the document using DWmaker.

The Append Paragraph is used to append the current document with the new content. The append command will add new content to the document without replacing the old content.

• Here, first, we need to create an Instance to append the document.
• Click on the Create Document Application command under the Documentation Automation.
• Once the Instruction Properties pop-up window will open, enter,
  • The Instance Name and then click on Done.
    

  • Next, We need to load the document to which we want to append the content.

  • Click on the Load Document command under the Document Automation, which is as shown below.
    
    

  • Next, click on the Append Paragraph command under Documentation Automation and enter the required fields. 
  • 
  • Next, we need to save the document by clicking on Save Document under Documentation Automation and enter the instance name and enter the file path location and then click on Done.
    
  • Now, Save the code and then go to the Actions tab and then click on Run.
  • Once the robot runs successfully, the document has been appended with the given content.
  • Now, go to the document and open it, you can see the appended document, which is as shown below.
    
  • Next, we need to save the document by clicking on Save Document under Documentation Automation and enter the instance name and enter the file path location and then click on Done.
    
  • Now, Save the code and then go to the Actions tab and then click on Run.
  • Once the robot runs successfully, the document has been appended with the given content.
  • Now, go to the document and open it, you can see the appended document, which is as shown below.
    

The Close Document command is used to close the opened documents at the given location. Whenever you are creating an instance in a Document Automation process, then it is required to close it every time. You can close it simply by accessing the Close Document command option. 

• Click on the Close Document command under Document automation.
• Once the Instruction Properties pop-up window will open, enter
  • The Instance name and then, click on Done.
    
    

The Find and Replace Text command is used to replace the text in the given content.

First, we need to create an instance of the document, click on the Create Document Application.

Once the Instruction Properties pop-up window will open, enter an instance name and then click on Done.

• Next, we need to load the document, in which you want to search and replace the text.
• Click on the Load Document command and enter the file path location and then click on Done.
  
  
• Next, click on Find and Replace Text command under the Documentation Automation.
  • Enter the instance name: Provide the instance name in the field. 
  • Enter the text to be searched: Here insert the text that you want to search in the document.
  • Enter the text to be replaced: In this field, insert the new word that you want to replace with the old word.Once the Instruction Properties pop-up window will open, enter the following details:
  • Is search text case sensitive: Here, either select “Yes” or “No” for the case sensitivity of the search term. If you select “Yes” then the robot will find and replace only the word/search term followed by the respective case-sensitive formatting within the document. While, if you choose, “No” then the robot will find and replace the respective word/search term in any particular text formatting in the entire document.
    
    
  • Next, click on the Save Document command under the Documentation Automation.
  • Once the Instruction Properties pop-up window will open, enter,
    • Instance Name.
    • File path location to save the and current has new. file.
    • Click on Done.
      
    • Now, save the code and then go to the Actions tab and click on the Run.
    • Once the Robot runs successfully, the New document has been created and the current text will be replaced with the given text. Which is as shown below.
      
      
    • Now, save the code and then go to the Actions tab and click on the Run.
    • Once the Robot runs successfully, the New document has been created and the current text will be replaced with the given text. Which is as shown below.

The Merge Document command is used to merge two documents into one document. Click on the Create Document Application under Document Automation.

Once the Instruction Properties pop-up window will open, enter the  Instance name and then click on Done.

• Next, click on Load Document under Documentation Automation, once the Instruction Properties pop-up window will open, enter the instance name and then enter the file path location.
  
• Next, Save the code and then go to the Actions tab and then click on Run.
• Once the Robot runs successfully, the given documents have been merged into a single doc.

The Create Table With Data command is used to create a table in the word document using the data. 

• First, we need to create an Instance, click on the Create Document Application.
• Once the Instruction Properties pop-up window will open, enter all the details and then click on Done.
  
  
• Next, we need to load the document, in which you want to create a table.
• Click on the Load Document command under the Document Automation, once the Instruction Properties pop-up window will open, enter, Instance name and file name and then click on Done.
  
• Next, click on the Assign Data Table Instance under DataTable Automation.
  
  
• Next, click on Create Excel Data Table under Excel Automation, once the Instruction Properties pop-up window will open, enter
  • • The data table name.
    • Select the file path location, in which excel file you want to extract the data table.
    • Enter the Sheet
    • And then click on Done.
      
    • Next, click on Create Data Table with Data under the Documentation Automation, Once the Instruction Properties pop-up window will open.
      • Enter Instance name
      • Enter the Data table name to get the data
      • Select the Header vertical alignment, by default which is selected as Middle.
      • Select the Header horizontal alignment, by default which is selected as Center
      • Enter the Hight of the header row, by default which is selected as 20.
      • Select the font name of the header text
      • Select the font size of the header text
      • Enter the header text color name
      • Enter the header back color name
      • Enter the data text color name
      • Select the data row vertical alignment
      • Select the data row horizontal alignment
      • Enter the height of the data row
      • Select the font size of the data text
      • Enter the height of the data row
      • Specify the source of the column name: Here, specify the Table column name as F1, F2,F3..etc. and Header column as your choice which related to the table items which is as shown below:
        
      • Next, click on the Done as shown below.

  

• Next, click on the Save Document command, Once the Instruction Properties pop-up window will open, enter the Instance name and the file path location in which you want to save the table.
  
• Now, save the code and then go to the Actions tab and then click on Run.
• Once the robot runs successfully, the table has been created with the given data
  

The Add Blank Row/Column command is used to add a row/ column to the existing table in the given document.

Let us see what are the steps present in this process:

• Click on the Create Document Application command under Document Automation.
• Once, the Instruction Properties pop-up window will open, enter the Instance name and then click on Done.
  
• Next, click on the Load Document command, once the Instruction Properties pop-up window will open, enter the instance name and file name and then click on Done.
  
•  Next, click on Add Blank Row/Column command under Document Automation, once, Instruction Properties pop-up window will open, enter,
  • The Instance Name
  • The index number of the Table(The Index number of the table will always start from 0)
  • Select the Row/Column from the dropdown
  • Enter the number of rows, This field is required only to enter rows.
  • Enter the row or column index number where you want to add the new row/column
    
  • Next, click on the Save Document command, once the Instruction Properties pop-up window will open, enter the Instance name and file name and then click on Done.
    
  • Now save the code and then go to the Actions tab and then click on Run.
  • Once the robot runs successfully, the column has been added at the 2nd position.
    
  • In the same way, we can add a blank row to the table at the given location.
  • Click on the Add Blank Row/Column, once the Instruction properties pop-up window will open, enter, all the details and then select the Row from the drop-down list and then enter the number of rows you wanted to add to the table and then select the index number where you wanted to add row or column in the table.
    
  • Now, save the code and run the robot.
  • Once the robot runs successfully, the blank row has been added to the table at the given index position.
    
  • As you see in the above image, the two blank rows have been added after the index position.
  • This is how we add rows or columns to the given table using the Dwmaker automation commands.

The Add Table Cells command is used to add the column with data to the existing table which is present in the word document.

Let us see what are the steps present in the  Adding table cells.

• Our first step is to click on the Create Document Application command under Document Automation, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
  
• Next, click on the Load Document command, once the Instruction Properties pop-up window will open, enter the Instance name and Select the file path to load, and then click on Done.
  
• Next, next we need to assign a data table instance to create a data table.
• Click on the Assign Data Table Instance under the Data Table Automation command.
• Once the Instruction Properties pop-up window will open, enter
  • The Data Table Name
  • The Instance Name
  • And then click on Done.
    
  • Next, click on the Create Excel Data Table command under excel automation, once, the Instruction Properties pop-up window will open, enter,
    • Instance Name
    • Select the file path location
    • Sheet name
    • Click on Done.
      
  • Next, click on the Add Table Cells, once the Instruction Properties pop-up window will open, enter all the required details and then click on Done.
    
  • Next, click on the Save Document command under the Document Automation, once the Instruction Properties pop-up window will open, enter the instance name and select the file path to save the table and then click on Done.
    
  • Now, click on Save and then go to the Actions tab and click on Run.
    
  • Once the robot runs successfully, the new column will be added to the table.
    

The Add Table Row command is used to add Row to the existing table with data.

Let us see the steps present in this automation process.

• First, click on the Create Document Application command under Document Automation, once the Instruction Properties pop-up window will open, enter the Instance name and then click on Done.
  
• Next, click on the Load Document command, once the Instruction Properties pop-up window will open, enter the instance name, and then select the file to load, and then click on Done.
  
• Next, click on the Assign Data Table command, once the Instruction Properties pop-up window will open, enter the data table name and then instance name, and then click on Done.
  
• Next, click on create Excel Data Table command, once the Instruction Properties pop-up window will open, enter the data table name, file path location, and then sheet name.
• And, click on Done.
  
• Click on Add Table Row, once the Instruction Properties pop-up window will open, enter all the details required and then click on Done.
  
• Next, click on Save Document, once the Instruction Properties pop-up window will open enter the Instance name and the file name to save and then click on Done.
  
• Now save the code and then go to the Actions tab and click on Run.
• Once the Robot runs successfully, the new rows have been added to the table.
  

The Format Text command is used to format the text in the given document.

The Format Text command has options to bold, italic, and you can also highlight the background of the given text and you can also highlight the color of the text.

Let us see what are the steps present in this process.

• First, click on the Create Document Application command under the Document Automation command, once the instruction properties pop-up window will open, enter the Instance name and then click on Done.
  
• Next, click on the Load Document command under the Document Automation, once the Instruction Properties pop-up window will open, enter the instance name and then select the file path location and then click on Done.
  
• Next, click on the Format Text command under the Document Automation, Once the Instruction Properties pop-up window will open, enter, Instance name and the text to format.
  
• Next, click on the Save Document command under Document Automation, once the Instruction Properties pop-up window will open, instance name and select file path location to save the file.
  
• Now, save the code and then go to the Actions tab and then click on Run.
• Once the robot runs successfully, the given text will be format as per the given standards.
  

The Delete Table Row/Column command is used to delete the given table row or column.

Let us see what are the steps present in this process. 

• Our First step is to click on Create Document Application command under Document Automation.
• Once the Instruction Properties pop-up window will open, enter the Instance name and then click on Done. 
  
• Next, click on the Load Document command under Document Automation, once the Instruction Properties pop-up window will open, enter,
  
• Next, click on Delete Table Row or Column command under Document Automation, once the Instruction Properties pop-up window will open, enter all the required details which are as shown in the below image.
  
• Now save the code and then go to the Actions tab and click on Run.
• Once the robot runs successfully, the row will be deleted from the given table.
  Next, let us see how to delete a column from the given table.
• In the Delete Table Row or Column command, select Row under Select Detection Type.
  
• Now save the code and run.
• Once the robot runs successfully the given table column will be deleted.
  

The Delete Table command is used to delete the existing table in the given document.

• First, click on the Create Document Application command under the Document Automation.
• Once the Instruction Properties pop-up window will open, enter the Instance name and then click on Done.
  
• Next, click on the Load Document command, once the Instruction Properties pop-up window will open, enter the instance name and then select file path location and then click on Done.
  
• Next, click on the Delete Table command, once the Instruction Properties pop-up window will open, enter the instance name and then enter the Index number of the table you want to delete.
  
• Next, click on the Save Document, once the Instruction Properties pop-up window will open, enter the Instance name and then enter the file path location to save the change.
  
• Now save the code and run, once the robot runs successfully, the table will be deleted from the given document.

The Merge Row/Column command is used to merge either row cells or column cells as given.

• Click on the Create Document Application under Document Automation.
• Once the Instruction Properties pop-up window will open, enter current the Instance name and then click on Done.
  
• Next, click on Load Document under Documentation Automation, once the Instruction Properties pop-up window will open, enter the instance name and then enter the file path location.
  
  
• Next,  click on the Merge Row/Column command under Document Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • The index number of the table
  • Select the Merge type from the drop-down list
  • Enter row or column index number
  • Enter the strat cell index
    
  • Enter the end cell index
  • And then click on Done.
    
  • Next click on the Save Document command, once the Instruction Properties pop-up window will open, enter the Instance name and then the file name to receive the file.
    
  • Next, Save the code and then go to the Actions tab and then click on Run.
  • Once the Robot runs successfully, the Given row cells have been merged, which is as shown below.
    
    
  • In the same way, we can merge the column also, select Column under Select Merge Type, and enter the Index number of the column and enter the start cell and end cell number of the column and then click on Done.
    
  • Now, save the code and run, once the robot runs successfully, the given column range will be merged, which is as shown below.
    
  • This is how we can merge either row or column cells as we required.

The SEt Table Cell command is used to set the value in the given table cell. This command is useful to add values inside the blank table row or column cells.

If we performed this operation on any table cell which is already having a value in it, then, it will append the value to the given cell.

Let us see what are the steps present in this operation.

• Click on the Create Document Application under Document Automation.
• Once the Instruction Properties pop-up window will open, enter current the Instance name and then click on Done.
  
  
• Next, click on Load Document under Documentation Automation, once the Instruction Properties pop-up window will open, enter the instance name and then enter the file path location.
  
  
• Next,  click on the Set Table Cell command under Document Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Table index number
  • Row Index number
  • Column Index number
    
  • Enter the Text to set in the Cell
  • Enter the cell text color name
  • Enter the cell back color name
  • And then click on Done.
    
  • Next click on the Save Document command, once the Instruction Properties pop-up window will open, enter the Instance name and then the file name to receive the file.
    
  • Next, Save the code and then go to the Actions tab and then click on Run.
  • Once the Robot runs successfully, the given text has been added to the blank cell, which is as shown below.
    
  • In the same way, if give index value of the cell which is having text in it, then this command will append the cell with the given text, which is as shown below.
    
  • This is how we can put text, or append text in the given table cell.

Web automation refers to the process of allowing robots or web automation technologies to conduct activities and processes on an online browser or web application. Browser automation technologies, which automate your Web browser, are used to do repetitive and error-prone activities, such as filling out long HTML forms for any specific purpose such as online inquiry form, admission form, contact form filling, etc.

Web Browser Automation in DWmaker:

The Process Bot DWmaker tool has an inbuilt web browser automation set-up or commands along with a package of a few sub-commands, such as create a browser, element action, close browser, script execution, and much more, that help us to automate the web browser activities with a robotic process. 

Let us see how to use Web Browser Commands to perform Web Browser Automation using the DWmaker tool.

The Create Browser command is used to perform browser operations. It is having several browser engines, you can create a browser by using any of the given browser engines.

• Click on the Create Browser command under Web Browser Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance Name: Insert the instance name that you have created for this operation.
  • Browser Engine Type: Here, you need to insert the version of your web browser. (Either you are using Chrome, Firefox, or any other web browser, each browser has its different version that you need to insert in this field.)
  • Instance Tracking: In this field, you need to select one option as “Forget Instance” or “Keep Instance Alive”. If you choose “Forget Instance,” then your instance will be no longer available once the program is closed or completed. While, if you choose, “Keep Instance Alive,” that means your instance will be available every time, once created. 
  • Select a Window State: In this field, you can select a specific view for the window, as “Minimize” or “Normal”.
  • Once providing all the required details, click on Done. 
    
• Next, click on the Navigate to URL command under Web Browser Automation, once the Instruction Properties pop-up window will open, enter,
  • Instance name
  • Enter the URL to navigate to
  • And then, click on Done.
    
  • Next, click on the Element Action command, which is used to create a web action on the given URL.
  • Once the Instruction Properties pop-up window will open, enter,
    • Instance Name: Insert the instance name that you have created for this operation.
    • Element Search Method: In this field, you need to select an element search method, from the drop-down list. The search method you will select is just deepened on the enabled search element in the respective website that you are operating. This search method can be an ID, Name, XPath, etc. You can get the search method of the specific website, simply by inspecting the input field. 
    • Search Parameter: Here, provide a specific parameter or value for the search such as username, email, contact, etc. You need to enter the search parameter, similar to the one mentioned on the website, that you can get easily by inspecting it. See the image.
    • Note: In Create browser, The Chrome will be installed in the 64 bit location by default C:\Program Files (x86)\ folder will continue to work and if it does find the 64 bit chrom file path then the error will occur.
    • You may get an error if you are using 32 bit, so We recomend you to use attach Browser command instead of Create browsera nd Navigate URL command, this commnd performs actions which performed by create browser and Navigate URL command.
    • Click on the Attach Browser command, once you navigate to the Instruction Properties pop-up window, then enter the deatils as shown in the below image.
      
    • And, keep other deatials as deafult values only as shown below.
      
    • Go to your given URL website and then click on the element that you wanted to inspesct, in this example I want to Navigate to the Intelic’s Contacts webpage which is as shown below:
      
    • Here, I wnat to automate the contact details autofillup which is as shown above.
    • So, keep your mouse on the Name and then right click, and select the Inspect option, and then click on Inspect.
      
      
    •  Next, you will be navigated to the HTML page and then find the ID of the Name which is as shown below.
    • And, repeate this step for all the elements on the  contact deatils like, Email, Conatct Number and Message.
    • 
  • Element Action: Once you click on the drop-down list, The Element action field is having several sub-options, you can select from this drop-down, what action you want to perform.
    • If you want to fill any form then you can select Set Text.
      
  • Additional Parameter: Here, you need to enter the Parameter text name and parameter value.
    
  • Click on Done.
  • Now, save the code and then go to the Actions tab and click on Run.
    
  • Here, I am filling in contact details on the Intelgic website.
  • Once the robot runs successfully, the robot will take you to the given URL and then enter the Name in the Name section, which is as shown below.
    
  • Next, to enter the Email and Contact number, Click on the Element Action command, once the Instruction properties pop-up window will open, enter the Instance name and enter the element search method.
  • And, then, enter the element search parameter.
  • To add an element parameter, right-click on the Email on the Intelgic website and select Inspect.
    
  • Once the element window will open, copy the id of the email
    
  • Copy the element id of email and then paste it in the DWmaker tools under Element Search Parameter, which is as shown below.
    
  • Next, click on Done.
  • Enter the element text as Set Text.
  • And then go to the Additional Parameters and enter your mail id in the Parameter Value.
    n
  • Repeat the same steps to add Contact and Message details.
  • Next click on the Close Browser command under Web Browser Automation, once the Instruction Properties pop-up window will open, enter the instance name and then click on the Done.
    
  • Now save the code and then run the robot.
  • Once the robot runs successfully, the given details will be added to the website and immediately the browser will be closed.
    

The Navigate Back command is used to move back to its previous location in the web browser.

In the same way, the Navigate Forward command is used to move forward to the given URL.

• Let us see what are the steps present in this operation.
• Here, first, we need to create a browser, so click on Create Browser command under Web Browser Automation, once the Instruction Properties pop-up window will open, enter all the required details and then click on Done.
  
• Next, click on the Navigate to URL command, once the Instruction Properties pop-up window will open, enter,
  • The instance name
  • Enter the URL and then click on Done.
     
  • Next, click on the Navigate to Forward command, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
    
  • Next click on the Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
    
  • Next, click on the Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
    
  • Next, click on Navigate to Back command once the Instruction Properties pop-up window will open, enter, instance name and then click on Done.
    
  • Now, save the code and then go to the Actions tab and click on Run.
  • Once the robot runs successfully, the given URL window will open and then get back to the previous web page.
    

The Refresh command is used to reload the current web page window. Let us see how to perform this operation using the DWmkaer automation tool.

Click on Create Browser command, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.

Next, click on Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and URL to navigate and then click on Done.

Next, click on the Refresh command, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.

Now save the code and go to the Actions tab, and then click on Run.

Once the robot runs successfully, the given web page window will be refreshed.

The Execute Script command is used to execute JSON, Javascript code in the context of the currently selected window.

The first step here is to create a browser.

• Click on the Create Window command, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
  
• Next, click on Navigate URL, once the Instruction Properties pop-up window, enter the Instance name and URL that you want to open, and then click on Done.
  
• Next, click on Execute Script command, once you navigate to the Intriction Properties pop-up window, enter instance name, enter script code and then click on Done.
  
• Now save the code and then go to the Actions tab and click on Run.
• Once the robot runs successfully, the given script will be executed in the selected window.

The Get Browser Info command is used to get the information of the given browser based on a given property such as Window Title, Window URL, Current Handle ID, HTML Page Source, Handle ID List.

Let us see how to perform this operation using the DWmaker automation tool.

• Click on the Create Browser command, once the Instruction properties pop-up window will open, enter the instance name and then click on Done.
  
• Next click on the Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and URL of the browser that you want to get the information and then click on Done.
  
• Next, click on the Get Browser Info command, once the Instruction Properties pop-up window will open, enter the instance name and then enter the instance name.
• Next click on the Indicate Which Info Property to Retrieve  drop-down list and select which one you want to get the information.
• If you select the Window URL, you will the complete URL of the given browser window.
• If you select the window Title, then you will the tile of the given browser window.
• Next, enter the variable to receive the property information and then click on Done.
  
• Next, click on the Show Message command under Miscellaneous Operation, once the Instruction Properties pop-up window will open, enter the variable name and then click on Done.
  
• Now, save the code and then run, once the robot will run successfully, the information will be displayed on the output message box based on the selected property.
  
• If I select the window title and run the code, then the window title will be displayed on the output message box.
  
• If you select the HTML Page Source, then the output will be as below
  
• This is how we can get the information about the given browser window.

The Switch Browser Window command is used to switch to the given browser window when you have opened multiple windows in your system.

Let us see how to perform this operation.

• Click on Create Browser Command, once the pop-up window will open, enter the instance name and then click on Done.
  
• Next, click on Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and URL that you want to navigate and then click on Done.
  
• In this operation, we have to create multiple browsers each with different instances.
• I am creating three browsers with three different instances.
• Click on Create Browser Command, once the pop-up window will open, enter the instance name and then click on Done.
  
• Next, click on Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and URL that you want to navigate and then click on Done.
  
• Click on Create Browser Command, once the pop-up window will open, enter the instance name and then click on Done.
  
• Next, click on Navigate to URL command, once the Instruction Properties pop-up window will open, enter the instance name and URL that you want to navigate and then click on Done.
  
• Next, click on the  Switch Browser Window command, once the Instruction Properties pop-up window will open, enter the
  • Instance name
  • Click on the select the type of match to make a drop-down and select Either Window URL, Window Hanle Id, or Window Title.
  • Click on the please define a match specification drop-down and select the either Contains Match or Exact Match option.
• Ans, click on Indicate if the search is case sensitive drop-down and select Either Yes/No.
• If you select Yes, then you have to give the complete URL of the website that you want to switch to the browser window.
• Next, enter the URL and then click on Done.
  
• Now, save the code and run, once the robot runs successfully, the given browser window will be open and the robot switched to the URL which you have given in the switch URL property window.

The Switch Browser Frame command is used to switch to the current frame in the browser window.

Where the frame is a component of a web page or browser window that shows content independently of its container and may load content independently in the context of a web browser.
Let us see how to switch to the select frame by using the DWmkaer automation tool.

• First click on the Create Browser, once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
  
• Next click on the Navigate URL command, once the Instruction Properties pop-up window will open, enter the instance name and then the URL, and then click on Done.
  
• Next click on the Switch Browser Frame command, once the Instruction Properties pop-up window will open, enter the instance name, select the frame to find by type by clicking on the drop-down.
• Next, enter the index number or ID, or Frame name.
• And then select the switch to option by clicking on the Insert variable drop-down list.
• And then click on Done.
  
• Now, save the code and then click on run, once the robot runs successfully, the robot will be switched to the given frame of the web browser.

What is Data Table:

The data table is one of the most fundamental components of business intelligence. It consists of a sequence of columns and rows that intersect in cells, as well as a header row that states the names of the columns, to make the table’s information intelligible to the end-user. A tabular report is a name for this sort of table in BI. A tabular report is primarily but not exclusively used to keep track of data.

Data tables are the most fundamental and yet one of the most valuable components of BI.

Data Table Automation:

A data table is a structured set of data that is held in an excel sheet, database, etc., while data table automation is a process to manage all the data table activities (table creation, read the table, merge table, fetch table data, and so forth ) robotically.

Data Table Automation in DWmaker:

DWmaker is a robotic process automation tool that allows users to manage and automate all their data table management tasks. The tool is integrated with a number of data table automation commands in order to operate a number of data table operations. The data table automation command of the DWmaker tool holds a few more sub-command options such as:

• Create Data
• Read data
• Filter Data
• Merge Data
• Append Data and etc… 

The Create Data Table command is used to create a blank data table. Let us see what are the steps present in this automation process.

• Click on the Assign  Data Table command under Data Table Automation, once the Instruction Properties pop-up window will open enter the data table name and data table instance and then click on Done.
  
• Next click on the Create Data Table command, once the Instruction Properties pop-up window will open, enter the data table name to be created and then enter the column name and select the data type, which is as shown below.
  
• Next, click on the Preview Data Table, once the Instruction Properties pop-up window will open enter the instance name and then click on Done.
  
• Next, save the code and then click on run, once the robot runs successfully, the preview data table with column name will be displayed on the output message box.
  
• So, the data table has been created with the given column names as shown above.

The Append Data Table command is used to add the content to the data table. We can also add content to the blank data table, which keeps the current data and adds new data to the data table.

The First step here is we need to Assign a data table instance and create a data table and then we can append data to the data table.

Let us see what are the steps present in this automation process.

The Create Data Table command is used to create a blank data table. Let us see what are the steps present in this automation process.

• Click on the Assign  Data Table command under Data Table Automation, once the Instruction Properties pop-up window will open enter the data table name and data table instance and then click on Done.
  
• Next click on the Create Data Table command, once the Instruction Properties pop-up window will open, enter the data table name to be created and then enter the column name and select the data type, which is as shown below.
  
• Next, click on the Append Data Row command, once the Instruction Properties pop-up window will open, enter the Instance name and then, enter the row values as JSON array format.
• Here, I am passing the JSON values as shown below
  [{‘ID’:’1′,’Name’:’Ashwini’,’Date’:’10/12/2021′},{‘ID’:’2′,’Name’:’Rajesh’,’Date’:’11/12/2021′}]
  
• Next click on the Preview Data Table, once the Instruction Properties pop-up window, enter the data table name and click on Done.
  
• Next, save the code and then click on Run.
• Once the robot runs successfully, the preview data table with data will be displayed on the output message box, which is as shown below.