Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 March 2022

Top 3 Topics with Most Views

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 48 views.

Read range error? made by @fairymemay with 40 views.

Combine several excel files and create pivot made by @vkrivenko with 39 views.

Top 3 Topics with Most Replies

How can I make the Instagram like button dynamic? made by @ridvanucok with 9 replies.

How To Prnt Key values pairs from an dictionary made by @Sidney_Vogel with 9 replies.

Read range error? made by @fairymemay with 9 replies.

Top 3 Users Who Posted The Most

@fernando_zuluaga made 14 posts!

@Shikhar_Tandon made 5 posts!

@fairymemay made 5 posts!

Top 3 Most Liked Posts

This post made by @Thanu_Matheesha1 received 1 likes!

Combine several excel files and create pivot

There are pre-build activities to combine excel files such as merge and to create a pivot table there is an activity called to create a pivot table. Use those pre-built activities to build your work flow

This post made by @vkrivenko received 1 likes!

Combine several excel files and create pivot

Hello, I have given several Excel files with reports. I’ve need to combine them all and create a pivot table. Please, help

This post made by @Lynx received 1 likes!

How to negate a regex?

itis works great!! thank very much @Steven_McKeering

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 1 likes!

How To Prnt Key values pairs from an dictionary

Hi @Sidney_Vogel , You could also try looping through the Keys and reference the Values using the dictionary itself For Each-> Key In in_exceldata.Keys So could you give this a try instead? [image] key+ " " + in_exceldata(key).ToString Also, I’ve changed the ArgumentType to String → [image] BlankProcess1_v1.zip (5.6 KB) Kind Regards, Ashwin A.K

This solution provided by @nikhil.girish received 1 likes!

Need to stop excel and chrome

Hi @Bhjanga_Prabhu I would recommend you to use kill process activity for both EXCEL and Chrome in start of your process Drag 2 kill process activities and in properties just mention process name as excel and Chrome Also make continue on error property as TRUE Thanks

This solution provided by @fernando_zuluaga received 1 likes!

Read range error?

Can you try converting or saving your excel to an CSV file then using the read csv file, it should work and in less time Regards

---

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.