How to Use Activities Start Bot Bt Date On Excel Plan schedule

Help Activities
,
1

Hi,

Can anyone help me out with the following? I am building a process where I want my bot to start a process if the date On Excel File (Plan schedule)
Below is a list of dates it will read.

I Use Uipath Community

Start Bot :28-Dec-21 4-Jan-22 8-Jan-22 15-Jan-22 17-Jan-22 26-Jan-22

2

Hi there @Oxoiynaja_Phoojomjit,
I hope you had an excellent weekend!

The simplest approach would likely be to create a Date Checker Process.
This will run (daily) on a machine and:

  • Read your Workbook will Job execution dates.
  • Check whether the current date exists in the Workbook.
  • Start the relevant Job.

In the event the date does not exist, it will simply end with no action.

Alternatively, if the dates follow a pattern, you could make use of a Cron expression for scheduling:
Using Cron Expressions (uipath.com)

Please let me know if you have any questions.
Thanks in advance for your support,
Josh

1 Like
3

Hi Mr_JDavey

Thank You For Your Help.

And I would like to Know Activities In Uipath Studio

Read your Workbook will Job execution dates. --What’ Act.
Check whether the current date exists in the Workbook.–What’ Act.
Start the relevant Job.–What’ Act.

1 Like
4

Hi there @Oxoiynaja_Phoojomjit,
Not a problem in the slightest, there are a few ways to achieve this.
The simplest would use:
Read Range (uipath.com)
For Each Row in Data Table (uipath.com)
The If Activity (uipath.com)
Start Job (uipath.com)

Steps:

  • Read the Range of the Workbook - Output = DataTable
  • For each row in DataTable
    • If - row.Item(“ColumnName”).ToString.Equals(DateTime.Today.ToString(“dd-MMM-yy”)
      • Start Job

Please let me know your thoughts.
Thanks once again for your support,
Josh

1 Like
5

It was of great help to me.

Thank You very Much.

1 Like