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.ParseorDateTime.ParseExactto 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