Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 June 2022

Top 3 Topics with Most Views

While loop executing slowly made by @check_account with 55 views.

How to read large excel xlsx files in Uipath made by @ma.beascoa with 46 views.

Create selector for changing element made by @Lakshya_Garg with 43 views.

Top 3 Topics with Most Replies

Create selector for changing element made by @Lakshya_Garg with 19 replies.

How to clear the unwanted characters from my rows in excel sheet? made by @ydash999 with 18 replies.

Read row by row (Excel) made by @DTECH with 18 replies.

Top 3 Users Who Posted The Most

@muhammedyuzuak made 20 posts!

@Veera_Raj made 20 posts!

@ushu made 17 posts!

Top 3 Most Liked Posts

This post made by @Michael_Halpin received 2 likes!

Creating custom actives in C# .NET 6

Is there an example about how to create custom activities from code using C# on .NET 6? All the examples I have been able to find are from .NET Framework 4.6.

This post made by @Rahul_Unnikrishnan received 1 likes!

Help with selectors studio

@Meu_Eu_Nando if you are trying yo identify which message is howing based on the id you can use get attribute activity as susggested by @Lak_Ui … Drag and drop the activity and indicate on the element. Then select attribute as “id” It will give you the id value as the output. You can use it for validation.

This post made by @Rishik_Chowdary received 1 likes!

Datatable contains particular string

Hi, Good Day…!! I have an scenario like if A or B or C only exists in datatable(Excel) i want to skip that datatable. Attached snapshot below [image] 2- If there is any combination with A or B or C with different data I want to take that particular scenario and continue the process. Attached snapshot below [image] [image] Hope You Understand…!! Thanks, Rishi

Top 3 Most Liked Solutions

This solution provided by @muhammedyuzuak received 1 likes!

Datatable contains particular string

Hi @Rishik_Chowdary, You can remove matched rows using filter datatable. [image] Regards, MY

This solution provided by @Balaji_Muralidharan0807 received 1 likes!

How to empty or clear a dropdown list in Uipath Apps on click of a Button

@mailsmithash So You are getting the values for the drop down from out argument and if you want to clear the values of dropdown, Then you have to empty the values of out arguments. You can use set values acitivity for clearing the values in the out argument which will reflect in dropdown box. Thanks & Regards BM

This solution provided by @jack.chan received 1 likes!

How do I clear the unwanted characters from my rows in excel sheet?

put below code in text filee e.g. vba.txt in excel application scope call the vba function [image] Function removeSpecial() Dim r As Range Set r = ActiveSheet.UsedRange Dim cellRange As Range For Each cellRange In r Debug.Print "r" cellRange.Value = FindReplaceRegex(cellRange, "([\" & Chr(34) & "<>\(\):\!\`\-\.])", "") Next cellRange ActiveWorkbook.Save End Function Function FindReplaceRegex(rng As Range, reg_exp As String, replace As Str…

---

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.