Forum Engagement Daily Reports

[system]

Daily Forum Report | 03 February 2022

Top 3 Topics with Most Views

How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again? made by @111962 with 46 views.

6 months experience as RPA Developer made by @uicoda with 45 views.

HOW TO RUN A ROBOT WHEN WINDOW IS LOCKED made by @gap with 41 views.

Top 3 Topics with Most Replies

Read Range - Workbook Does made by @allwynbazil with 21 replies.

Cron Expression: Daily at 02:00 Between Second and Second to Last day of each Month made by @Neetu_Goyal with 16 replies.

How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again? made by @111962 with 15 replies.

Top 3 Users Who Posted The Most

@Shikhar_Tandon made 22 posts!

@Gokul001 made 20 posts!

@Nithinkrishna made 18 posts!

Top 3 Most Liked Posts

This post made by @THIRU_NANI received 6 likes!

Monthly Forum rewards - January 2022

Congratulations Guys

This post made by @Srini84 received 6 likes!

Monthly Forum rewards - January 2022

Congratulations to every one, I’m happy to take part into this initiative and good to see many great minds sharing their knowledge to forums I feel every one is winner who are sharing there knowledge with others , Keep rocking guys Thanks Srini

This post made by @Ahmad_Rais received 6 likes!

Monthly Forum rewards - January 2022

congratulation everyone , just last month i posted on the [Monthly Forum rewards ] hoping i will be the up there, and here i am , with the help of everyone @AndersJensen @pravin_calvin @Gokul001 @Yoichi and others who i usually watch and seek for solution , i am able to gain more knowledge and then helping others also!! cheerrs everyone and thank you , next target TOP 1O

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

How to solve this Write Range error : Cannot write to the target range because it has hidden rows. Remove any filters or unhide rows and try again?

Hi, ExcelWriteRange throws exception if there is hidden column or row, as the specification of Excel activities package 2.8.5 or above. So, downgrade Excel activities package to 2.8.4 or lower might resolve this issue. Or can you try to write range to another sheet, then copy it to the target area using other activity? Regards,

This solution provided by @Gokul001 received 2 likes!

How to check the previous date

Hi @vaishali Use Assign activity LHS - Create an variable RHS - Below condition Convert into integer to get only Month CInt( DateTime.ParseExact(“Input String”,(“yyyy MM dd”),Globalization.CultureInfo.InvariantCulture).ToString(“MM”)) Convert into integer to get only Year CInt( DateTime.ParseExact(“Input String”,(“yyyy MM dd”),Globalization.CultureInfo.InvariantCulture).ToString(“yyyy”)) Hope it will works Regards Gokul

This solution provided by @Nithinkrishna received 1 likes!

Modify column values of datatable based on specific condition

Hey @ahmad.sultan Here you go… [nmnithinkrishna__Uipath] PFA - nmnithinkrishna_ConsRowsTimeDiff.zip (8.5 KB) Hope this helps. Thanks #nK

---

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.