Forum Engagement Daily Reports

[system]

Daily Forum Report | 04 September 2023

Top 3 Topics with Most Views

Errror Compare Two File made by @Muhammad_Taufik_Akbar with 52 views.

How to replace blank cell with 0 using Excel activities made by @lrtetala with 42 views.

UiPath Can't indicate SAP element made by @alvin.c.apostol26 with 40 views.

Top 3 Topics with Most Replies

Conditional formatting made by @E.T.S with 18 replies.

Unable to run app on mobile made by @Mathkar_kunal with 16 replies.

Get queue items -set transaction progress! made by @Hazem_Saleh with 15 replies.

Top 3 Users Who Posted The Most

@Palaniyappan made 50 posts!

@supermanPunch made 30 posts!

@ppr made 28 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This post made by @Anuj_Tiwari received 3 likes!

Migrating Legacy Listings to Windows

Hi everyone, You may already be aware that the default compatibility for new projects in latest versions of UiPath Studio is “Windows”. It’s important to know that the number of users using the Windows projects in Studio is increasing rapidly. The Legacy listings won’t support Windows so those users of latest Studio version(s) won’t be able to find and use Legacy listings under default compatibility. Therefore, we strongly ask all of you to complete the transition of your legacy listings to W…

This post made by @Pothanakar_Prabhakar received 2 likes!

How we can install uipath studio on linux server

Thanks for the resolution @Palaniyappan @arjunshenoy

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 5 likes!

How to replace blank cell with 0 using Excel activities

Hi @lrtetala , Could you try using the below value in ValueToFind property and check : Type.Missing Maybe also Match Entire Cell Contents property is needed to be updated : [image]

This solution provided by @Arvind_Kumar1 received 2 likes!

Passing values from one page to another

@Aditi_Jha , as you shown you are not using VB Apps. so please do below steps on legacy app. Set Value on click rule Create app variable In Set value pass the App variable and set value from your custom list. you can use app variable across other page now. Thanks, Arvind

This solution provided by @supermanPunch received 2 likes!

Write the values based on the column name in write cell activity

Hi @tharani.natarajan , Assuming that you have read the Data as a Datatable in Excel sheet, we can check with the below to convert Column Index to Column Letter : columnLetter = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.IndexOf("MailId")+1) Here, DT is the Datatable variable and columnLetter is a String variable.

---

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.