How do i populate the date in a calendar

Hi!

I need help…
For a travel agency, I have to choose the check in date and the check out date, but I can’t.
I mention that the data must be extracted from an excel file.
Here is the link of the site: https://www.trivago.ro/

Thanks!

@BID
Please when you create post, provide some information.
For example your excel file.

For example this excel file
Find.xlsx (15.1 KB)
I can adapt the shape of the excel file

Hi there,
I have faced similar problems for selecting dates from calendar.
When you extract the date from excel, get the name of the month and the year as well. Now put a while loop for element exists where the element will be the month and year of the calendar. When the required element exists then BOT will exit the while loop and select that month and after that select date extracted from that month. Its just a game of dynamic selectors over here.
If you are enable to understand this i can share the sample code, just share the sample excel file for reference.
Thanks,
Sarthak

@sarthakgulati13

Hi!

I didn’t work with the while loop.
I would be very grateful if you would help me.
Website: https://www.trivago.ro/
Excel file to which I can change the shape (for example, if I need separate columns for the day, month and year) : Find.xlsx (15.1 KB)

Hi there,
I have made the code for you. Since language was roman, culture I used is “ro”.

Please go through the code if you are enable to understand anything. Please reach me.

Thanks,
SarthakFind.xlsx (9.2 KB) Main.xaml (17.8 KB)

1 Like

@sarthakgulati13
Thank you very much!

I have a small problem… Why don’t the images appear below?



Do you think you could help me with a screenshot?

Its okay if the images are not appearing just make sure that elements are validated properly.

@sarthakgulati13
That’s how it appeared to me when I opened it and I don’t know what to tell it to validate.
Can you help me with the screenshot, to see what you have validated?

@sarthakgulati13

Items are not validated correctly

@sarthakgulati13
I think I succeeded

Now it appears to me:


I think i’ll delete the messegebox…
It is going now, but I have to understand how it goes

Thank you very much!

Happy to help, you can reach out to me if anything required.

Thanks,
Sarthak

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.