Ultimate Guide: UiPath 7 hands-on projects-By Pranav Kashyap

Explore Excel activities in UiPath to compute total quantities by product using a dictionary, counting values and writing results to a new row, with key‑value concepts.

Explore automating excel calculations in UiPath by using assets and an excel application scope to read ranges, iterate each row, extract product names and quantities, and convert values.

Explore building and using dictionaries in Excel calculations to track product names and quantities, handle duplicates by updating counts, and manage two dictionaries for keys and values.

Explore reading and writing data in Excel using UiPath: loop through rows, use key-value arguments, log exceptions, and insert/update cells and ranges across sheets.

Learn to build robust UiPath Excel automation by using Excel application scope, data table iteration, dictionary handling, and thorough logging with best practices and error handling.

Learn to automate a data entry task on the RPA challenge website by downloading the challenge excel and submitting rows of first name, last name, company, address, email, and phone.

Create a UiPath workflow for RPA challenge website, read data from an Excel file, store values in assets, loop through rows, open and interact with the browser, and log exceptions.

Learn to read Excel data in UiPath row by row, extracting names, company, address, email, and phone, using assign or get item with generic value and logging.

Learn to extract invoice data from a PDF with UiPath, capturing invoice, customer ID, biller, and total, store results in Excel, and send via Outlook.

Explore how to extract invoice data from PDFs in UiPath by storing paths as assets, looping through files with a flowchart, and handling errors with logs.

Master PDF extraction in UiPath by using attach window, anchor base, and get text with UI Explorer to extract invoice data and prepare it for an Excel file.

Learn to build and populate a data table in UiPath from PDF data, map columns like invoice, date, customer, total, and export to Excel via assets and Excel application scope.

Demonstrates pdf extraction using get full text and reading pdf data at points, builds and aligns excel columns with add rule, and sends results via Outlook mail messages using assets.

Explore how to adapt the robotic enterprise framework template to handle Excel data, initialize configuration, manage assets, and automate browser interactions within an RPA challenge.

Read data from an Excel file using the Excel application scope and read range to populate the data transaction data in the ReFramework template, and configure arguments.

Demonstrate ReFramework RPA by implementing process transition to handle transaction data with UI Explorer, anchors, and type into, creating selectors for first name, last name, address, email, and phone.

In this part, the video walks through refining the reframework by configuring transaction items, log messages, and config file usage, updating excel scope, and handling system and business exceptions.

Learn to read Outlook emails in UiPath, filter by subject 'Fixed deposit request', save attachments to a data folder, and load extracted data into queues for downstream processing.

Learn to read Outlook mail attachments, extract Excel data with for each and Excel application scope, parse via read range, and push the data to a queue for processing.

Learn to read Outlook attachments, save and move data for processing with Excel data, debug workflows, log steps, populate a queue, and apply best practices for annotations and well-designed activities.

Demonstrate the dispatcher and performer pattern in the robotic enterprise framework, using queues, Outlook data, a Microsoft Access database, balance validation, and exception handling.

Learn to read data from a database in UiPath ReFramework part 3 by configuring a connection, installing the database package, and executing a query to fetch remaining balance.

Check the remaining balance against the amount, convert strings to integers, and raise a business rule exception for insufficient funds; then use attach window and typing in the ReFramework.

Learn how to integrate an external application into a UiPath ReFramework process flow by mapping import arguments, handling data from the application, and updating the database with conditional updates.

Run and validate a UiPath ReFramework project by processing ten queue items, updating the database, and verifying transactions and outputs, including an insufficient balance error.