Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 July 2022

Top 3 Topics with Most Views

Document Understanding - Creating Excel file and Referencing the same in the end of workflow made by @srinivas_pradeep with 40 views.

How to change entire column date format from "dd-MMM-yyyy" to "MM/dd/yyyy" in one go made by @Krithi1 with 37 views.

How to use Assign activity on Excel? made by @Praveen_Vs with 35 views.

Top 3 Topics with Most Replies

Document Understanding - Creating Excel file and Referencing the same in the end of workflow made by @srinivas_pradeep with 27 replies.

Get DOM element - help made by @Anjali_Rani with 14 replies.

How to change entire column date format from "dd-MMM-yyyy" to "MM/dd/yyyy" in one go made by @Krithi1 with 11 replies.

Top 3 Users Who Posted The Most

@Nithinkrishna made 32 posts!

@Rounak_Kumar1 made 24 posts!

@Rahul_Unnikrishnan made 20 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 3 likes!

XLS - Write Cell - long number

Hi, The following document might help you. Regards,

This post made by @Steven_McKeering received 2 likes!

Need regex code for this

Hello @Rana_Reddy Welcome back to the forums . Take a look at these patterns. Name Amount Due Invoice Number Date of issue To make the best patterns more information is better along with expected outputs. If you want to learn Regex check out my MegaPost. Hopefully this helps Cheers Steve

This post made by @THIRU_NANI received 2 likes!

How to use Assign activity on Excel?

Hey! We can use Add data row to add the rows to particular column… We can use Writecell as well As suggested by the @NIVED_NAMBIAR we can also do in this case CurrentRow("ColumnName").ToString.Trim = Value Regards, NaNi

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

XLS - Write Cell - long number

Hi, The following document might help you. Regards,

This solution provided by @Steven_McKeering received 2 likes!

Need regex code for this

Hello @Rana_Reddy Welcome back to the forums . Take a look at these patterns. Name Amount Due Invoice Number Date of issue To make the best patterns more information is better along with expected outputs. If you want to learn Regex check out my MegaPost. Hopefully this helps Cheers Steve

This solution provided by @Nithinkrishna received 1 likes!

Microsoft Office 365 Scope window

Okay you can directly use O365 activities or download the file locally into the machine & Workbook activities can be used.

---

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.