How I can generate On 1st of every month create Monthly report

Help Studio
, ,
1

Hi Team,

How I can generate on 1st of every month creates Monthly report (with columns “CR”, “Status”, “Date”)

please help anyone

thanks
shaik

2

Hi @shaik.muktharvalli1

Use Build Data Table activity
“CR”, “Status”, “Date”

Use Write Range activity

Regards,

3

but I have to generate excel only on 1st of every month

thanks
shaik

4

Hello @shaik.muktharvalli1,

Please check if the current date (now.ToString(“dd-MM-yyyy”)) is equal to “01-MM-yyyy”. If it matches, use the specified columns to create an Excel file.

5

@shaik.muktharvalli1

Create Time Trigger or Use Cron Expression

The image displays a form in UiPath Orchestrator for creating a time trigger, including fields for naming the trigger, setting the process to run, specifying the job priority, frequency, timezone, and other execution details. (Captioned by AI)
The image displays a form in UiPath Orchestrator for creating a time trigger, including fields for naming the trigger, setting the process to run, specifying the job priority, frequency, timezone, and other execution details. (Captioned by AI)1917×941 88.2 KB

Regards,

6

Hie @shaik.muktharvalli1 make your process in studio and publish the process and run it with time trigger and set it every 1st day of month … Like this

This image shows a screenshot of a "Create Time Trigger" configuration window for setting up an automated job schedule in a software application, with fields for name, process name, timezone, frequency, and execution settings. (Captioned by AI)
This image shows a screenshot of a "Create Time Trigger" configuration window for setting up an automated job schedule in a software application, with fields for name, process name, timezone, frequency, and execution settings. (Captioned by AI)921×582 71.3 KB

cheers Happy Automation

7

can you give sample code without trigger

thanks
shaik

8

@shaik.muktharvalli1

The image shows a UiPath workflow with an "If" condition that checks if the current day is the 1st, builds a data table and attempts to write it to a specified workbook and sheet, but the "Write Range Workbook" activity is missing required information for the workbook path, sheet name, and data table. (Captioned by AI)
The image shows a UiPath workflow with an "If" condition that checks if the current day is the 1st, builds a data table and attempts to write it to a specified workbook and sheet, but the "Write Range Workbook" activity is missing required information for the workbook path, sheet name, and data table. (Captioned by AI)667×616 19.4 KB

Regards,

9

thanks you @lrtetala , it’s working fine

thanks
shaik

1 Like
10

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