1. Introduction to DWmaker
  2. How to Register and Download Process BOT DWmaker
  3. How to Connect Process Bot One with Process Bot DWmaker
  4. Process Bot DWmaker Dashboard
  5. How to Update DWmaker
  6. How to create your first Robot?
  7. Variable Scope
    1. What is a variable?
    2. New Variable
    3. Set Variable
    4. Variable Manager
  8. Data Types and Data Casting
    1. What is Data Type and Data Casting?
    2. String Data Type Conversion
    3. How to convert integer data type into string data type?
    4. How to convert an integer value into a decimal value?
    5. How to convert a decimal value into an integer data type?
    6. Convert Date Time into Date
    7. Boolean data type conversion
  9. Conditional Statements
    1. What is a Conditional Statement
    2. How to use Conditional Statements in DWmaker
    3. If Statement
    4. Else Statement
  10. Loops and its Types
    1. What is a loop?
    2. How to use a loop in the DWmaker
  11. Exception Handling
    1. How does Exception Handling work?
  12. Excel Automation
    1. What is Excel Automation?
    2. Read Table
    3. Create Excel Application
    4. Append Data
    5. Insert/Delete Column
    6. Insert/Delete Row
    7. How to Create an Excel Table and filter data using the DWmaker
    8. Remove Duplicate Range
    9. Sort Worksheet Table
    10. Reorder Columns
    11. Format Cells
    12. Autofill Range
    13. Copy Sheet
    14. Lookup Range
    15. Merge Cells
    16. Set Cell
    17. Set Cell Range
    18. Set Font
    19. Set Range Color and Set Range Highlight Color
    20. Get Cell
    21. Get Last Row Index
    22. Get Range Color
    23. Get Workbook Sheet by Index
    24. Get Workbook Sheets
    25. Get Worksheet Table Range
    26. Go To Cell
    27. Create Worksheet Table
    28. Cell Border
    29. Delete Cell
    30. Insert or Delete Table Column
    31. Insert/Delete Table Row
    32. Save Workbook
    33. Save Workbook As
  13. Cognitive Automation
    1. Parse Invoice
  14. Email Automation
    1. IMAP Get Mail
    2. POP3 Get Mail
    3. Send SMTP Email
  15. Text File Operation
    1. Read Text File
    2. Write Text File
  16. File Operations
    1. Check Path Exists
    2. Create File
    3. Create Folder
    4. Download File
    5. Delete File
    6. File Change Trigger
    7. Move a File
    8. Read Folder
    9. Rename File
    10. Zip/Unzip Files
    11. How to Unzip a File
    12. Wait For File
  17. Document Automation
    1. Read Document
    2. Write Document
    3. Append Paragraph
    4. Close Document
    5. Find and Replace Text
    6. Merge Document
    7. Create Table with Data
    8. Add Blank Row/Column
    9. Add Table Cells
    10. Add Table Row
    11. Format Text
    12. Delete Table Row/Column
    13. Delete Table
    14. Merge Row/Column
    15. Set Table Cell
  18. Web Browser Automation
    1. Create Browser
    2. Navigate Back/Forward
    3. Refresh
    4. Execute Script
    5. Get Browser Info
    6. Switch Browser Window
    7. Switch Browser Fame
  19. Data Table Automation
    1. Create Data Table
    2. Append Data Table
    3. Merge Data Table
    4. Filter Data Table
    5. Convert Data Table to JSON
    6. Convert HTML to Data Table
    7. Generate Data Table
    8. Read Table

1.Introduction To DWmaker #

The DWmaker is a desktop automation tool, which is installed in the windows server. It offers us to create a robot with a low/no-code platform. We can publish these robots into the process bot one using different kinds of DWmaker commands and can monitor remotely.

2.How to Register and Download Process BOT DWmaker #

  • To download Process Bot DWmaker, navigate to the given Link https://process-bot.com/
  • Once you click on the above link, you will take to the below page.

  • Click on Pricing, you will navigate to our enterprise editions, we have three types of editions:
    • Process Bot Suite Developer Edition (Which is for Free)
    • Process Bot Suite Enterprise Edition (paid Edition)
    • Process Bot Cloud Enterprise Edition (Paid Edition)
    • If you want to use the community edition then click on Signup for free.
    • Once you click on Signup for free, you will navigate to the below page, enter your email credentials and click on Continue. The OTP will be sent to your email address.
    • Open your email address and copy the OTP you have received from the process bot.

Note: If your Email ID is registered once with the Process Bot DWmaker you cannot use it again to register.

  • Enter the received OTP in the box and click on Continue.
  • Next, the registration page will be opened, select Student, if you are a student or select professional, if you are a professional, and enter the required details and click on continue.
  • Once your registration has been completed, your account will be activated and your log-in credentials have been sent to your registered mail id.
  • Next, go to your registered email id, you will find login credentials as shown in the below image.
  • Click on the link to download Process Bot DWmaker which is present in your registered mail id. The download will start.
  • Once the application is downloaded successfully, click on the download file.
  • Once you click on the downloaded file, the below dialogue box will open, click on the Run anyway.
  • Next, the Process Bot Suite DWmaker will open as below, click on Finish, the Process Bot DWmaker will start installing in your system.
  • Once the Process Bot Suite DWmaker is installed successfully, click on Close.
  • Now, the DWmaker will be visible in your start-up menu, click on the DWmaker to open your system/laptop.
  • Next, the Process Bot DWmaker will ask you to enter the activation, enter the activation code/license key which is sent to your registered mail id.
  • Now click on Activate button.
  • Now you will receive notification as “your license has been activated successfully” in a pop window.
  • Now, the DWmaker will ask you to create a folder to save your script, you can click on Yes.
  • Now, the Process Bot DWmaker dashboard will open as shown below.

