Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 December 2021

Top 3 Topics with Most Views

Not all Posts have to be Questions made by @StefanSchnell with 45 views.

HOw to convert .csv files into .xlsx files in uipath made by @Gayathri_Mk with 40 views.

Converting a string variable into date made by @Dr_Raza_Abidi_PhD with 36 views.

Top 3 Topics with Most Replies

HOw to convert .csv files into .xlsx files in uipath made by @Gayathri_Mk with 16 replies.

365 Get Mail Filter and Wrong Received Date made by @ravindar.singh with 10 replies.

Sum amount column and output the result in the next empty row made by @RPA-botDev with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 33 posts!

@kirankumar.mahanthi1 made 23 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @Parth_Doshi received 6 likes!

The UiPath Community Winter Wonderbeats!

I think this is one of the best Hindi song to vibe on: ['Gallan Goodiyaan' Full VIDEO Song | Dil Dhadakne Do | T-Series]

This post made by @Maneesha_de_silva received 5 likes!

The UiPath Community Winter Wonderbeats!

merry christmas [ - YouTube]

This post made by @codemonkee received 4 likes!

Log4j critical vulnerability: CVE-2021-44228

I reached out to our CSM and received the following communication for the time being. The UiPath Security and Product Engineering teams are completing the exposure analysis of the Log4J vulnerability, categorized as CVE-2021-44228 and taking mitigation actions. At this time, UiPath has found no evidence of risk associated with this vulnerability for the following products: Studio (all types), Assistant, Robot (all types including AI Robots, Cloud Robots, etc.) Orchestrator Automation Hub (in…

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 2 likes!

Is it possible to lock a excel file but the bot can open it to do the process

@Soudios You can do in two ways Password protect the excel, and provide the password to the excel application scope Encryption of the file : By using Cryptography activities, Use Encrypt File activity to encrypt entire file using a key, now use Decrypt File activity to decrypt the file and that file can be used in your bot process [image] Hope this will help you Thanks

This solution provided by @Srini84 received 2 likes!

What is the Exception when a sheet does not exist in the Excel Read range activity?

@Kirigirisu_Coin Check below [image] system.ArgumentException Hope this will help you Thanks

This solution provided by @Vijay_RPA received 2 likes!

How to Take between the Matches?

(?s)start_Word(.*?)last_Word you can use this . for last one I think you can use date format regex , Test it in regex101.com

---

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.