Forum Engagement Daily Reports

[system]

Daily Forum Report | 25 June 2024

Top 3 Topics with Most Views

Excel to pdf1 made by @yogitagaikwad2206 with 50 views.

Put excel to database made by @dfd2e18560c138cb7425711f7 with 43 views.

Create new data based on existing data made by @SunnyJha with 42 views.

Top 3 Topics with Most Replies

Excel to pdf1 made by @yogitagaikwad2206 with 13 replies.

Get JObjects made by @dutta.marina with 12 replies.

Extract contents of a Table from Io_ExtractionResult Variable made by @Dhruvi_Arumugam with 11 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 48 posts!

@pravallikapaluri made 37 posts!

@ppr made 32 posts!

Top 3 Most Liked Posts

This post made by @A_Learner received 2 likes!

Queues with unique reference

Thank you, @Parvathy Good explanation.

This post made by @harika_k received 1 likes!

How to split the Apartment details from address

Thank you Pravallika the solution works

This post made by @Yoichi received 1 likes!

How to merge the cell with LINQ and UiPath?

HI, How about the following using ClosedXML? This assumes ID column is sorted in advance. [image] Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim sheet As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetname) Dim previous As String ="" Dim r As Int32 =1 Dim c As Int32 =targetColumnIndex Dim cLetter As String = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(c) Dim startRow As Int32 =1 Dim mergeHeight As Int32 =1 While(True) Dim cell As ClosedXML.Excel.IXLCell …

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to merge the cell with LINQ and UiPath?

HI, How about the following using ClosedXML? This assumes ID column is sorted in advance. [image] Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim sheet As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetname) Dim previous As String ="" Dim r As Int32 =1 Dim c As Int32 =targetColumnIndex Dim cLetter As String = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(c) Dim startRow As Int32 =1 Dim mergeHeight As Int32 =1 While(True) Dim cell As ClosedXML.Excel.IXLCell …

This solution provided by @Anil_G received 1 likes!

Queues with unique reference

@A_Learner You cannot delete items in , in progress state…remaining you can delete and same reference can be added after deletion Cheers

This solution provided by @mkankatala received 1 likes!

Get JObjects

Hi @dutta.marina → Use the Deserialize JSon activity and give the string datatype variable as Input let call the Input variable name as JsobInput. → Create a output variable in the Deserialize JSon activity in the JsonObject field in properties, the output datatype is jsonObject datatype, let’s call the variable name as JsonObject. → Then use the assign activity to store the LatestPublishedVersionId in a String Variable. - Assign -> Output = JsonObject("records")(0)("ContentDocument")("La…

---

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.