3.How to Connect Process Bot One with Process Bot DWmaker #

  • Login to the Process Bot One by using the login credentials(Login ID and Password) received from Intelgic Team.
  • Click on the given link, you will navigate to the below page, enter the username and password.
    Note: When you are login for the first, the Process Bot One will ask to reset your password, so reset the password and then login with your new 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 Menu 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 digital person can perform one task at a time, this service is available in Process Bot Suite Developer Edition.
  • Server: In this environment, multiple virtual systems can perform multiple tasks at a time. This Service is available for the enterprise 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.
  • To add Machine/Host to the Process Bot One, just click on the + Add symbol, a pop-up window will appear.
  • Next, Open the Process Bot DWmaker, that you have installed in your system. And click on the Options in the Process Bot DWmaker window.
  • Next, click on Settings Manager under Options.

  • Next, the Settings Pop-up window will appear, by clicking on the Orchestrator, you will be navigated to the Orchestrator Setting window which is as shown below.
  • In the Orchestrator settings window, you have Host Name and User Name, copy these to and paste it in the Standalone pop-up window as shown below. Click on the Save button.
  • Once you click on the Save button, the host will be created successfully, and the key number will be created in the standalone host window as shown below.
  • Next, click on the key symbol and copy the key number.
  • And, enter the copied key number in the Process Bot Dwmaker, under Host Key, and then click on the connect to Server as shown below.
  • Once you click on the connect to Server, the pop-up window will appear as shown below, click on the Done.
  • Once, the Process Bot One is connected with Dwmaker, you can see a green right mark before the Machine Name as shown below.

4.Process Bot DWmaker Dashboard #

  • In the Process Bot DWmaker, we have three buttons, such as Robots, Actions, and Options.
  • Once you click on the Robot button, you have a menu bar that help contains,
    • Robot List: If you click on the robot list, it will display the list of the robots present in the Process Bot DWmaker.
    • Launch Robot: The launch robot option navigates you to select the files which are present in your script folder before launching any robot.
    • Import Robot: The Import robot helps to import the robot from your script folder to your working directory.
    • Save, Save As: It will help to save your automation commands
    • 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, a schedule pop-up window will open, which helps to schedule the time for triggering the robot. 
  • The Run button helps to run the scheduled robot.
  • The next category is the Options button.
  • We have a variable manager, Settings Manager, and License.

  • The Variable manager helps you to add Default Task Variable or My task variable.

 

5.How to Update 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 winodw.
  • 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.

 

 

 

 

6.How to create your first Robot? #

On the dashboard screen, press “Create your First Robot” text, in order to create your first robot.

Now select the “Miscellaneous Operation” command from the dashboard sidebar, as shown in the image:

Print Message

When you click on the “Miscellaneous Operation” command, it will then open a few more sub-menu options, where you are requested to select and click on the “Show Message” option. See the below image.

Whenever you click on the “Show Message” option a new pop-up window will open asking you to insert a valid or respective message that you want to show/print by your first robot.

For example, here I am going to print “Hello World!”

Once you fill in the message, press the “Done” button. With this, you are done with the successful creation of your first Robot, and the first code line for the same will be automatically created and appear on the code window.

Save Robot

Press the “Save” button from the top section, in order to save your robot. Save it with a genuine name.

Now it’s time to check if your first robot is working or not, and to do this, hit the “Action” tab, which is located at the top header of the dashboard.

Run the Robot

Click on the Run button under the Action tab to check whether your robot is working or not.

Check Output

This is how your first robot will look:

This is how you can build and run your first robot.

Now, you know, how Process Bot DWmaker allows you to create your first robot in just a few simple steps. Stepping ahead, we are going to explain the use of variables.

7.Variable Scope #

 

Basically, a variable is a name given to a storage area to hold a value that programs can manipulate. Each variable has a specific type, which determines the size and layout of the variable’s memory; the range of values that can be stored within that memory; and the set of operations that can be applied to the variable.

The name of a variable can be a combination of letters, digits, and the underscore character.

 

7.1.What is a variable? #

 

Basically, a variable is a name given to a storage area to hold a value that programs can manipulate. Each variable has a specific type, which determines the size and layout of the variable’s memory; the range of values that can be stored within that memory; and the set of operations that can be applied to the variable.

The name of a variable can be a combination of letters, digits, and the underscore character.

 

7.2.New Variable #

In a way to represent any specific value using DWmaker, you need to use its variable command, and for this, select and click on the “Variable Scope” command option from the DWmaker dashboard. See the image.

Ho w to Create a new variable: you need to create a variable first, to use it in your program.

To create a variable, go on to the “New Variable” command, as shown in the below image.

