Forum Engagement Daily Reports

[system]

Daily Forum Report | 20 October 2021

Top 3 Topics with Most Views

UiPath Innovation RPA Hackathon 2021 made by @diana.gray with 46 views.

Good coding practice made by @garimavarshney9 with 35 views.

in_Config("VarName").ToString not working made by @mahrie with 35 views.

Top 3 Topics with Most Replies

in_Config("VarName").ToString not working made by @mahrie with 33 replies.

Browser not opening in foreground made by @amithvs with 20 replies.

Overwrite a row in a Datatable made by @maroua301 with 14 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 54 posts!

@postwick made 44 posts!

@rahulsharma made 34 posts!

Top 3 Most Liked Posts

This post made by @diana.gray received 10 likes!

UiPath Innovation RPA Hackathon 2021

[image] Join the UiPath Innovation RPA 2021 Hackathon challenge that UiPath is doing in association with DevPost. UiPath is constantly looking for ways that individuals can empower change in their environment through RPA. UiPath Innovation RPA 2021 is an initiative aimed at students who have created innovative automation solutions and professional developers who have identified unique ways to incorporate enterprise integration solutions. Category # 1: Student RPA Innovation UiPath continues…

This post made by @Yoichi received 2 likes!

Convert column index to Excel column letter

Hi, Can you try to use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter method as the following? for example, UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(34) returns AH. This input column number is R1C1 style index, so if you use 0-based index, you need to add 1. [img20211020-a] Regards,

This post made by @Palaniyappan received 2 likes!

DataTime 1 month

Hope the below expression would help you validate whether it has crossed a month or not Let’s take like you have the input in Strinput First use a assign activity like this Strinput = String.Join(“/“,Split(Strinput.ToString,” of “)).ToString Use this expression in IF activity (Convert.ToInt32(Datetime.ParseExact(Strinput.ToString.Trim,”dd/MMMM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM”))-Datetime.Now.Month)>1 If true it has passed one month and goes to THEN blo…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Convert column index to Excel column letter

Hi, Can you try to use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter method as the following? for example, UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(34) returns AH. This input column number is R1C1 style index, so if you use 0-based index, you need to add 1. [img20211020-a] Regards,

This solution provided by @ImPratham45 received 1 likes!

How to 'delete Excel sheet', 'Rename excel file with today function' and 'Copy and Paste the existing excel file' using Studio?

-‘Delete Excel sheet’, :- You can use macro to delete Sheet. -‘Rename excel file with today function’ and :- Use Move File activity and in destination use Todays date in file name. (Date.Now.Tostring(“MMddyyyy”)) -‘Copy and Paste the existing excel file’ :- Use copy file activity. Macro:- Sub Delete_Sheet_WithoutWarningMessage() Application.DisplayAlerts = False Sheets(“Sheet2”).Delete Application.DisplayAlerts = True End Sub Reference to use Macro in UiPath using Invoke VBA …

This solution provided by @postwick received 1 likes!

DataTime 1 month

Datetimes don’t have a format. You format them when you output them. If you have Parsed “26 of January of 2021” into a datetime, and have a second datetime to compare to, then you can use DateDiff to get the number of days, weeks, months etc between the two datetimes.

---

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.