Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 May 2023

Top 3 Topics with Most Views

Compare excel sheet made by @AbarnaKalaiselvam with 73 views.

I had a time in DT. How to add all time values made by @Puneet_Singh1 with 55 views.

Clicking on particular element in DataTable with For Loop made by @WilfredNg with 54 views.

Top 3 Topics with Most Replies

Compare excel sheet made by @AbarnaKalaiselvam with 36 replies.

Want date format from excel in a desired type of date format made by @ankur_kaushik2 with 24 replies.

Unable to start app from mobile made by @kunalmathkar24 with 20 replies.

Top 3 Users Who Posted The Most

@Anil_G made 101 posts!

@ankur_kaushik2 made 20 posts!

@AbarnaKalaiselvam made 17 posts!

Top 3 Most Liked Posts

This post made by @pavithra_pavi received 2 likes!

How to convert Excel to PDF using UiPath Official Packages?

Wanna learn "how to convert Excel to PDF using UiPath Official Packages ? ", check out my latest video on the same!. You can convert your excel file into PDF seamlessly. Topic discussed as follows Problem statement :point_right:Required packages to perform the task :point_right:How to use Excel Save As PDF activity :point_right:Prepare the code and run in LIVE [Convert Excel To PDF | UiPath | Excel Save As PDF Activity]

This post made by @vishal.kp received 1 likes!

Variable assignment - I have 4 variables but only one variable will always have value.I want a condition in type into activity which types only that variable which has value

Hi @ravig1206 , Use the nested if statement to check if the variable has the value. Eg:- if(not string.IsNullOrEmpty(a),a,if(not string.IsNullOrEmpty(b),b,next condition if any)) Regards,

This post made by @Anil_G received 1 likes!

Take screenshot of entire window including date time stamp on the taskbar in chrome

@sankaran.33 Do not indicate anything in the classic/Modern take screenshot activity then it would take the screenshot of whole screen as you need. Here is the bot screenshot [Test] cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Use contains function in If condition

@Akshat_Sharma1 Please use this Arr1.Where(function(x) str.ToLower.Contains(x.ToLower))(0) The array basically contains only one if only one matched and you can access by index (0) Hope this helps Cheers

This solution provided by @Nikhil_Vernekar received 1 likes!

Find (" ") and replace ("") values in Excel file with 50k+ rows

Excel_Data_Trim.zip (10.3 KB) Attached is the workflow. Let me know if this helps!

This solution provided by @Anil_G received 1 likes!

How to clear excel sheet

@suraj_gaikwad Clear datatable will not work… use clear sheet or Delete file Or Use a different filename always Clear datatablew ill only clear the datatable you are writing but not the excel 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.