Forum Engagement Daily Reports

[system]

Daily Forum Report | 08 April 2023

Top 3 Topics with Most Views

Error Problem please anyone tell me the solution made by @gpkraju.alluri with 48 views.

Problems with base64 decoding made by @rpa.cresmin with 40 views.

I don't understand what to write in the condition made by @sazonov038 with 38 views.

Top 3 Topics with Most Replies

Need help on making existing folderpaths in .xls column as clickable in uipath made by @r0818 with 17 replies.

I want to use mouse scroll functionality made by @Bhushan_Nagaonkar with 10 replies.

https://forum.uipath.com/t/533701 made by @Hammadul_Haque with 8 replies.

Top 3 Users Who Posted The Most

@Anil_G made 26 posts!

@jackie.yue made 10 posts!

@Harshith_Adyanthaya made 9 posts!

Top 3 Most Liked Posts

This post made by @Harshith_Adyanthaya received 3 likes!

How to open particular Excel Sheet

Hi @Muhammad_Anas_Baloch , You can use Excel Application Scope, with Visible property checked. In this case the excel will open. Later you can close it using close workbook activity. [image] Or In Modern activities, you can use Use Excel File activity inside Excel Process Scope and make show excel window property of Excel Process Scope activity to True. [image] Hope it helps.

This post made by @Pavanraj_Shetty received 2 likes!

HTML Email Body

Hi @Farah_halawani Try this Hope this might help you

This post made by @Harshith_Adyanthaya received 2 likes!

How to Add Particular Column values in excel dynamically?

Hi @Vaishnav_Tej , FindSum= (from r in inputDT.AsEnumerable where Double.TryParse(r.Item(“ColName”).ToString,Nothing)=True).Sum(Function(x) cdbl(x(“ColName”).ToString)) Hope this helps.

Top 3 Most Liked Solutions

This solution provided by @Harshith_Adyanthaya received 3 likes!

How to open particular Excel Sheet

Hi @Muhammad_Anas_Baloch , You can use Excel Application Scope, with Visible property checked. In this case the excel will open. Later you can close it using close workbook activity. [image] Or In Modern activities, you can use Use Excel File activity inside Excel Process Scope and make show excel window property of Excel Process Scope activity to True. [image] Hope it helps.

This solution provided by @Anil_G received 2 likes!

How to group by multiple columns and Sum

@anh.nguyen Please use this in Assign and change column names as you need First use a build datatable activity and then create the required group columns and sum columns and give dtoutput in datatable field dtoutput = (From d In dtinput.AsEnumerable() Group d By k1=d(1).toString.Trim,k2=d(2).toString.Trim,k3=d(3).toString.Trim,k4=d(4).toString.Trim Into grp = Group Let sum1 = grp.sum(function(x) cdbl(x("Column1"))).ToString Let sum2 = grp.sum(function(x) cdbl(x("Column2"))).ToString Let sum…

This solution provided by @Harshith_Adyanthaya received 2 likes!

Get the Hours and minutes of the system's current time

Hi @jackie.yue , DateTime.Now.Tostring(“HH:mm”) Check this. Hope it helps.

---

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.