Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 16
A.V.C.
COLLEGE OF ENGINEERING Approved by AICTE & Affiliated to Anna University, Chennai Accredited by NAAC with ‘A’ Grade (3rd Cycle) (An ISO 9001:2015 Certified Institution)
MAYILADUTHURAI, MANNAMPANDAL - 609 305.
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Name : M.BALA KUMARAN
Register Number : 820322104008
Class / Semester : CSE/V
Subject Code : SB8026
Subject Name : Robotic Process Automation Development
I BONAFIDE CERTIFICATE Register No: 820322104008 Certified to be bonafide record of work done by
M.BALA KUMARAN Of III Year V Semester B.E./B.Tech CSE Degree course in the
Practical SB8026-Robotic Automation Development in
A.V.C. College of Engineering, Mannampandal, Mayiladuthurai
during the academic year 2024-2025.
Faculty Incharge Head of the
Department Date:…………………..
Submitted for the University Examination held on.................at
A.V.C. College of Engineering, Mannampandal, Mayiladuthurai.
III CONSOLIDATED DATA REPORTING USING LINQ Aim: Create a consolidated data reporting system using LINQ to merge sales and employee data from Excel files. The goal is to provide a comprehensive summary of total units sold and total revenue for each employee, highlighting their region and name for improved business insights.
Procedure: 1. Setup: Install UiPath Studio and the necessary packages (Excel Activities). 2. Data Extraction: 2.1 Read Sales Data:
Add an "Excel Application Scope" activity.
Set the path to SalesData.xlsx. Inside the scope, add a "Read Range" activity to read the data into a DataTable variable named dtSales. 2.2 Read Employee Data:
Add another "Excel Application Scope" activity.
Set the path to EmployeeData.xlsx. Inside the scope, add a "Read Range" activity to read the data into a DataTable variable named dtEmployees.
1 3. Data Merging: 3.1 Join Data Tables: Add a "Join Data Tables" activity. Set DataTable1 to dtSales and DataTable2 to dtEmployees. Set the JoinType to "Inner". Specify the columns to join on (EmployeeID). Store the result in a new DataTable variable named dtMerged. 4. Data Transformation: 4.1 Calculate Totals:
Add a "For Each Row" activity to loop
through dtMerged. Inside the loop, use "Assign" activities to calculate the total units sold and total revenue: 1.row("TotalUnitsSold") = Convert.ToInt32(row("UnitsSold")).
2.row("TotalRevenue") = Convert.ToDecimal(row("Revenue")). Use "Add Data Column" activities to add new columns to dtMerged for TotalUnitsSold and TotalRevenue.
2 5. Reporting: 5.1Write Consolidated Report:
Add another "Excel Application Scope" activity.
Set the path to the new Excel file where the consolidated report will be saved (e.g., ConsolidatedReport.xlsx). Inside the scope, add a "Write Range" activity to write dtMerged to the Excel file, ensuring it includes the following columns: EmployeeID, EmployeeName, Region, Total Units Sold, and Total Revenue.
Implementing Screenshots:
3 4 5 6 Executing Uipath With Screenshot:
7 8 Input Screenshot: Data 1 File:
9 Data 2 File:
10 Output Screenshot: Consolidated Report of Data 1 & Data 2
11 Result: The project successfully generated a consolidated report by merging and transforming sales and employee data. This report provides a detailed summary of total units sold and total revenue for each employee, categorized by their region and name.
