Reading and Updating EXCEL using UiPath

Let’s see how you can practise this uipath excel task and how this is useful for you.

The input Excel look like below

Name Age Status
Aditya
23
Hari
20

You have to check the Age column in the excel.

If that value is less than 22, you have to update that as ‘Yes’ else update that as ‘No’.

The output Excel look like below

Name Age Status
Aditya
23
No
Hari
20
Yes

How this be useful in real time scenarios?

Whatever the process you are automating finally you need to send the report to the business user.

In that report you need to mention whether the process was successful or not.

 

Steps :-

  • Input is an excel file with some data as show above.
  • You need to compare the data with a fixed value and update it back to the excel.
  • Output file is also an excel which has the status column filled as shown above.
Like this post then let your friends know about this-:

Leave a Reply

Your email address will not be published. Required fields are marked *