Forum Engagement Daily Reports

[system]

Daily Forum Report | 17 November 2023

Top 3 Topics with Most Views

How to create and replace the old docx with new rename made by @superpunchypp with 60 views.

How to check the content of a folder for specific made by @goncalo.rocha with 44 views.

https://forum.uipath.com/t/700335 made by @SAMANTA_COTTACKAL1 with 43 views.

Top 3 Topics with Most Replies

How to create and replace the old docx with new rename made by @superpunchypp with 43 replies.

How to merge different excel files into single excel file made by @anjani_priya with 32 replies.

How to merge different excel files into single file as different sheets made by @anjani_priya with 20 replies.

Top 3 Users Who Posted The Most

@Nguyen_Van_Luong1 made 38 posts!

@Anil_G made 36 posts!

@superpunchypp made 34 posts!

Top 3 Most Liked Posts

This post made by @Ghanashyam received 13 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

** Congratulations to the New UiPath Student Developer Champions! ** Your journey to this point is a testament to your commitment and passion for innovation. You are not just champions by title, but leaders and inspirations to your peers. Your diverse backgrounds, from different countries and fields of study, enrich our community and bring fresh, transformative perspectives to the world of automation. Eagerly looking forward to the ideas, projects, and contributions you will br…

This post made by @SWEATHA received 3 likes!

Announcement: Meet Our UiPath Student Champions 2023-24!

Hello everyone! I am absolutely honored to be selected as a Student Developer Champion by UiPath, representing Rajalakshmi Engineering College. I am excited to contribute and collaborate with the vibrant UiPath community, with the aim of promoting automation. Connect with me on LinkedIn (https://www.linkedin.com/in/sweatha-r-1877b6230) as I embark on this journey to drive the advancement of automation. I look forward to interact with passionate minds in the field!

This post made by @tazunnisa.badavide received 3 likes!

Delete Excel File after 14 days

[image] @Chetan_Wagh can u try with this And also refer this thread : Delete file with yesterdays date - Help - UiPath Community Forum

Top 3 Most Liked Solutions

This solution provided by @Nguyen_Van_Luong1 received 2 likes!

Delete Excel File after 14 days

Hi @Chetan_Wagh , You can get file after 14 days by date created [image] if you need get all file date = now -14 file.CreationTime.Date.ToString = DateTime.Today.AddDays(-14).ToString if you need get all file date is more than 14 days. file.CreationTime.Date.ToString < DateTime.Today.AddDays(-14).ToString hope it help,

This solution provided by @copy_writes received 1 likes!

How to Upload any file to the specific folder using Phyton code in uipath

The below Code work import os import shutil def move_files(source_path, destination_path): try: # Check if the source directory exists if not os.path.exists(source_path): return "Source directory does not exist" # List all files in the source directory files = os.listdir(source_path) # Filter files with specified extensions valid_files = [file for file in files if file.lower().endswith(('.pdf', '.png', '.jpg', '.jpeg'))] …

This solution provided by @Yoichi received 1 likes!

Convert Present Month Year(28/04/2023) To Financial Year(202401)

How about the following? CurrentRow("Calendar Month (Manual)") = CDate(CurrentRow("Start").ToString).AddMonths(9).ToString("yyyyMM") Sample Sample20231117-1L (2).zip (84.5 KB) Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.