It will open a new property window, where you need to insert the variable name and value that you want to print.

For example: Here, I took “Test” as a variable name. While I am passing the value as “Test Status” in it. See the image:

  • Variable Name: Insert a variable name here. You can use any specific variable name.
  • Insert Value: Assign a value here that you want to show. A value can be any number, letter, word, email, or anything else.
  • What if the Variable Already Exists: This is a drop-down that you can use in case of any “if statement ” with the variable.

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

Print Variable

Now go on to the “Show Message” command under “Miscellaneous Operations” as shown in the below image:

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

Note: Remember to input the variable name in square brackets “[ ]”. See the below picture.

Now, with this, you have successfully created the second code line, that helps the robot to print and show the respective message.

In order to move further and run the variable program, save the entire process.

Run 

For this click on the “Run” button under the “Actions” tab.

Here, see the result.

With the above steps, we have learned to create a new variable. Moving further, let’s learn how to replace the value of an already existing variable with a new value.

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

To use the data types in the process bot suite, first, we need to set two variables using the “Set Variable” command under the “Variable scope”.

When you click on the “Set Variable”, a new property window will be open where you need to input the variable name and variable value. See the image below.

For example: Here, I have taken X as my first variable name with a variable value of 25. Meanwhile, Y is my second variable along with the variable value 44.

Once setting the variable name and value, the code lines representing the process will be automatically displayed on the code window as similar to the below image.

Here, I would like to sum up the variables that I have created as “X” and “Y”, therefore, I am taking another variable as “Total”. While in the ‘variable value’ field of the property window we need to insert the variable names written separately within the square brackets “[ ]” along with a “+” sign. As shown in the below image.

Now, press the “Done” button, and move to the print message method using the “Show Message” command under the “Miscellaneous Operations”.

Once finished with the variable and variable value declaration, your code window will appear like this:

Run the program:

To see the program in action, press the “Run” command under the “Actions” tab.

Result

Here is the result of your program for summing the two different variables.

Likewise above, you can easily perform any mathematical operation with the variables as addition, subtraction, multiplication, division.

7.3.Set Variable #

Click on the Set Variable command under the Variable Scope. Then it will show a new property window asking to fill up some details. 

On the above screen, you need to provide a variable name, whose value you want to replace. while, on the second column, insert a new value that you want to replace with the already existing value.

For example: Here, I am replacing my previously assigned value “Test Status” of the variable “Test” with the new value “Test Completed”. See the below image.

Post filling the variable name and the new value. Click on the Done. Now, you have another code line on the code window.

Now, copy and paste the show message code, below to the set variable code on the code window.

Save the process and proceed to check it in action.

Run the Program

To see the result of the variable replacement program, again click on the Run under the Actions tab, then you can see it will print and show the old value first.

While, if you click on the Ok, it will show the result with the replaced value. As shown in the below image.

7.4.Variable Manager #

If you do not have any predefined variable in your program, then you can create it using the “Variable Manager” utility under the “Options” tab.

Once you click on the “Variable Manager”, a new pop-up window will be open.

Now Select “My Task Variables” from here, and then press the “Add” button. See the below image.

Now, you can see a new dialogue box will be open and ask you to fill up the default variable name and value. See the image.

For example: Here I input “Test Score” as Variable Name and “Passed” as the Variable Value.

Post filling the variable name and value, press the “Done” button.

Now, you can see the variable is successfully created and displayed on the “Variable Manager” window.

Here, I use ‘Passed’ as the default value of the variable “Test Score”.

Now press the “Done” button, to add this to the list of variables, and to check if it is successfully added or not, go to the “Set Variable” command and check it in the “Name a Variable” field. See the image.

With this process, you have successfully added the variable, now let’s learn how to use it?

To use the predefined variable, go to the “Set Variable” command under the variable Scope. It will open a property window.

Now, select the predefined variable from the dropdown whose default value you want to change, and press the “Done” button.

For example: Here, I select my predefined variable “Test Score” and giving it a new value as “You are Fail”.

Now, print the message, using the “Show Message” Command, as we did earlier.

Run the Robot

Save the process, and press the “Run” button. Now, you can see that the predefined variable is showing the new value, instead of its default value.

Meanwhile, if you want to print the predefined variable with its default value, then you need to disable the “Set Variable” code line from the code window.

After disabling the “Set Variable” code line from the code window. Save and Run the program once again. Then it will show the predefined variable with its default value.

That’s the entire process to use the variables within the Process Bot. Try this easy tutorial and learn to use and implement variables in your program.

Continuing the DWmaker tutorial, now we are moving to learn the next command as Data Types and Data Casting.

8.Data Types and Data Casting #

  • Integer (int): It stores the numeric value in the form of data.
  • Characters (Char): It stores character data (words) in a program.
  • Float: This data type is helpful to store and represent the numeric value with a decimal point.
  • String: This data type holds the alpha-numeric values.
  • Boolean: This data type returns the “False and True” value for “0 and 1” respectively.

 

8.1.What is Data Type and Data Casting? #

  • Integer (int): It stores the numeric value in the form of data.
  • Characters (Char): It stores character data (words) in a program.
  • Float: This data type is helpful to store and represent the numeric value with a decimal point.
  • String: This data type holds the alpha-numeric values.
  • Array: It represents the collection of elements which includes; array variable, array value, etc.
  • Boolean: This data type returns the “False and True” value for “0 and 1” respectively.

 

