Introduction
VB.NET, also know as Visual Basics.NET, is an object-oriented programming language and supports multiple features, such as polymorphism, encapsulation, and many others.
UiPath, being a low-code platform, provides an easier method to write custom code or logic and use it while building workflows using Invoke Code Activity.
In this article, we are going to see the following things:
- How to use the VB.NET code in UiPath?
- What is Invoke Code Activity in UiPath?
- Adding columns using VB.NET
- Performing arithmetic calculations using VB.NET
So, let's begin!
Step 1 - Creating a process
While creating the process, make sure you select the language VB.
Step 2 - Understanding Input Excel File
This is how our input file looks: we have three columns... Product, Price, and Discount. After processing this output file, we will have two more columns, Discounted Amount and Final Price.
Step 3 - Reading an Excel File In UiPath
In this step, we are using a read range activity to read the data from an Excel file. The output is stored in the variable InputDT of data type DataTable.
Step 4 - Creating arguments in Invoke Code Activity
Now, we have to create two arguments in Invoke Code activity DT1 -> store the InputDT and DT2 -> stores the OutputDT
Step 5 - Writing code in Invoke Code Activity
In this step, we will write the VB.NET code to process the DT1 input, add columns, and perform arithmetic calculations.
Line 2 & 3 -> Used to add columns in our input data table DT1.
Line 4 to 7 -> Processing each row of the input data table and performing arithmetic calculations as required.
Line 8 -> Assigning the processed data table value to output data table DT2.
Step 6 - Writing data to output Excel file
In this step, we will write the output data table to our excel file using Write Range Activity.
Step 7 - Final output file
Our final output file looks like this:
Hurray! With 7 simple and quick steps, we have successfully completed our workflow and understood how can we use custom VB.NET code to build logic in UiPath and perform Excel Automation.
Thank you for reading the complete article. Please comment with your suggestions or the topics you would like me to write articles about.