Forum Engagement Daily Reports

[system]

Daily Forum Report | 01 April 2023

Top 3 Topics with Most Views

Deskew library for document image processing made by @Minoh_Kang with 36 views.

Hello team, pls provide solution for this string manipulation.Tq made by @lakshmi_narayana_ch with 34 views.

How to put condition for Null Variable Value made by @jai_kumar2 with 32 views.

Top 3 Topics with Most Replies

Insert data in queue with Bulk add Queue items error made by @Deep_HML with 12 replies.

Regex Range Excel made by @anh.nguyen with 10 replies.

Hello team, pls provide solution for this string manipulation.Tq made by @lakshmi_narayana_ch with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 38 posts!

@arjunshenoy made 13 posts!

@supermanPunch made 10 posts!

Top 3 Most Liked Posts

This post made by @Minoh_Kang received 1 likes!

Deskew library for document image processing

Deskewing is the most commonly required pre-processing that is applied to scanned document images prior to the main processing of data extraction. The following library provides an easy-to-use wrapper for Galfar’s Deskew Tools for use in UiPath document processing workflows. One notable limitation of Galfar’s tools is the lack of support for multi-page TIF files - it works for the first page only. The library enables deskewing of all the pages by disassembling the pages, performing deskewing …

This post made by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

This post made by @supermanPunch received 1 likes!

Insert data in queue with Bulk add Queue items error

Hi @Deep_HML , Maybe also take a look at the below post :

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Insert data in queue with Bulk add Queue items error

@Deep_HML To confirm…did you try with only onw row of data? …first try with it…it might be that the columns names are not exactly matching or so…check those… And yes the limit is 15k or so… We can break the table into rows of 10k and add in 3 loops So use for loop with Enumerable.Range(0,Cint(Math.Ceiling(dt.RowCount/10000))).ToArray and change type argument to integer And inside loop to get each chunk use dt.AsEnumerable.Skip(currentitem*10000).Take(10000).CopyToDataTable And use the chun…

This solution provided by @Anil_G received 1 likes!

CurrentRow properties

@TTYF Say you want to copy from sheet1 to sheet2 each column in the loop then use as below…you can copy whole row as well [image] Excel.Sheet("Sheet1").Range(currentRow.ByField("FieldName").Address) Sheetname is the difference between source and destination Hope this helps cheers

---

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.