8.2.String Data Type Conversion #

Data type conversion is the way of converting the expression of the data type.

To use the data type conversion method in the process bot suite, first declare a variable value with an expression.

First, click on the Data Type Conversion under the String Operation.

Once the Instruction Properties window will open, select the Variable Scope-Set Variable.

For example, if we want to print a phone number with a proper phone number writing format as “713-348367”, then set a new variable for the same, using the “Set Variable” command.

As here I take the variable “Phone” and set “713-348367” as the variable value. See the image.

Press the “Done” button and print the message using the “Show Message” command, and then save the process.

Note: While printing a variable, always remember to put the variable name within the square brackets “[ ]”.

Now, save the code and run the robot to see the result. Which is as shown below.

Well, getting this result, instead of the phone number, you definitely think something is wrong here. While, actually the variables considered the expressions as the mathematical operation, and thus, it shows the result by subtracting the numbers.

To resolve these things, we need to use data type conversion. For this, we need to make it as a string first.

Now, to know how to convert an integer value into a string, refer to the next part as “How to convert integer data type into string data type?“.

8.3.How to convert integer data type into string data type? #

 

Now, press the “Done” button, and move forward to print it using the “Show Message” command.

As of now, we are printing the string data type then we need to insert the variable name with the string operation (.ToString()) as shown in the below image.

Save the process and run it to see the result.

So, whenever you want to pass an alphanumeric value or value with an expression such as phone no, date of birth like 12-6-1999, etc. you always need to convert it into a string data type to get the proper output.

 

8.4.How to convert an integer value into a decimal value? #

To print an integer value with a decimal (.) expression, you need to access the “String Operations” command. See the picture.

When you click on String Operation, it will open a list of a few more commands associated with it. Here, you need to click on the “Data Type Conversion” in order to convert one form of data type into another. 

On the click of the “Data Type Conversion” command, it will open a property window, where you need to set the variable value as per your data type preference.

Here, you can choose any specific data type from the drop-down.

In case, you need to deal with salary or some finance-related sheets then you need to get the values in a decimal format like (25.75 or 45.00). In such cases, you are required to convert the integer into a decimal value to get accurate results. 

For this, first set a variable using the “Set Variable” command. Like I have created a variable as “Decimaleg” here along with a variable value of 25.

Now, to convert it into a decimal data type value, go to the “Data Type Conversion” command under the “String Operation” and fill up the property window with the required details. See the image.

Note: 

  1. Here, I select the decimal data type, because I want to print the value in the decimal format. 
  1. In the variable output field, you need to input the variable name whose value you want to convert. You can input the same variable name or another existing variable as well.

Once done filling with all the properties, press the “Done” button, and print the message using the “Show Message” command.

Finishing with all these processes, the code window will be like this:

Save the process and move forward to check it in action using the “Run” button under the “Actions” tab. 

Now, see the integer value “25” is converted into a decimal value “25.00”.

8.5.How to convert a decimal value into an integer data type? #

To convert the decimal value into an integer, you need to access the “Data Type Conversion” command under the “String Operations”. 

For example, here I have a variable “IntegerVar” with a value “25.34”. Currently, this is a decimal value and I want to convert it as an integer value.

Click on Datatype Conversion under String Operation enter the variable name and the decimal value that you want to change as shown in the below image.

Again click on the Datatype Conversion under String Operation and enter the variable name, select the data type, and then enter the variable name in the square bracket, which is as shown below.

As here, we are using a value with an expression, therefore, we need to pass it with string command (.ToString()).

Click on Show Message under Miscellaneous Operation, Once the Instruction Properties window will open, enter the details as shown in the below image.

Save the process and Run.

The above image is showing the result of integer data type conversion from a decimal value.

8.6.Convert Date Time into Date #

Like we have converted Integer to Decimal we can also convert DateTime property into Date. 

Click on the Datatype Conversion under String Operations.

Once the Instructions Properties window will open, select the variable scope to Set Variable.

Next, enter the variable name as Date under Choose/Name a variable to change its value.

And, click on Insert variable and select the [DateTime. Now] from the drop-down list, and click on Done, which is as shown in the below image.

Next, click on the Datatype Conversion under String Operation, and enter, 

  • Variable name Date in the square bracket([])
  • Select the Date from the drop-down under Select Data Type
  • Next, provide the output format as MM/dd/yy
  • Click on the Insert variable and select DateTime.Now from the drop-down
  • And, click on Done.

Next, Click on Show Message under Miscellaneous Operation and enter the Variable name and click on Done.

Now, click on Save to save this code, and go to the Actions tab, and then click on Run, once the robot executes successfully, the time date will be displayed on the Message box as shown below.

 

8.7.Boolean data type conversion #

Boolean data type works to declare one of the two possible values in the form of true and false. In the computer science language, the boolean data type returns the “False” result with zero (0), and “True” with one (1).

To declare true or false results in the program, set a variable first. 

For example, here I took the variable as “booleanVar” along with the variable value “0”. See the image.

Press “Done” and click on the “Data Type Conversion” under the “String Operation”.

