Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 December 2021

Top 3 Topics with Most Views

Tip: How to use Win32 API or DLL Calls with Roslyn Compiler for the Windows and Cross-platform Compatibility Mode made by @StefanSchnell with 43 views.

Read Range not working made by @badal_sharma with 34 views.

Excel datatables work made by @siva_sankar with 33 views.

Top 3 Topics with Most Replies

How to filter excel sheet through if condition made by @Lakshya_Garg with 13 replies.

Excel datatables work made by @siva_sankar with 11 replies.

How to write Row value on next sheet made by @Majunu09 with 10 replies.

Top 3 Users Who Posted The Most

@Srini84 made 27 posts!

@kirankumar.mahanthi1 made 26 posts!

@Jobin_Joy made 25 posts!

Top 3 Most Liked Posts

This post made by @PrankurJoshi received 4 likes!

Monthly Forum rewards - November 2021 - With updates!

Congratulations everyone

This post made by @StefanSchnell received 3 likes!

Tip: How to use Win32 API or DLL Calls with Roslyn Compiler for the Windows and Cross-platform Compatibility Mode

Almost a year ago I introduced the possibility to make Win32 API or DLL calls. However, this approach no longer works with .NET5+, which is Windows compatibility mode in UiPath. So I investigated if there is a possibility to develop this approach for .NET5+ as well. One possible approach can be implemented using the Roslyn compiler. It is part of .NET SDK and also part of the UiPath installation. To be absolute sure install the package Microsoft.CodeAnalysis via Manage Packages. [image] This …

This post made by @Steven_McKeering received 3 likes!

Cron Expression For Specific Days Of Month AND Specific Days Of The Week

Hey @david.kameka Welcome back to the forums You won’t be able to achieve this with a single cron expression (happy to be wrong). You will need to combine the cron expression you have created in your post (0 30 6 ? * 2-6 *) with a non working days Calendar. The calendar will need to be setup exclude the jobs running on the 1st of each month. In summary, these two elements combined will make the job run at 6:30am Monday to Friday minus the 1st of each month because of the Non …

Top 3 Most Liked Solutions

This solution provided by @Steven_McKeering received 3 likes!

Cron Expression For Specific Days Of Month AND Specific Days Of The Week

Hey @david.kameka Welcome back to the forums You won’t be able to achieve this with a single cron expression (happy to be wrong). You will need to combine the cron expression you have created in your post (0 30 6 ? * 2-6 *) with a non working days Calendar. The calendar will need to be setup exclude the jobs running on the 1st of each month. In summary, these two elements combined will make the job run at 6:30am Monday to Friday minus the 1st of each month because of the Non …

This solution provided by @ppr received 3 likes!

Message Box: Empty ChosenButton Output

A formal RnD round came out with following: AutomaticallyCloseAfter: set to 3 seconds YesNoCancel Button Case: not clicking any button - ChosenButton: “OK” Cases: clicking any button - ChosenButton: “” AutomaticallyCloseAfter: not set - YesNoCancel Button Cases: clicking any button - ChosenButton: has the Value of the clicked Button Repeated also with other ButtonOptions: OkCancel - Result as above Fazit: it seems that Requirements/Expectations/Design/Implementation is not on a common p…

This solution provided by @prasath_S received 2 likes!

Is there any way to make a hidden column reappear in Excel?

Hi @Kirigirisu_Coin You can try VBA by using invoke VBA activity, Sub unhide() Columns.EntireColumn.Hidden = False End sub Below is the document for how to use invoke VBA activity, Or you can also try balareve activity to hide/unhide columns

---

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.