Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 February 2025

Top 3 Topics with Most Views

Remove datarow made by @Gokul_Murali with 29 views.

How to make excel as password protected made by @Chippy_Kolot with 24 views.

Excel insert column activity / slow update made by @giorgio.tabarellidefatis with 18 views.

Top 3 Topics with Most Replies

ExcelからURLリンクを抽出し、WEBに貼付てダウンロードしたい made by @afna with 17 replies.

Filter same column value and add up the values in another column(Linq Query) made by @dutta.marina with 14 replies.

Can you help me to get Regular expression for below made by @naveen.s with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@Yoichi made 19 posts!

@ashokkarale made 17 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Error while converting value into date format

@Akshaya89 Instead of parse use parseExact cheers

This post made by @yedukondaluaregala received 2 likes!

Remove datarow

attaching xmal file for reference Remove_Empty_Rows.xaml (8.2 KB) Test.xlsx (9.1 KB) you can refer sheet2 and sheet3 sheet2 is input and sheet3 is the output try this and let me know if any thing required

This post made by @Manisha_Ravindra received 1 likes!

Error while converting value into date format

@Akshaya89 If you want to convert the date from string to datetime format use this: setDate(DateTime) = DateTime.ParseExact(“02/02/2025”, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) and output will be in datetime

Top 3 Most Liked Solutions

This solution provided by @Manisha_Ravindra received 1 likes!

Error while converting value into date format

@Akshaya89 If you want to convert the date from string to datetime format use this: setDate(DateTime) = DateTime.ParseExact(“02/02/2025”, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) and output will be in datetime

This solution provided by @Manisha_Ravindra received 1 likes!

Multi-Bot architecture help

@Steven_ds_55 Multi-bot architecture means using multiple bots to work together on a process. Instead of one bot doing all the work, multiple bots share the workload, making automation faster and more efficient. Also, If one bot fails, others can continue the work. hope it helps!!

This solution provided by @Manisha_Ravindra received 1 likes!

Get valid phone numbers using Regex

@Nisha_K21 If you want to fetch the phone number including country code(+91) use this: (?:(?:+91[\s-]?)|(?:0))?[6789]\d{9}

---

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.