Forum Engagement Daily Reports

[system]

Daily Forum Report | 06 January 2024

Top 3 Topics with Most Views

Autofill in Excel using StudioX made by @flashdrive07 with 42 views.

Unable to extract output of Uipath made by @dipon1112000 with 37 views.

Anchor_base_selector_error made by @Pavan_kumar15 with 35 views.

Top 3 Topics with Most Replies

Unable to extract output of Uipath made by @dipon1112000 with 20 replies.

Excel Automation in Studio X made by @flashdrive07 with 8 replies.

How to write Cell Address in the "Get Cell Color" Under App Integration>Excel>Cell>Get Cell Color? made by @Thiyaga_rajan with 8 replies.

Top 3 Users Who Posted The Most

@vrdabberu made 20 posts!

@dipon1112000 made 12 posts!

@lrtetala made 10 posts!

Top 3 Most Liked Posts

This post made by @Ragavi_Rajasekar received 1 likes!

I have a string like (- ABCDE-15-826-79- - - - - - -) . I want to add B after 9 in this string . This string is not constant , but I always wanted to add B before the last set of hyphens starts

Thank you so much … it worked

This post made by @Praharsha_Kanaparthi2 received 1 likes!

Hi this is Praharsha having problem with using the Classic mode in UIPATH studio the option of classic Mod itself is not visible

ok thank you @vrdabberu

This post made by @mkankatala received 1 likes!

Excel Automation in Studio X

Hi @flashdrive07 Check out the below process: [image] After Find/Replae value activity use the below syntaxes in Set Variable Value activity: Set Variable Value-> column= System.Text.RegularExpressions.Regex.Match(foundX,"[A-Za-z]+").Value.Trim() Set Variable Value-> cal= Convert.ToInt32((System.Text.RegularExpressions.Regex.Match(foundX,"(?<=[A-Z]+)[0-9]+").Value.ToString.Trim())) Set Variable Value-> cal=cal+2 Set Variable Value-> output= String.Concat(column+Cal.ToString) Note: cal i…

Top 3 Most Liked Solutions

This solution provided by @mkankatala received 1 likes!

Excel Automation in Studio X

Hi @flashdrive07 Check out the below process: [image] After Find/Replae value activity use the below syntaxes in Set Variable Value activity: Set Variable Value-> column= System.Text.RegularExpressions.Regex.Match(foundX,"[A-Za-z]+").Value.Trim() Set Variable Value-> cal= Convert.ToInt32((System.Text.RegularExpressions.Regex.Match(foundX,"(?<=[A-Z]+)[0-9]+").Value.ToString.Trim())) Set Variable Value-> cal=cal+2 Set Variable Value-> output= String.Concat(column+Cal.ToString) Note: cal i…

This solution provided by @Jayavignesh_G received 1 likes!

Anchor_base_selector_error

Hi @Pavan_kumar15, Can you please try to revisit the Selectors of anchor. Kindly re-indicate the selector of anchor base again and try it out Thanks in advance, Jay

This solution provided by @lrtetala received 1 likes!

Should stop activity xaml

Hi @siva_sankar arrNumbers = {1, 2, 3, … , 100} strNumbers = String.Join(", ", arrNumbers) In Get Transaction Data state [image] Cheers!!

---

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.