Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 May 2023

Top 3 Topics with Most Views

I want to use right cell activity using counter mechanism made by @Bhushan_Nagaonkar with 59 views.

Unable extract the all the rows from web data table made by @rchin with 53 views.

Missing Excel Pross Scope made by @TOOKT with 47 views.

Top 3 Topics with Most Replies

I want to use right cell activity using counter mechanism made by @Bhushan_Nagaonkar with 23 replies.

Regex Doubt1 made by @RpaUi02 with 23 replies.

How to grouping excel data to send to API made by @Raja.G with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 77 posts!

@Srini84 made 35 posts!

@supermanPunch made 20 posts!

Top 3 Most Liked Posts

This post made by @Raluca_Ilie received 3 likes!

Rate UiPath on G2 and Get Rewarded

Until May 15th, you can review UiPath on G2 and get rewarded with a 25$ Visa Gift Card. IMPORTANT: If your review will be approved, you will receive the gift card directly from the G2 team as a Thank You for contributing with a detailed, balanced, complete review The UiPath team is not involved in the G2 approval process for your reviews or issuing the gift cards. Please be sure to use your LinkedIn or your business email for validation. This is required by G2 to help verify your experience …

This post made by @Yoichi received 3 likes!

How can i remove this anoying message?

Hi, FYI, if you can upgrade UiPath to 23.4, the following message will be shown and we can choose “Don’t show again” [image] Regards,

This post made by @Jithesh_R received 2 likes!

Monthly Forum rewards - April 2023

Congratulations All

Top 3 Most Liked Solutions

This solution provided by @Mohammad_Irfan received 1 likes!

End of expression expected while using linq in assign

@Karthik23 write the condition in the same line

This solution provided by @supermanPunch received 1 likes!

How to select a sheet of an excel based on regex pattern

Hi @Karthik23 , From the given statements, we can understand that the word mapping appears in both sheetnames and it is in the beginning. But do we need to have a Regex ? We could also go with StartsWith. YourWbSheets.Where(Function(x)x.ToLower.StartsWith("mapping")).FirstOrDefault Do you maybe have some other sheetnames or examples where you believe regex would be more benficial ?

This solution provided by @arjunshenoy received 1 likes!

I want to save the file dynamically

Hi @Shubham_Kinge By the usage of relative path & datetime properties, you can make the file be saved dynamically by the combination of these methods: → currentDirectory = Environment.CurrentDirectory → relativePath = "Data\Output" → fileName = "yourFileName_"+Now.ToString("dd_MM_yyyy")+".yourFileExtension" → savingLocation = Path.Combine(currentDirectory, relativePath, fileName) Hope this helps, Best 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.