Resources

Knowledge Base

Automate Data Entry in a Desktop Application

 

  • To be able to run this example you need to install UiPath.Excel.Activities. See more details on how to install packages here.

Task

This data entry automation sample inputs data from a CSV file into a desktop application.

ex_automate_data_entry

Steps to automate

  1. Read the CSV file.
  2. Open the Expense IT application.
  3. Navigate to the add expenses window.
  4. Automate data entry from the CSV file into the application.

Solution

  1. Read the document using "Read CSV" activity.
  2. Open Expenselt Standalone with "Open Application" activity.
  3. Insert the Email, Employee Number and then click Create Expense Report.
  4. Use "Attach Window" activity to get attached to the new window.
  5. Use "For Each Row" activity to insert each line from the data table into the application.
  6. Before and then in the interior of "For Each" loop add a "Click" activity that triggers "Add Expense" button.

Automating data entry from CSV to desktop application should work with one click.

automate_data_entry