Forum Engagement Daily Reports

[system]

Daily Forum Report | 11 September 2021

Top 3 Topics with Most Views

How to apply OR to regex made by @Kavya_Mamidishetti2 with 29 views.

Is it possible to read an Excel file referenced in another Excel application scope? made by @Kirigirisu_Coin with 28 views.

dt_Final.Rows(row_Number)(Column_Number) interpretation made by @lynnsong986 with 28 views.

Top 3 Topics with Most Replies

How to apply OR to regex made by @Kavya_Mamidishetti2 with 10 replies.

Using Web Controls in UiPath made by @hsendel with 9 replies.

How to Remove timestamp from DateTime Variable made by @Rajesh_Shet with 7 replies.

Top 3 Users Who Posted The Most

@prasath_S made 16 posts!

@Palaniyappan made 14 posts!

@greenlee made 12 posts!

Top 3 Most Liked Posts

This post made by @Aleem_Khan received 2 likes!

Need to do a vlookup and convert column data into Row data using LINQ

Try this for Vlookup (From a In dtSheet1.AsEnumerable() Join b In dtSheet2.AsEnumerable() On a(“Week Day”).ToString Equals b(“Week Day”).ToString Select dtSheet3.LoadDataRow (new Object() { a.Field(Of String)(“Week Day”), b.Field(Of String)(“NAME”),a.Field(Of String)(“Qty”), a.Field(Of String)(“Part Number”), },False)).CopyToDataTable

This post made by @Prem_Rao received 2 likes!

Activities Query

Hi All What is the difference between Screen scraping and Data scraping? Thanks.

This post made by @Kirigirisu_Coin received 1 likes!

Is it possible to read an Excel file referenced in another Excel application scope?

[2021-09-11 (9)] As you can see from the error in the image, I am currently reading a csv file instead of an Excel file in the Read range section. ・What I’m doing now I created a variable called ExcelWk in the output of external Excel application scope. And then, I write ExcelWk.GetSheets(0) at sheet information in Read Range. However, it failed. ・What I want to do I would like to reference Excel file. so is there any way to read an Excel file opened with an external Excel application sco…

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 1 likes!

Is it possible to read an Excel file referenced in another Excel application scope?

That’s absolutely right I was even using excel based activities but I observed lot of stability with workbook activities in its later version So that’s why I suggested based on output I saw And For this try using a KILL PROCESS activity and mention as “EXCEL” in ProcessName propert and then use Write range activity And try to keep the above set of activities inside a TRY block of try catch activity So that even it fails it will go to CATCH block where we can use again a kill process as …

This solution provided by @Palaniyappan received 1 likes!

How To Use UiPath Apps For client that doesn't Have UiPath Acc

Hi This note on pre requisites gives a clear picture that even being attended or unattended it requires UiPath account to be tagged with the user who is running or using the app Cheers @Hendriyanto

This solution provided by @Palaniyappan received 1 likes!

dt_Final.Rows(row_Number)(Column_Number) interpretation

Hi Let’s take it one by one First left side dt_Final.Rows - this gives ienumerable of datarow which means to be simple array of rows Now in that we want specific cell value and if that is needed we need to know that row and column position So when you are trying to mention that row and column position We will be mentioning as index Index value usually starts from 0 for first row or first column So dt_Final.Rows(row number)(column number) Row number and column number here are index po…

---

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.