EXCEL AUTOMATION HELP

Task - read the excel contains 3 column (name, date of birth and amount). If the age is less than 18 and amount greater than 100 then update the amount column to 100. If the age is greater than 18 and amount less than 100 then update the amount column to 100. add an extra column in the excel as status and update the status after each amount updation like amount updated or not

Member Details (1).xlsx (15.1 KB)

Add a column called “Status” manually in your excel file, place the excel file your project folder and use this workflow

ExcelAutomationNameAgeAmount.xaml (11.1 KB)

Let me know in case of any doubts

1 Like

Thank you so much it works

1 Like

Your welcome. Can you please mark my post as solution so that it helps others too?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.