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
- 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
eventDateand convert the loop variable by assigning
eventDate = Convert.ToDateTime(item). This variable has properties like
Dayand so on that you can use in making the right selectors for the mouse click activities.