Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 February 2023

Top 3 Topics with Most Views

I want Datatable to Excel automatically creating new folder and writing into it made by @Bhushan_Nagaonkar with 40 views.

Input Dialog - multiple choice made by @paulparkes with 38 views.

Get data from Json in Excel made by @GDMM with 37 views.

Top 3 Topics with Most Replies

I want Datatable to Excel automatically creating new folder and writing into it made by @Bhushan_Nagaonkar with 30 replies.

Regex Not Working But Match Activity Highlighting made by @raja.arslankhan with 21 replies.

Filter Data from Excel without Condition made by @Tanzill_Ahsan with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 29 posts!

@supermanPunch made 27 posts!

@Bhushan_Nagaonkar made 18 posts!

Top 3 Most Liked Posts

This post made by @Boopathi.M received 2 likes!

Can I make BlockUserInput Activity property (Mouse or Keyboard) like a Flag option (Enable or Disable mode)

Okay, Thanks for your suggestions @Anil_G and @Sudharsan_Ka

This post made by @Coffeesnob received 1 likes!

Just trying to download a file from a website.... this should be easy

@jeevith wow man, thanks so much, you realy went the extra mile in explaining this, I realy apreciate it thank you.

This post made by @Coffeesnob received 1 likes!

Just trying to download a file from a website.... this should be easy

@Anil_G thanks for the sugestions. I will give it a shot.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

I want Datatable to Excel automatically creating new folder and writing into it

@Bhushan_Nagaonkar , As Already shown above, the .xlsx is a string that is appended inside the double quotes itself "". If you could check back the post suggested above, you might get the idea. In your case, it should be like below : Path.Combine(FolderPath,"OutputDRLAPI_"+Now.ToString("dd_MM_yy_HH_mm_ss")+".xlsx")

This solution provided by @Anil_G received 1 likes!

Dynamically Filter Excel Data and Store in DT

@Tanzill_Ahsan I see the id column is of type integer so as we did tostring it is not filtering Please use currentrow(“id”) and remove .ToString. And to write data into separate sheets you can change the sheetname to Currentrow(“id”).ToString [image] [image] Hope this helps 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.