On the “Data Type Conversion” property window, set the data type as “Boolean” from the data type drop-down and fill the other required properties with the respective values. See the image.

Now, press the “Done” button and proceed to print the value using the “Show Message” command.

Save the process and Run the program.

Here it returns the result as “False” because I set the variable value as 0 (Zero). While it will return the result with “True” when the variable value will be 1 (One).

The above was the entire step-by-step process for the data type conversion in the simplest way.

9.Conditional Statements #

 

List the types of conditional statements

  • If Statement: If statements in used to control the program flow based on some condition, it’s used to execute some statement code block if the expression is evaluated to true.
  • Else Statement: The else statement, is used to specify a block of code to be executed if the same condition is false.
  • Else-if Statement: The else-if conditional statement is used to specify a new condition to test if the first condition is false.

 

9.1.What is a Conditional Statement #

 

List the types of conditional statements:

  • If Statement: If statements in used to control the program flow based on some condition, it’s used to execute some statement code block if the expression is evaluated to true.
  • Else Statement: The Else statement is used to specify a block of code to be executed if the same condition is false.
  • Else-if Statement: The Else-if statement is used to specify a new condition to test if the first condition is false.

 

9.2.How to use Conditional Statements in DWmaker #

For example, here I take a variable as “Flower color” and the variable value as “Pink”. See the image.

Press the “Done” button and save the process.

Now, to add “if condition” in the program refer to the next part If Statement of the tutorials.

 

9.3.If Statement #

 

To implement the if condition in a program, select the “if statement” command. See the below image.

Now click on “Begin if” and fill in the details in the property window.

Here, on the property window drop-down, there is a list of multiple options for comparison. Such as value, date comparison, and more.

As I want to check if the value is true or false, I selected the option “value” here.  In the next, we have parameters with two value options. Where, in the value1 field, we need to insert that value which we want to compare with another value.

Here, the “Operand” column in the property, is a list of operations, you can select an operation as per your comparison needs.

Press “Done” and move ahead to print the message using the “Show Message” command under “Miscellaneous Operations”.

Now the code window will look like this:

Save the process, and run the program.

In case if the condition is not matched, then the program will not be executed.

 

9.4.Else Statement #

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.

10.Loops and its Types #

What is Loop?

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 stated two kinds of loops as follows:

  1. Conditional loop: Such loops can execute a certain number of times and automatically stops the execution when the applied condition of a program gets completed.
  2. Infinite loop: This is a type of loop that can execute continuously. Infinite loops are also known as endless loops.

10.1.What is a loop? #

Types of loops:

Basically, the programming languages have stated two kinds of loops as follows:

  1. Conditional loop: Such loops can execute a certain number of times and automatically stops the execution when the applied condition of a program gets completed.
  2. Infinite loop: This is a type of loop that can execute continuously. Infinite loops are also known as endless loops.

 

10.2.How to use a loop in the DWmaker #

o run a robot with some continuous execution, first, we need to set a variable using the “Set Variable” command under the “Variable Scope”.

Once done with setting a variable, now, it’s time to set how many times you want to execute the loop. For this, select the “Loop Number of Times” option under the “Loop Statements” command, and set the value at how many times you want to run the loop. See the picture.

The loop command will automatically be generated and displayed on your code window like the below image.

Now, add the loop count as (+1), or (-1) in the variable value.

Note: In order to increase the loop value with each execution we need to increase the loop with +1. While to decrease the loop value we need to use -1.

After setting the loop count, move ahead to print the message using the “Show Message” command.

Press “Done” and save to process, prior to running the robot. 

Now, in the result, you can see the robot will execute until the condition gets false. 

Likewise, the process bot suite has a few more loop-related commands that you can use in the same way to continue the loop execution or to stop and exit the loop statement after the particular time of loop execution.

11.Exception Handling #

Basically, the process bot suite has 3 kinds of exceptional handling features:

Try: Whenever the try block experience any exception or error in the code then it will move toward to check the catch block and execute the program with the code/conditions mentioned in the catch block.

Catch Exception: The catch exception, allows users to define a block of code to be executed if an error occurs in the try block.

Finally: This error exception will always execute the code, after the try-catch exception, regardless of the result.

End Try: This stops the program to execute or we can also say as it ends the program, if once the program found any block to be true/exception-free, either it’s Try or Catch.

Meanwhile, the Try and Catch exception works together to execute a program:

For example, if you have created a robot with any particular command, and if everything is good in the program, then the catch command will execute and show the accurate result. While if it found any mistake or issue in it, at the run time, then it will show an error message at the time of execution.

 

11.1.How does Exception Handling work? #

For example, here in the process bot suite DWmaker tool, to check the process of try-catch exception, first, go to the “Exception Handling” command. See the image.

The Exception Handling command is integrated with a few sub-command options from them you need to select and click on the “Try” option. See the image.

When you will click on the “Try” option, it will open a property window, as shown in the below image.

Now press the “Done” button on the property window and then you can see the code line created and are appeared on your DWmaker code window like the below image.

Here, if everything is good in the code, as whatever code you will mention under the ‘Try’ then the program will simply execute the Try command, while, if there is any issue in the code under ‘Try’, then the program will be automatically redirected to the next step and execute the code mentioned in the Catch Exception.

