Dynamic click on exe application

Help Studio
1

Hi Everyone,

I have some input data in an xlsx file (containing columns for Dates and Reasons). I want to select a date and then fill in the reason, and I need to run a loop for each row (I have hundreds of rows to fill). Could you suggest some best practices or approaches I should use to create this bot? Alternatively, can I automate this process using the REFramework?

Thanks

The image shows a digital calendar for May 2025 with May 20th highlighted, and an area labeled "Insert Reason" below the calendar. (Captioned by AI)
The image shows a digital calendar for May 2025 with May 20th highlighted, and an area labeled "Insert Reason" below the calendar. (Captioned by AI)1636×817 18.2 KB

2

Hi @Naman_Arora

you can use REFramework by treating each row as a transaction item read all data using Read Range store in DataTable then in Get Transaction set each DataRow as transaction then in Process use Assign or Write Cell to fill Reason based on Date condition finally write back updated data.

If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath

3

@prashant1603765 Hi

Can you help me with which activities should I pick to automate this ?
I have list of dates in excel sheet & select those accordingly on the calender
Thanks
Namam

4

Hi @Naman_Arora
try below steps:
Use Excel Application Scope to open the file and Read Range to read the data into a DataTable. Then, use For Each Row to loop through each row. Inside the loop, use Click to open/select the date on the calendar, Type Into to enter the reason, and Click again to save or confirm if needed. Repeat for all rows.