Forum Engagement Daily Reports

[system]

Daily Forum Report | 29 August 2021

Top 3 Topics with Most Views

Convert datatable into json format in object? made by @rpa13 with 29 views.

How to separate 1 sheet to several columns based on condition made by @Dorothy_lee with 28 views.

Excel 'No Response' error while Write Range made by @Dorothy_lee with 25 views.

Top 3 Topics with Most Replies

Error with GetAppCredential made by @adamikh96 with 13 replies.

Excel 'No Response' error while Write Range made by @Dorothy_lee with 12 replies.

How to separate 1 sheet to several columns based on condition made by @Dorothy_lee with 9 replies.

Top 3 Users Who Posted The Most

@Dorothy_lee made 13 posts!

@Hiba_B made 12 posts!

@ppr made 10 posts!

Top 3 Most Liked Posts

This post made by @lakshman received 2 likes!

How to separate 1 sheet to several columns based on condition

@Dorothy_lee First use Read Range activity to read the data from excel and it will give output as DataTable. Let’s say ‘dtAccountsData’. And then find unique account by using below expression. dtUniqueAccounts is of type DataTable. dtUniqueAccounts = dtAccountsData.DefaultView.ToTable(true,"Account") And then use ForEach Row activity to iterate one by one account as below. ForEach Row in dtUniqueAccounts dtAccount = dtAccountsData.Select("[Account] = '"+row("Accou…

This post made by @ppr received 2 likes!

Increase same valued data consecutively if occurs more than once

(From d In dtInputData Group d By k=d("Col1").toString.Trim Into grp=Group Let dpr = (grp.Count = 1) Let mba = grp.Select(Function (x,i) k & (i+1).toString).Cast(Of Object).toArray Let nraa = If(dpr, New Object(){k},mba) From ra In nraa Select r=dtOutputData.Rows.Add(ra)).CopyToDataTable

This post made by @Bachali received 1 likes!

Tutorial - Communicate with Jira through UiPath

Hi @PrankurJoshi i have sent you xaml file. Thanks for your support. Regards, Akhil B

Top 3 Most Liked Solutions

This solution provided by @Hiba_B received 1 likes!

Excel 'No Response' error while Write Range

You’re right: I did not notice that she was working with xlsm ! Thank you Then @Dorothy_lee you can only try with write range of excel application scope, and only these 2 options should be tried: before the write range, put a read range empty juste before your write range as explained here first be sure to remove your write range from any excel application scope. Then put your write range in its own excel application scope, and put a kill process and fill it this way (by opening your …

This solution provided by @ieptus received 1 likes!

Issue with Column in Excel Write Cell

Sorry Hiba, thats what your code does

This solution provided by @Hiba_B received 1 likes!

Create column as per Column's value and add data for same Employee in single row

Hi @RohitK ! Sure, here is a suggestion: Paid_or_not_paid.xaml (7.0 KB) Let us know if it does not work as expected or if the code needs more explanation

---

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.