Lesson 5 – Excel and Datatables

Find the Course here.


Introduction: The statisticians need a nice report with population densities.


What you will learn:

  • Primarily:
    • Excel
    • DataTables
  • Secondarily:
    • For Each Row
    • Nested if operators

Client Name: World Stats Agency


Process Name: PopulationDensity


Description: You need to calculate the population density for the largest countries in the world and present the results in Excel:

  • Read the Excel sheet ‘Excel and Datatables – Countries.xlsx’ in to UiPath.
  • For each country calculate the population density by dividing the population by the area.
  • Create a new column in the Excel sheet called ‘Population Density’ and print the densities there.
  • Color the cells in the new column based on the size of the density:
    • If the density is less than 30 the cell must be green.
    • If the density is between 30 and 100 the cell must be yellow.
    • If the density is above 100 then cell must be red.
  • Type in all the countries with red densities in a new sheet.

Leave a Reply