Along with this, there is one more exception handling command option, which is “Finally”. See the image.

In the property window of “Finally” exception option, you can add a comment for the program if you want, and then click on the “Done” button. See the image.

Although the program has any error or not, this Finally exception command will always execute, either with the Try or with Catch exception.

The above is the simple use cases for exception handling in DWmaker.

 

12.Excel Automation #

To perform all the excel operations easily using the Process Bot Suite DWmaker, we have to use its “Excel Automation” command. The command has more sub-command which you can use to perform different excel operations.

 

12.1.What is Excel Automation? #

To perform all the excel operations easily using DWmaker, we have to use its “Excel Automation” command. The command has more sub-command which you can use to perform different excel operations.

 

12.2.Read 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 create 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 cut and paste 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.

12.3.Create Excel Application #

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.

12.4.Append Data #

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.

12.5.Insert/Delete Column #

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 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 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.

12.6.Insert/Delete Row #

 

To insert rows 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 need 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 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 insert a new row in the particular excel sheet using the process bot suite DWmaker tool, go to the “Insert/Delete Rows” command under the “Excel Automation”, as shown in the below image.

Now fill the property window. See the image below.

In the above property window, fill the number of the row in the “Enter the start position” field, where you are looking to insert new rows. While in the “Enter the number of rows” filed, provide a specific number that shows how many rows you want to insert. 

Now, press the “Done” button and save the process, to check the robot in action. 

After successfully saving the robot, when you will run it using the “Run” button under the “Actions” tab, you can see there are new rows inserted in the sheet.

Use the above-mentioned simple steps, you can easily insert rows in an excel sheet.

 

Additionally to delete rows 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 rows from an excel sheet, click on the “Insert/Delete Rows” command under the “Excel Automation”, and fill the property window. See the image.

Now, save the process and run the robot to see it in action, as it has now deleted the particular rows from the excel sheet. 

With the above steps, you have learned how easily you can delete rows from an excel sheet using the DWmaker tool.

12.7.How to Create an Excel Table and filter data using the DWmaker #

 

Here on the “Create Excel Application” property window, give a unique instance name and then click on the “Done” button.

Now, in the next step, you need to open a workbook, for this, click on the “Open Workbook” option under the “Excel Automation” command. See the image.

In the ”Open Workbook” property window, insert your instance name and the specific excel file path in the respective fields, and then press the “Done” button. See the image.

Now, click on the “Create Worksheet Table” option which is also listed under the “Excel Automation” command. See the image.

Now, the “Create WorkSheet Table” property window, will ask you to provide some details in it, where:

Sheet Name: This is the name of a particular worksheet within an excel file that you want to operate.

Enter the Range: This is the specific range including entire rows and columns within the excel sheet to which you want to access.

Table Name: In this field give a unique table name. Each excel table has a unique table name.

Moving ahead, press the “Done” button and save the process by simply clicking on the “Save” button.

Once successfully saving the file, go to the “Actions” tab and press the “Run” button under it.

Once you click on the run button, the robot will start working, and the result will be seen like the below image.

In the above image, you can see a dropdown icon, which is marked as read. Every column of the sheet has a separate dropdown icon. While by clicking on any particular dropdown, you will become able to apply some additional filters in the specific column of the sheet.

For example, here I want to show the details of “designers” only, so I will just click on the dropdown icon and uncheck the other data except “Designers” in the “Text Filter” option. See the image.

Now, by pressing the “Ok” button, it will show the result only with the details of the “Designers. See the image.

In case, to show all the columns, simply click on the “Select All ” checkbox, and then press the “Ok” button, then it will show the entire data again.

To implement the same filter in an excel sheet, using the Process Bot Suite DWmaker, go to the “Filter WorkSheet Table” under the “Excel Automation” command. See the image.

Now, insert all the required details in the “Filter Worksheet Table” property window. Where:

Sheet Name: This is the name of a particular sheet within an excel file.

Table Name to be Filtered: This is the name of your table in an excel sheet.

Column Number to Add Filter: This is the specific column in an excel sheet which you want to operate with this process.

Filter Options: This is the particular value in the excel sheet that you want to filter. Here you can insert single and multiple values as well to filter.

Now, press the “Done” button and save the process, and move forward to run it by clicking on the “Run” button which is listed under the “Actions” tab.

The robot will start working once you press the “Run” button and show the result only with the selected filtered values.

Using the above steps you can create an excel table and filter the excel sheet data in an easy way.

 

12.8.Remove Duplicate Range #

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.

12.9.Sort Worksheet Table #

To arrange or sort the excel sheet data in ascending, descending and alphabetic manner using the DWmaker, first go to the “Excel Automation” and click on the “Create Excel application” option. See the image.

Now provide a unique instance name in the respective field in the “Create Excel Application” property window. See the image.

Now click on the “Done” button and move ahead to open the excel file whose values you want to arrange in ascending and descending order. 

To open a file, go to the “Excel Automation” command and click on the “Open Workbook” option. See the image.

Insert the instance name and the specific excel file path in the respective fields of the “Open Workbook” property window, and then click on the “Done” button.

In the next step, you need to access the “Sort Worksheet Table” option under the “Excel Automation” command. See the image.

