Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 January 2022

Top 3 Topics with Most Views

I need some help with extracting data from Youtube Playlists made by @Nostradamon1 with 52 views.

Suddenly Bot is not able to read the excel file made by @kkpatel with 43 views.

Regular expression to fetch yellow highlighted value made by @Aleem_Khan with 41 views.

Top 3 Topics with Most Replies

I need some help with extracting data from Youtube Playlists made by @Nostradamon1 with 16 replies.

Type Into 'INPUT email': Could not find target element because Internet Explorer is running in Enhanced Protected Mode made by @Neha_Singh1 with 15 replies.

Suddenly Bot is not able to read the excel file made by @kkpatel with 11 replies.

Top 3 Users Who Posted The Most

@90s_Developer made 27 posts!

@Shikhar_Tandon made 25 posts!

@Robinnavinraj_S made 19 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Convert XLS to XLSX problems

Hi, Your attached file is not xls format but text format. Anyway, how did you convert it to xlsx? I recommend to use SaveExcelFileAs activity in modern-excel as the following. [img20220119-1] Sample20220119-1.zip (4.3 KB) Hope this helps you. Regards,

This post made by @ppr received 2 likes!

I wonder the way using Maketransparent in Uipath

methods with no return values (sub - subroutine) cannot be used within an assign activity we can use: invoke method - sometimes also the reference got lost invoke code

This post made by @Sudharsan_Ka received 2 likes!

Regular expression to fetch yellow highlighted value

HI @Aleem_Khan Expression for Optional modules: (?<=Optional modules:\s)\S.+ Regards Sudharsan

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Convert XLS to XLSX problems

Hi, Your attached file is not xls format but text format. Anyway, how did you convert it to xlsx? I recommend to use SaveExcelFileAs activity in modern-excel as the following. [img20220119-1] Sample20220119-1.zip (4.3 KB) Hope this helps you. Regards,

This solution provided by @pikorpa received 2 likes!

Cannot able to read Orchestrator Asset Value in Read Range

Hey @saritha So you are use double quotes. You don’t need it in the path Instead: “c:\folder\fileName.xlsx” please use: c:\folder\fileName.xlsx

This solution provided by @Robinnavinraj_S received 1 likes!

Fetch url from outlook e mail body

Hi @Aleem_Khan There are two methods to extract Url from Email 1 ) Matches activity In the matches activity click configure regular expressions and Choose regex dropdown as Url [image] pass input string as email body variable and create a output variable in result tab Finally output variable holds Url value 2)using regex in assign activity you have to create a variable Like *Str_Out Str_Out=System.Text.RegularExpressions.Regex.Match(your_email_body_string_variable, “(?:(?:https?|ftp|fil…

---

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.