Software Testing Munch: How to pass the values from the Process to Object using Excel

Usually in Process Studio we call Object. We write actual implementation of process in business Object. In last class we have created the Business Object as "AdditionofTwoNumber" and same we are calling into the process.

Screenshot of Business Object

Screenshot of Process Studio

In our last blog we were passing the values of two variables from the Process studio by assigning the hard coded values against the variables defined on the Start stage of Object Studio.

Now in this blog we will be parameterize these values mentioned in above screenshot through excel.

Before proceeding i want to highlight few points here:
1. Blue prism have inbuilt business components (VBO) to perform some specific operation while doing the automation of any process like fetching the values from the excel etc.

We can find all these VBO's at below location:

If we have to use any specific VBO's with your process than you will have to import that object as step mentioned in below screenshot.

So, first step first drag an Action stage and open the properties window then select the "MS Excel vbo" business object from the dropdownlist and select the "create instance" Action, so we use the action “Create instance” from the Excel VBO
It Creates handle id everytime that handle id is going to be refer for other Action also thats why we are storing it in handle variable. (It will generate automatically)

Now, let’s open an existing workbook i.e BluePrismTest.xlsx available locally in a system using "Open Workbook" Action from the MS Excel vbo.

Now Get the data of excel in collection using "Get Worksheet As Collection" Action. It will Create the collection and store all the data into the collection. (We have created the collection as Data in below screenshot)

After getting the values in to the collection if we want to run the process for each and every iteration.So we will use loop stage.
Loop stage will take the references from the collection and we have to pass the Collection name as i am passing in below screenshot. In my collection i have maximum data for 2 rows so loop will run my process two times.

Now pass the values to the "AdditionofTwoNumber" process through collection by opening the properties of this action.
Syntax to passing the values from the collection is [Data.Variable1]

Now Process is parameterized to take the input from excel and this input will pass to the Object.Process will run two times as we are using the look stage and it is mapped with the collection.