This project is my solution in VB to the Calculating Loss Invoices practice found in section 04 practice 02 of the UiPath - RPA Developer Foundation course.
After making a pull request or downloading the project, open the Main.xaml in UiPath Studio. The robot can be run with the play button in the ribbon and the result can be seen in output panel.
Check which of the invoices in an Excel file were issued to clients in bankruptcy and calculate the sum of the invoices to be recorded as loss.
Input files:
- Invoices (.xlsx)
- Clients (.csv)
Course: UiPath - RPA Developer Foundation
Section: 04 Excel And Data Tables
Practice: 02 Calculating Loss Invoices
Project Format: Windows, VB
GitHub: https://github.com/ShonHarsh/RPADev-S04P02-CalculatingLossInvoices-VB
04/29/2024 15:57:48 => [Debug] Debug started for file: Main
04/29/2024 15:57:48 => [Info] RPADev-S04P02-CalculatingLossInvoices-VB execution started
04/29/2024 15:57:48 => [Info] RPADev-S04P02-CalculatingLossInvoices-VB.Main.Begin;
04/29/2024 15:57:48 => [Info] RPADev-S04P02-CalculatingLossInvoices-VB.Main.Print;
[Agitude, 750]
[Cryptomba, 730]
[Epiloo, 2180]
[Teamatix, 350]
[Travels Print, 570]
[Unit&Products Inc., 1305]
The total amount lost from all invoices: 5885
04/29/2024 15:57:48 => [Info] RPADev-S04P02-CalculatingLossInvoices-VB.Main.End;
04/29/2024 15:57:48 => [Info] RPADev-S04P02-CalculatingLossInvoices-VB execution ended in: 00:00:00
The ForEach loop TypeArgument must be set to the System.Collections.Generic.KeyValuePair.
A standard UiPath, Studio to Orchestrator cloud setup is the base of operation. It is easy to setup and free.
- An Orchestrator connection - Visit https://cloud.uipath.com/ and authenticate or sign up.
- UiPath Studio is used to run the robot. Note that Studio Web can be used directly in Orchestrator but I recommend installing the Studio IDE application.
Clone the project to develop or change it.
git clone https://github.com/ShonHarsh/RPADev-S04P02-CalculatingLossInvoices-VB
- UiPath Automation Platform
- UiPath Studio
- Pulsar (Atom Successor) - Used for all my README.md files
- Shon Harsh Website 127.0.0.1
- This.GitHub
-
Get Started With RPA Development
-
Variables, Data Types And Control Flow In Studio
P01 RPADev-S02P01-ForEachIfStatement [C#] [VB] [Windows Legacy]
P02 RPADev-S02P02-GenericValue [C#] [VB] [Windows Legacy]
P03 RPADev-S02P03-Switch [C#] [VB] [Windows Legacy]
-
Data Manipulation In Studio
P01 RPADev-S03P01-Lists [C#] [VB] [Windows Legacy]
P02 RPADev-S03P03-Dictionaries-Integers [C#] [VB] [Windows Legacy]
P03 RPADev-S03P04-Dictionaries-Doubles [C#] [VB] [Windows Legacy]
P04 RPADev-S03P05-InputValidation [C#] [VB] [Windows Legacy]
P05 RPADev-S03P06-ReplacingPlaceholders [C#] [VB] [Windows Legacy]
P06 RPADev-S03P07-ExtractEmailAddress [C#] [VB] [Windows Legacy]
P07 RPADev-S03P08-ExtractEmailAddressRegEx [C#] [VB] [Windows Legacy]
-
Excel And Data Tables With Studio
P01 RPADev-S04P01-CalculatingSums [C#] [VB] [Windows Legacy]
P02 RPADev-S04P02-CalculatingLossInvoices [C#] [VB] [Windows Legacy]
P03 RPADev-S04P03-CalculatingPercentagesOfExpenses [C#] [VB] [Windows Legacy]
-
UI Automation With Studio
P01 RPADev-S05P01-PasswordGenerator [C#] [VB] [Windows Legacy]
P02 RPADev-S05P02-TheRPAChallenge [C#] [VB] [Windows Legacy]
P03 RPADev-S05P03-InputActions [C#] [VB] [Windows Legacy]
P04 RPADev-S05P04-OutputActions [C#] [VB] [Windows Legacy]
P05 RPADev-S05P05-DataScraping [C#] [VB] [Windows Legacy]
-
Selectors In Studio
P01 RPADev-S06P01-GetAndSortData [C#] [VB] [Windows Legacy]
P02 RPADev-S06P02-SetData [C#] [VB] [Windows Legacy]
P03 RPADev-S06P03-Highlight-TypeItems [C#] [VB] [Windows Legacy]
-
Project Organization In Studio
P02 RPADev-S07P02-StateMachines [C#] [VB] [Windows Legacy]
P03 RPADev-S07P03-FixMyWorkflow [C#] [VB] [Windows Legacy]
P04 RPADev-S07P04-Libraries
-
Error And Exception Handling In Studio
-
Debugging In Studio
-
PDF Automation In Studio
-
Email Automation With Studio
-
Orchestrator For RPA Developers
-
Robotic Enterprise Framework Overview