Skip to content

Latest commit

 

History

History
161 lines (98 loc) · 11.1 KB

README.md

File metadata and controls

161 lines (98 loc) · 11.1 KB
Raw

S04P01 Calculating Sums

This project is my solution in C# to the Calculating Sums practice found in section 04 practice 01 of the UiPath - RPA Developer Foundation course.

Getting Started

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.

Practice Requirements

Calculate the sum in 2 Excel files

Calculate the sum of the values from two columns in an Excel file in 3 ways. Create a workflow that adds the values on column A with values on column B and writes them in column C in different ways:

  1. Keeps the Excel open and writes the results in real time, row by row so you can see the changes;
  2. Keeps the Excel closed, set the column values in the memory DataTable and adds all the table to a new Excel files at once, in the end;
  3. Calculates the sum by using Excel formulas in the original file.

Note: Use the Sample Columns.xlsx file below as the input file for this exercise.

Details

Course: UiPath - RPA Developer Foundation

Section: 04 Excel And Data Tables

Practice: 01 Calculating Sums

Project Format: Windows, C#

GitHub: https://github.com/ShonHarsh/RPADev-S04P01-CalculatingSums

Sample Output

04/24/2024 12:59:28 => [Debug] Debug started for file: Main
04/24/2024 12:59:28 => [Info] RPADev-S04P01-CalculatingSums execution started
04/24/2024 12:59:28 => [Info] RPADev-S04P01-CalculatingSums.Main.Begin;
04/24/2024 12:59:28 => [Info] RPADev-S04P01-CalculatingSums.Method01.Begin;
04/24/2024 12:59:28 => [Info] Audit: Using Excel File: Data\Input\RPADev-S04P01-CalculatingSums-Sample-Columns.xlsx
04/24/2024 12:59:29 => [Info] RPADev-S04P01-CalculatingSums.Method01.OperationCompleted;
04/24/2024 12:59:29 => [Info] RPADev-S04P01-CalculatingSums.Method01.End;
04/24/2024 12:59:29 => [Info] RPADev-S04P01-CalculatingSums.Method02.Begin;
04/24/2024 12:59:29 => [Info] RPADev-S04P01-CalculatingSums.Read_WorkbookToTable.Begin;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Read_WorkbookToTable.OperrationCompleted;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Read_WorkbookToTable.End;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Read_WorkbookToTable.Begin;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Read_WorkbookToTable.OperationCompleted;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Read_WorkbookToTable.End;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Method02.End;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Method03.Begin;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Method03.OperationCompleted;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Method03.End;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Main.OperationCompleted;;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums.Main.End;
04/24/2024 12:59:30 => [Info] RPADev-S04P01-CalculatingSums execution ended in: 00:00:01

Architecture Requirements

A standard UiPath, Studio to Orchestrator cloud setup is the base of operation. It is easy to setup and free.

  1. An Orchestrator connection - Visit https://cloud.uipath.com/ and authenticate or sign up.
  2. 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.

UiPath Setup Guide

Git Notes

Clone the project to develop or change it.

git clone https://github.com/ShonHarsh/RPADev-S04P01-CalculatingSums

Links

RPS Developer Foundation Sections

  1. Get Started With RPA Development

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

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

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

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

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

  7. Project Organization In Studio

    P02 RPADev-S07P02-StateMachines [C#] [VB] [Windows Legacy]

    P03 RPADev-S07P03-FixMyWorkflow [C#] [VB] [Windows Legacy]

    P04 RPADev-S07P04-Libraries

  8. Error And Exception Handling In Studio

  9. Debugging In Studio

  10. PDF Automation In Studio

  11. Email Automation With Studio

  12. Orchestrator For RPA Developers

  13. Robotic Enterprise Framework Overview