Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    NMPROJECTFINAL820322104008

    Uploaded by

    balaavcce
    NMPROJECTFINAL820322104008.dididiss77s

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    NMPROJECTFINAL820322104008

    Uploaded by

    balaavcce
    8 views16 pages
    NMPROJECTFINAL820322104008.dididiss77s

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    NMPROJECTFINAL820322104008.dididiss77s

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    8 views16 pages

    NMPROJECTFINAL820322104008

    Uploaded by

    balaavcce
    NMPROJECTFINAL820322104008.dididiss77s

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 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.

    Internal Examiner External Examiner


    CONTENTS

    S.No Date Content Page Marks Staff


    no signature
    1 28-11-2024 Aim 1

    2 28-11-2024 Procedure 1

    3 28-11-2024 Implementing 3
    screenshot
    4 28-11-2024 Executing UI path with 7
    screenshot

    5 28-11-2024 Output Screenshot 10

    6 28-11-2024 Result 11

    7 28-11-2024 Diploma certificate 12

    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

    Input Dataset Link:


    https://gist.github.com/kevin336/acbb2271e66c10a5b73aacf82ca82
    784

    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.

    12
    DIPLOMA CERTIFICATE

    13

    You might also like