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.
ADITYA
0