Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 August 2021

Top 3 Topics with Most Views

Writing .tsv excel file? made by @Bhanu_Rathore with 33 views.

Add dynamic rows to excel made by @li.yu with 23 views.

Not able to scrape Image URLS made by @surya_teja.k with 22 views.

Top 3 Topics with Most Replies

Writing .tsv excel file? made by @Bhanu_Rathore with 13 replies.

Google classroom creating class with bot made by @Hubert_Caguiat with 9 replies.

Not able to scrape Image URLS made by @surya_teja.k with 7 replies.

Top 3 Users Who Posted The Most

@kumar.varun2 made 9 posts!

@Riya_Sharma made 8 posts!

@Yoichi made 7 posts!

Top 3 Most Liked Posts

This post made by @kumar.varun2 received 2 likes!

Read Range convert excel date format automatically

Hi @JuneQuan Use this code in invoke Code and it will work for both the scenarios inputDT.AsEnumerable.Where(Function (x) Not String.IsNullOrEmpty(x(0).ToString)).ToList().ForEach( Sub (row) row(1) = If(row(1).GetType.ToString.Equals("System.DateTime"), CDate(row(1).ToString).ToString("dd/MM/yyyy"), row(1).ToString) End Sub) Instead of row(1) you can provide the column name also like row(“columnName_1”). This is only for the first date column only. For your reference Date Issue.xaml (5.3 K…

This post made by @ranaprathap928 received 1 likes!

Need regex code for PDF Table data extraction

Hi @Steven_McKeering Thanks for the solution. This code is Working. Thank you so much.

This post made by @kumar.varun2 received 1 likes!

Read Range convert excel date format automatically

If the date is in text format it will read it in text format only (i.e., String) but if the date is in date time format it will be read in DateTime Format. Look closely at your input excel file. The date formats are different in input excel. UiPath is reading them correctly.

Top 3 Most Liked Solutions

This solution provided by @kumar.varun2 received 2 likes!

Read Range convert excel date format automatically

Hi @JuneQuan Use this code in invoke Code and it will work for both the scenarios inputDT.AsEnumerable.Where(Function (x) Not String.IsNullOrEmpty(x(0).ToString)).ToList().ForEach( Sub (row) row(1) = If(row(1).GetType.ToString.Equals("System.DateTime"), CDate(row(1).ToString).ToString("dd/MM/yyyy"), row(1).ToString) End Sub) Instead of row(1) you can provide the column name also like row(“columnName_1”). This is only for the first date column only. For your reference Date Issue.xaml (5.3 K…

This solution provided by @prasath17 received 1 likes!

Update column "Comments" based on the search condition from column "Reason Code" using LINQ

@manjesh_kumar - Here you go… Build Datatable - this is just to show you here. You have to use Read Range and save it to Datatable… [image] Invole Code… [image] [image] dtInput.AsEnumerable().Where(Function(row) row(0).ToString.Equals("T9")).ToList.ForEach(Sub(row) row(1) = “I love UIPATH”) My Output - Again, you can replace it with Write Range… [image] Hope this helps…

This solution provided by @ppr received 1 likes!

How can I delete rows of negative and positive cells that cancel each other out?

@nibir08 thanks for detailed case description. Assumptions: Group Values are the same Value and only different on positive or negative Variables: [grafik] Flow: Preperation result DataTable and grouping the data by firtst Column values [grafik] Processing the groups and adding remaining rows to Result Datatable [grafik] e.g. getting the posivite values: (From g In grp Let x = CInt(g(1).toString.Trim) Where x > 0 Select r=g).toList getting the common count: {PosRows.Count, NegRo…

---

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.