good morning everyone I have a question, I don’t know if it’s possible the robot adds continuous data in an excel, without rewriting anything, so the excel is increasing data case I want that when I get to the end of the month, this excel is cleaned or deleted, to generate a new report the way …

Hi @borismh Below is the workflow for the same :- MainPratik.xaml (19.4 KB) [image] [image] [image] To find the current Year :- Int32 currentYear = DateTime.Now.Year Condition to Check If Leap Year or Not :- currentYear Mod 4=0 Dictionary to Store Total Days of Month in Leap Year :- Dic…

Delete excel end of month

Help

NIVED_NAMBIAR (NIVED N) August 12, 2020, 3:46am 9

Hi @borismh

Please look into this, this will help u how to schedule work in orchestrator for every month

Hope it helps

Nived N

Happy Automation

Topic		Replies	Views
Today Date excel file every day updated Something Else feedback	5	690	July 17, 2022
Files not deleting for previous month Activities excel , question	12	307	August 8, 2023
Delete Datarow1 in excel Robot robot , question	7	415	March 9, 2023
Delete range in excel file (issue with date format) Help	6	1466	September 5, 2020
Bot to delete old files Studio studio , question , output_panel	4	845	December 16, 2022

Most Active Users - Yesterday
ppr
Anil_G
Yoichi
ashokkarale
Stef_99
Jon_Smith
KevinE
Sira
asiya_sultana
ABHIMANYU_THITE1
More details...

Delete excel end of month

Related Topics