In the “Sort Worksheet Table” property window, provide a few required details, where;

Sheet Name: This is the name of the particular sheet within an excel in which you want to perform sorting.

Sort Option: Here, either you can choose a single sorting option as “Table” or “Entire Sheet” by clicking on the dropdown. This selection just depends on your sorting requirement.

Column Number to Sort: This is the specific column number within the sheet that you want to sort.

Table Name: You only want to insert the name of your excel table if you choose the “Table” in the Sort Option field.

Action to Perform: Here you can select either Ascending or Descending action as per your requirement to sort the excel sheet data.

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

Once you successfully save the process, move ahead to run the robot, by pressing the “Run” button which is listed under the “Actions” tab.

On pressing the “Run” button, the robot will start working and show the sorted result. See the image.

With the above process, now you know how easily you can sort the data of an excel sheet or excel table using the DWmaker. 

12.10.Reorder Columns #

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.

12.11.Format Cells #

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.

12.12.Autofill Range #

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.

12.13.Copy Sheet #

  • 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.

12.14.Lookup Range #

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.

12.15.Merge Cells #

  • 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.

12.16.Set Cell #

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.

 

 

 

12.17.Set Cell Range #

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.

12.18.Set Font #

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.

12.19.Set Range Color and Set Range Highlight Color #

  • Set Range Colour: The set range colour changes the colour of the text in the given range.
  • Set Range Highlight colour: This command highlights the background colour of the given cell range.
  • Let us see how we can perform these operations using excel automation.
  • Our first step is to create an instance, so, click on the Create Excel Application 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, enter the instance name and file path location and then click on Done in the Instruction Properties pop-up window.
  • Now, click on the Set Colour Range under Excel Automation.
  • The Instruction Properties pop-up window will open, enter,
    • Instance name
    • Sheet name
    • Cell range
    • And the colour and then click on Done.
    • Now save the code and go to the Action tab and then click on Run.
    • Once the robot will runs, you will get the below output.
    • Now, click on the Set Range Highlight Colour, under Excel automation and enter the required details.
      • Enter the instance name
      • Sheet name
      • Enter the cell range to highlight the background colour.
      • Enter the name of the colour to highlight.
      • And then click on Done.
      • Now, Save and go to the Action tab and click on Run.
      • Once the robot executes the code, open the excel sheet, you will find the output which is as shown below.
 

12.20.Get Cell #

  • 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.

12.21.Get Last Row Index #

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.

12.22.Get Range Color #

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.

12.23.Get Workbook Sheet by Index #

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.

12.24.Get Workbook Sheets #

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 print 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.

12.25.Get Worksheet Table Range #

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.

12.26.Go To Cell #

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.

12.27.Create Worksheet Table #

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.

12.28.Cell Border #

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.

12.29.Delete Cell #

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.

12.30.Insert or Delete Table Column #

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.

12.31.Insert/Delete Table Row #

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.

12.32.Save Workbook #

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.

12.33.Save Workbook As #

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.

13.Cognitive Automation #

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.

13.1.Parse Invoice #

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

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).

14.Email Automation #

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.

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

14.1.IMAP Get Mail #

The IMAP Get Mail, a command is used to check all the read or unread emails in your inbox. Check for new messages using the DWmaker tool. Click on the 

Email Automation command, you can see the commands which are as shown in the below image.

Click on the IMAP Get Email command, once you click on it, Instruction Properties, a pop-up window will open, 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.

14.2.POP3 Get Mail #

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.

14.3.Send SMTP Email #

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.

15.Text File Operation #

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.

15.1.Read Text File #

  • 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.

15.2.Write Text File #

  • 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.

16.File Operations #

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:

16.1.Check Path Exists #

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.

16.2.Create File #

  • 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.

16.3.Create Folder #

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.

16.4.Download File #

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.

16.5.Delete File #

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.

16.6.File Change Trigger #

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.

16.7.Move a File #

  • 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.

16.8.Read Folder #

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.

16.9.Rename File #

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.

 

 

16.10.Zip/Unzip Files #

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.

16.11.How to Unzip a 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.

16.12.Wait For File #

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.

17.Document Automation #

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.

17.1.Read Document #

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

17.2.Write Document #

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 under documentation automation.
  • 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.

         

17.3.Append Paragraph #

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.
  •  

17.4.Close Document #

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.

17.5.Find and Replace Text #

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.

17.6. Merge Document #

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 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, 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.

17.7.Create Table with Data #

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
        • 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

17.8.Add Blank Row/Column #

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.

17.9.Add Table Cells #

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.

 

17.10.Add Table Row #

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.

17.11.Format Text #

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 openinstance 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.

17.12.Delete Table Row/Column #

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.

17.13.Delete Table #

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.

17.14.Merge Row/Column #

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.

17.15.Set Table Cell #

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.

18.Web Browser Automation #

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.

18.1.Create Browser #

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.
    • 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.

18.3.Refresh #

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.

18.4.Execute Script #

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 
  • 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.

18.5.Get Browser Info #

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 you want to retrieve the 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.

18.6.Switch 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.

18.7.Switch Browser Fame #

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.

19.Data Table Automation #

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… 

19.1.Create Data Table #

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.

19.2.Append Data Table #

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.

 

