Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 June 2023

Top 3 Topics with Most Views

UiPath Assistant for Excel add-in made by @Catalina_Ianus with 214 views.

Sort or Getting specific words that be included in specific value made by @hoseongwon with 58 views.

Convert Regex Result to String Variable made by @raychel.hall with 57 views.

Top 3 Topics with Most Replies

Date format issue of excel file made by @Cuberoot with 22 replies.

Type Into Error Field made by @dutta.marina with 15 replies.

웹사이트에서 다운로드 한 엑셀파일을 실행시키고싶습니다 made by @Jeongmin_Park with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Yoichi made 37 posts!

@prateek.mehandiratta9 made 35 posts!

Top 3 Most Liked Posts

This post made by @Catalina_Ianus received 6 likes!

UiPath Assistant for Excel add-in

We are glad to announce that we released UiPath Assistant for Excel, the new add-in that enables you to run your attended automations without leaving the Excel spreadsheet. So, whenever you need a robot’s help with structuring, analyzing, or updating data, you can simply open Assistant in the Excel panel and access all your Excel-related automations with no disruptions. The add-in can be accessed and downloaded as follows: Via a direct link from Microsoft AppSource By searching t…

This post made by @supermanPunch received 2 likes!

New Forms Activity Dictionaries Disabled after latest Update!

@AndyMenon , I guess this is an approved bug After updating my Studio to the latest version now, 23.4.2, I do have the same issue. And all the methods you mentioned as a work around does work. You could see that the Arguments Property is Locked in the below image and also the form Path is updated as well : [image] But again this happened only after I updated my Studio.

This post made by @adiijaiin received 2 likes!

ExcelReadRange Activity, custom range

Hi @dbukk Are there some more columns after G, which you don’t wanna read? If that is the case, please do the following, read the whole range starting from A3. Store it in a DataTable variable, retrieve the count of rows from here using ReadRowCount = datatablename.rowCount Then again use a read range activity: pass “A3:G”+ReadRowCount.toString. Thanks Happy Automation!

Top 3 Most Liked Solutions

This solution provided by @adiijaiin received 2 likes!

ExcelReadRange Activity, custom range

Hi @dbukk Are there some more columns after G, which you don’t wanna read? If that is the case, please do the following, read the whole range starting from A3. Store it in a DataTable variable, retrieve the count of rows from here using ReadRowCount = datatablename.rowCount Then again use a read range activity: pass “A3:G”+ReadRowCount.toString. Thanks Happy Automation!

This solution provided by @Harshith_Adyanthaya received 1 likes!

How to bypass captcha in website

Hi @sathish_Kumar6 , Try this chrome extension: Captcha Buster After installing this, you will get a new icon on the captcha screen. Clicking that captcha will be solved automatically using audio. [image] Hope it helps.

This solution provided by @arjunshenoy received 1 likes!

Regular expression not working but it works at Regex101

@Juan_Paz I just observed that the RegEx pattern that you are using to retain the numbers & remove that whitespaces is not actually working when the whitespace is present in the end of the data. [IMG_4320] If your sole purpose is to remove the whitespace, then I’d suggest you to go with the Trim function, like portapapeles2.ToString.Trim Or, if you are determined to achieve this via RegEx, please give the following pattern a try: \s*(\d+)\s* [IMG_4321] 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.