RPA user testing

[Oratile_Mogajane (Oratile Mapuleng Mogajane)]

Hi all ,

How do I read a date my from an excel data table /column and select it on a web application calendar?
I have attached screenshots of what I am trying to achieve down below:

Thank you in advance
Oratile M

[Shiva_Nikhil]

@Oratile_Mogajane

use read range activity for reading the excel

use for each row in datatable activity

inside you type into activity and pass the value as CurrentRow(“OderDate”).tostring

[sai_gupta]

@Oratile_Mogajane

webCalendarElement.SelectDate(YourExcelDataTable.Rows(0)("YourDateColumn").ToString("yyyy/dd/MM"))

Replace webCalendarElement with the selector or variable representing the web application calendar element, YourExcelDataTable with the Excel data table, and YourDateColumn with the name of the date column in your Excel data table. Adjust the date format (“yyyy/dd/MM” ) to match the format in your Excel data if needed.

cheers…!

[Palaniyappan (Forum Leader)]

Welcome to UiPath forum

Hope you have read the excel and saved the datatable named dt

Now use a for each row loop and pass the above obtained dt as input

To select in date picker refer this video for some insights

Date Picker Automation using UiPath | How to select the required date in the calendar with UiPath?

Cheers @Oratile_Mogajane