19.3. Merge Data Table #

The Merge Data Table command is used to merge two or more data tables into a single data table.

Let us see, how we can perform merge data tables using the DWmaker automation tool.

  • Click on the Assign Data Table Instance under the Data Table Automation, once the Instruction Properties pop-up window will open, enter the data table name and create a data table instance 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,
    • The Data Table Name
    • Workbook file path location
    • Sheet name from which sheet you want to merge the data table
    • And, then click on Done.
    • To merge two data tables we have to create another instance by repeating the above steps.
    • Click on the Assign Data Table Instance under the Data Table Automation, once the Instruction Properties pop-up window will open, enter the data table name and create a data table instance 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,
      • The Data Table Name
      • Workbook file path location
      • Sheet name from which sheet you want to merge the data table
      • And, then click on Done.
      • Next, click on the Merge Data Table command, once the Instruction Properties pop-up window will open, enter the required and then click on Done.
      • Next, click on Preview Data Table, once the Instruction Properties pop-up window will open, enter all the details and click on Done.
      • In the Preview data table window, we have to provide the name of the other data table other than the source data table.

      • Next, save the code and then run, once the robot runs successfully, the merge table preview will be displayed as shown below.

         

19.4.Filter 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 Preview Data Table, Once the Instruction Properties pop-up window will open, enter the instance name and then click on Done.
  • 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.
  • Next click on the Assign Data Table Instance command, once the Instruction Properties pop-up window will open, enter the new data table name and new data table instance name and then click on Done.
  • Next, click on the Filter Data Table command, once the Instruction properties pop-up window will open, enter the instance name.
  • And, then, select the logical operator to perform the logic operation on the given data table.
  • Here, we have AND and OR operators, where AND operator is used to perform a logical conjunction on given vales.
  • The logical OR operator is used to perform logical disjuction on given values.
  • Here, I am performing the AND operation and giving the filter condition, to filter the values where ID=1
  • Select the condition in the Slect the Logical Condition table which is as shown below.
  • And enter the output data table name to receive result set.
  • Now, click on the Preview Data Table command , once the Instcruction Proprties pop-up window will open, enter the instance name and then click on Done.
  • Now, save the code and click on Run, once the robot runs successfully, based on the given condition, the data table filter the data and the preview of the data table will be displayed on the output message box.
     

19.5.Convert Data Table to JSON #

The Convert Data Table to JSON is used to convert the Data table values into JSON format.

Let’s see what are the steps present in this operation.

  • Click on the Assign Data Table Instance, once the Instruction Properties pop-up window will open, enter the data table name and data table instance name 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.
  • And, then enter the column name and then select the data type.
  • Click on Done.
  • Next, click on the Append Data Row command, once the Instruction Properties pop-up window will open, enter the data table name to add the row.
  • And, enter the row values as JSON array and then click on Done.
  • Next, click on the PReview data table command, once the Instruction Properties pop-up window will open, enter the table name and then click on Done.
  • Next, click on the Convert Data Table to Json command, once the Instruction Properties pop-up window will open, enter the data table name and then enter the output variable name, and then click on Done.

  • Next, click on the Show Message Options command, once the Instruction Properties pop-up will open, enter the output variable am then click on Done.
  • Next, save the code and then click on run, once the robot runs successfully, the data table values will be converted into the JSON format, which is as shown below.

19.6.Convert HTML to Data Table #

The Convert HTML to Data Table command is used to convert unstructured data to the structured data table.

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

Our first step is to get the HTML data from the website, we can scrape the data from the website by using the web browser automation command.

Let us create a browser first, click on the Create Browser command under Web Browser Automation, once the Instruction Properties pop-up window will open, enter all the details and then click on Done.

Here, I am using the sample HTML data from the website and scrape the data by using the element search method Xpath.

Go to the website and then right-click on the below table and then right-click on the element code and select copy and then select copy XPath as shown below.

Copy the XPath code and paste it under the element search parameter in the Element Action Property window.

And then enter the Element Action as Get HTML and enter the parameter value as V_HTML and then click on Done.

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

Next, click on Convert to HTML to Data Table, once the Instruction Properties pop-up window will open, enter all the details and then click on Done.

 

 

19.7.Generate Data Table #

The Generate Data Table command is used to generate a data table by using the specific information present in the text file.

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

Here, our first step is to read the text file present in the Notepad file.

Click on the Read Text File command under Text File Operation, once the instruction properties pop-up window will open, enter file path location and variable name to hold the text file. And then click on Done.

Next, click on Assign Data Table Instance, once the Instruction Properties pop-up window will open, enter the Data Table name and Instance name and then click on Done.

Next, click on Generate Data Table, once the Instruct Properties pop-up window will open, enter a variable name under the unstructured data and select the separator as your preference.

Select yes, if you want to create a header from the first line of your text present in the Notepad, or else select No.

Next, enter the name of the table and then click on Done.

Next,  click on the Preview Data Table property window, once the Instruction Properties pop-up window will open, enter the data table name to be displayed.

Next, save the code and then click on Run. Once the robot runs successfully, the preview data table will be displayed on the preview table window.

19.8.Read Table #

The Read Table command is used to read the text present in the data table.

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

 

Help Guide Powered by Documentor
Suggest Edit