I am trying to automate selecting dates from a certain column in excel. I can’t use a click activity to pick date. Can I use the Date picker to solve this problem?
Check this below post It will helps You
Using a date picker to automate selecting dates from an Excel column can be challenging since date pickers are typically used with web applications or custom UI elements. However, you can achieve date selection from an Excel column using UiPath by following these steps:
- Read Excel Data:
- Use the “Read Range” activity to read the Excel data into a DataTable, which will include the column with dates.
- Loop Through the DataTable:
- Use a “For Each Row” activity to iterate through each row in the DataTable.
- Date Parsing:
- In the loop, access the date value in the column for each row and parse it to a DateTime object. You might need to use
DateTime.Parse
orDateTime.ParseExact
to handle the date format correctly
If You Have any questions please DM me I will help You if it is resolved please mark it as solution @Sibongiseni
If you want to use Type Into then you don’t need a dynamic selector. You just need to format the date correctly for it to type in.
If you want to use the Date Picker you’d have to use Click to open the date picker and then select a date. Then you’d use a dynamic selector for clicking the correct date.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.