Text to click action

i have dates for an event in excel and I need to select those dates on an application which only has select date on calendar option. So how do i read the date from excel and convert it to mouse click action on the calendar

Try this:

  • Use a Read Column activity to read the appropriate column from the excel file into an array;
  • Use For Each to loop over these items. In the loop, make a DateTime variable, say eventDate and convert the loop variable by assigning eventDate = Convert.ToDateTime(item). This variable has properties like Year, Month, Day and so on that you can use in making the right selectors for the mouse click activities.