Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 December 2022

Top 3 Topics with Most Views

Give me list of all activities in uipath made by @Vajrang with 100 views.

How does StudioX treat files added to a folder during execution of its "For each file in a folder" made by @murray.trim with 47 views.

Issue with datarow adding made by @Learner007 with 47 views.

Top 3 Topics with Most Replies

Give me list of all activities in uipath made by @Vajrang with 74 replies.

Issue with datarow adding made by @Learner007 with 22 replies.

Not able to run process using orchestrator made by @RAKESH_KUMAR_Tiwari with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 52 posts!

@Kaviyarasu_N made 36 posts!

@sangeethaneelavannan1 made 29 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 2 likes!

DATTABLE / EXCEL Add column with value

Hi @Manikandasamy To add a new column in an Excel file using UiPath, you can use the Add Data Column activity. Here’s an example of how to use this activity: First, drag and drop the Add Data Column activity from the Activities panel onto the Designer panel. Next, specify the input for the activity by setting the properties in the Properties panel. In the DataTable property, specify the data table that you want to add the new column to. In the ColumnName property, specify the name of the ne…

This post made by @AhmedEmad2024 received 1 likes!

Yoichi 3000th Solution Flag Celebration

Congratulations @Yoichi I wish you more and more .

This post made by @Kaviyarasu_N received 1 likes!

PNG to TIFF image converting

Hi @Jerry1 Drag and drop the “Save Image” activity into the designer panel. In the “InputImage” field, specify the file path and name of the PNG image that you want to convert. For example, “C:\Images\Input.png” In the “OutputImage” field, specify the file path and name of the TIFF image that you want to create. For example, “C:\Images\Output.tiff” Run the workflow and the PNG image will be converted to TIFF and saved at the specified location.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

How to initialize array of Datatables

Hi, How about DataSet and DataTableCollection class? We can iterate multiple DataTables as the following. [image] Sample20221221-2aL.zip (3.0 KB) Regards,

This solution provided by @Sudharsan_Ka received 1 likes!

How to avoid alphanumeric and pick only numeric using regex

HI @Raja.G Checkout this expression System.Text.Regex.RegularExpression.Match(YourString,"(?<=\S\s)\d+(?=\s\S)").Tostring [image] Regards Sudharsan

This solution provided by @Kaviyarasu_N received 1 likes!

SharePoint Upload file Size - Office 365 Activities

Hi @AdityaVN There is a file size limit for uploading files to SharePoint using the O365 activities in UiPath. The maximum file size that can be uploaded to SharePoint using the O365 activities is 15 GB. If you are trying to upload a file that is larger than 15 GB, you will need to use a different method to upload the file. If you are experiencing timeouts when uploading files to SharePoint using the O365 activities, there could be a few reasons for this. Here are some things you can try to t…

---

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.

[system]

Daily Forum Report | 22 December 2022

Top 3 Topics with Most Views

Issue in Assign: Exception has been thrown by the target of an invocation made by @_Bhagyashree with 73 views.

JIT compilation is disabled for non-Legacy projects made by @Doneparthi_Chaitanya with 58 views.

How to Merge Two Data table made by @Peace_Maker with 47 views.

Top 3 Topics with Most Replies

Issue in Assign: Exception has been thrown by the target of an invocation made by @_Bhagyashree with 29 replies.

Help on regex statement needed made by @eric.atwood with 19 replies.

Any one help me for the output error (package is missing for (package is invalid ) made by @Shubham_Bidwai with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@Yoichi made 44 posts!

@Rahul_Unnikrishnan made 38 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 4 likes!

How to Merge Two Data table

Hi, Hope the following sample helps you. [image] dtA = dtA.AsEnumerable.Zip(dtB.AsEnumerable,Function(r1,r2) dtA.Clone.LoadDataRow(r1.ItemArray.Zip(r2.ItemArray,Function(v1,v2) if(String.IsNullOrEmpty(v1.ToString),v2,v1)).ToArray,False)).CopyToDataTable Sample20221222-3aL.zip (2.9 KB) Regards,

This post made by @ppr received 2 likes!

Data extraction in the menu is not available

In Addition to above: Back stage option: [grafik] Is connfiguring for new projects Switching a project to classic / modern we do it on the project settings: [grafik]

This post made by @arivu96 received 1 likes!

Yoichi 3000th Solution Flag Celebration

Thank you for all your contributions @Yoichi.Your dedication to helping others is realy inspiring and breaking 3000 solutions is an amazing achievement.

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 4 likes!

How to Merge Two Data table

Hi, Hope the following sample helps you. [image] dtA = dtA.AsEnumerable.Zip(dtB.AsEnumerable,Function(r1,r2) dtA.Clone.LoadDataRow(r1.ItemArray.Zip(r2.ItemArray,Function(v1,v2) if(String.IsNullOrEmpty(v1.ToString),v2,v1)).ToArray,False)).CopyToDataTable Sample20221222-3aL.zip (2.9 KB) Regards,

This solution provided by @ppr received 2 likes!

Data extraction in the menu is not available

In Addition to above: Back stage option: [grafik] Is connfiguring for new projects Switching a project to classic / modern we do it on the project settings: [grafik]

This solution provided by @amit4 received 1 likes!

JIT compilation is disabled for non-Legacy projects

Hi, For me, updating the UiPath.System.Activities to latest version helped resolve the issue which was occurring only at runtime (not while debugging) Hope this helps!

---

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.

[system]

Daily Forum Report | 23 December 2022

Top 3 Topics with Most Views

How to overcome the limitations of Add Data Row made by @Pravin_Mandadi with 53 views.

Take an url with specific text in it made by @Povilas_Jonikas with 42 views.

Add bulk queue items made by @sharu_priya with 42 views.

Top 3 Topics with Most Replies

Table Extraction in preview i could see data but im unable copy same to excel or messagebox made by @niranjan.kummara with 21 replies.

Xml file reading and extracting some information from it made by @RAKESH_KUMAR_Tiwari with 20 replies.

Code is not running completely with action centre made by @Learner007 with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 74 posts!

@Rahul_Unnikrishnan made 61 posts!

@Yoichi made 19 posts!

Top 3 Most Liked Posts

This post made by @uio received 2 likes!

How do I change the format of the date?

Thanks a lot. It worked.

This post made by @Rahul_Unnikrishnan received 1 likes!

Ui Interaction with Microsoft Dynamics Navision 2018

Hello @anaskhan Can you raise it as new topic and share your concern with some screenshot there. Thanks

This post made by @Lahiru.Fernando received 1 likes!

Extract Multi-Language PDF Files using Document Understanding

Hi, You can find the languages supported by DU components here:

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

安定版を選択したのにbeta版に更新される

こんにちは 残念ながら、今回(2022/12)のリリースより更新チャネルが一本化され、 必ず最新版が提供されるようになりました。そのため現時点ではCommunity版については 2022.12-betaを使う以外の選択肢はないようです。 [image]

This solution provided by @Anil_G received 1 likes!

Add AD group to have modify permission on folder

@Zehra Please try this Dim FolderInfo As IO.DirectoryInfo = New IO.DirectoryInfo(FolderPath) Dim FolderAcl As System.Security.AccessControl.DirectorySecurity = FolderInfo.GetAccessControl() FolderAcl.AddAccessRule(New System.Security.AccessControl.FileSystemAccessRule(UserAccount, System.Security.AccessControl.FileSystemRights.Modify, System.Security.AccessControl.InheritanceFlags.ContainerInherit Or System.Security.AccessControl.InheritanceFlags.ObjectInherit, System.Security.AccessControl.P…

This solution provided by @jcb received 1 likes!

Audit logs - Upload package and Update process

Hey @Damian_Schapiro This feature is available to an extent at Tenant Audit level; [image] Unfortunately it doesn’t offer as rich insights as you have requested on the summary page, IE you can only see “Updated 1 Process(es)”. You can click the info button far right to see exactly what process you have updated, but I agree it would be useful to see this info on the actual audit tab rather than having to click into each: [image]

---

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.

[system]

Daily Forum Report | 24 December 2022

Top 3 Topics with Most Views

Add to queue made by @Rajesh_Rao with 58 views.

Variables to add in Add Data Row activity made by @Ram_Shiva_Reddy with 42 views.

How to get windows screen scale and layout value made by @RK_0 with 34 views.

Top 3 Topics with Most Replies

The problem of web site substitution，thank made by @Uddynitjh with 8 replies.

Compare two number with tolerance in % made by @l.sambinelli with 7 replies.

Problem with Custom Activity in package manager uipath studio.Please help me to resolve made by @BReddy_m with 7 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 17 posts!

@Yoichi made 10 posts!

@Anil_G made 9 posts!

Top 3 Most Liked Posts

This post made by @Rahul_Unnikrishnan received 1 likes!

How to master VB.Net code & LINQ for implementing any type of scenarion Using UIPath?

Hello @Ritesh_Burman You can watch the video on the community session regarding the LINQ in UiPath. Also there are courses available in different portals like udemy to learn it. Thanks

This post made by @sunilch received 1 likes!

Compare two number with tolerance in %

Hi @l.sambinelli you can use the same condition how you calculate val = ((dbl_2 - dbl_1)/dbl_1)*100 maxVal = 5 If ( val < maxVal) acceptable value Else Not acceptable

This post made by @Yoichi received 1 likes!

Compare two number with tolerance in %

Hi, FYI, if your tolerance means ±5%, Math.Abs method will help you as the following. [image] 100*Math.Abs(dbl_1-dbl_2)/dbl_1<5 Regards,

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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.

[system]

Daily Forum Report | 25 December 2022

Top 3 Topics with Most Views

Request Credentialアクティビティを使ってサイトにログインしたい made by @gorby with 38 views.

Dynemic selector write in excelfile made by @purnima_mandan with 37 views.

Select Checkbox as per excel row made by @Omkar_Shete1 with 30 views.

Top 3 Topics with Most Replies

Request Credentialアクティビティを使ってサイトにログインしたい made by @gorby with 12 replies.

How to find color in particular cell value made by @Raja.G with 8 replies.

"Select Item " activity not working made by @Sami_Rajput with 6 replies.

Top 3 Users Who Posted The Most

@gorby made 9 posts!

@Anil_G made 8 posts!

@Rahul_Unnikrishnan made 6 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Error Saving Word Document to PDF

@Nora_Almulla I beleive you are pasing extra double quotes…please remove and try it. Cheers

This post made by @sangeethaneelavannan1 received 1 likes!

"Select Item " activity not working

@Sami_Rajput As a workaround,Please use the click activity. Click on the drop and next Click the number using aaname as dynamic attribute and pass that number as variable inside the selector

This post made by @Rahul_Unnikrishnan received 1 likes!

"Select Item " activity not working

Hello @Sami_Rajput Selevt item activity will not support all the dropdowns. I hope the element that you tring to select doesnt support select item activity. Instead go with the click activity. Thanks

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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.

[system]

Daily Forum Report | 26 December 2022

Top 3 Topics with Most Views

Minmax made by @purnima_mandan with 50 views.

Add multiple datatables into single datatable made by @Shyam_Pragash with 41 views.

Need to Extractor Amount in below text using REGEX made by @Vicky_K with 38 views.

Top 3 Topics with Most Replies

Minmax made by @purnima_mandan with 15 replies.

Options strict on disallows implicit conversions from ‘attachment’ to ‘Iresource’ made by @Vijay_Singh with 12 replies.

Checking all rows if specific column contains value of "A" if contains value of "A" it will filter the data table get all the rows that have value of "A" made by @ldiaz with 11 replies.

Top 3 Users Who Posted The Most

@sangeethaneelavannan1 made 30 posts!

@Anil_G made 29 posts!

@Rahul_Unnikrishnan made 28 posts!

Top 3 Most Liked Posts

This post made by @humvale received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello Everyone! My name is Humberto. I have a marketing background and I’m starting my journey on RPA. The Forum looks like a great collaboration tool! Looking forward to having a great experience with IiPath.

This post made by @syed.ali.hasnat06 received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Thanks for providing us with the opportunity to introduce ourselves so that we’ll know about other people. I am Hasnat from Pakistan, graduated in the field of computer science and currently, I am working as a freelance. I was searching for outlook errors then this forum appears in the search engine and I decided to get the knowledge from UiPath, this was the journey.

This post made by @cprima received 1 likes!

2022-wk51 Last week in RPA on YouTube

What happened in the #uipath channels on YouTube last week? Here are videos released from 2022-12-19 thru 2022-12-25 by various creators. Find a YouTube playlist at https://www.youtube.com/playlist?list=PLruuV36qJJXfPBFCsZATiEHLRZI2A18YV … UiPath Job Offer | UiPath Training | RPA Dev In 30 Days | Best rpa projects 21 How to Use the UiPath Attended Framework Full Tutorial 27:34 How to use UiPath Action Center - Full Tutorial 20:04 Want a UiPath Job? Solve This Job Interview…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Error Saving Word Document to PDF

@Nora_Almulla Use path.Combine(var1,var2,var3) This will combine the path…and use a log message to check if you have given it properly Cheers

This solution provided by @Rahul_Unnikrishnan received 1 likes!

Kill Process - in Windows mode not working

@VanjaV You can provide as below. [image] Thanks

This solution provided by @RajKumar_DC received 1 likes!

Palindrome Scenario Based

Hi @Harsha_S1 , Plz refer this site Thanks, Rajkumar

---

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.

[system]

Daily Forum Report | 27 December 2022

Top 3 Topics with Most Views

Add two column in last made by @sshitol with 74 views.

Data excel made by @purnima_mandan with 49 views.

How to find whether string contains any number in it or not made by @sshitol with 45 views.

Top 3 Topics with Most Replies

Get form task returning empty made by @user928 with 22 replies.

データテーブルをフィルタで抽出 made by @autopc01 with 19 replies.

Error is displayed when trying to create 16 digit fixed length random number made by @Deepa_Madkar with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 62 posts!

@sudheern made 33 posts!

@Yoichi made 32 posts!

Top 3 Most Liked Posts

This post made by @111860 received 2 likes!

ICollection<T>とList<T>の使い分け

ありがとうございます。 これまでぼんやり理解していたものが明確になりました。 端的にご説明いただきありがとうございます。

This post made by @Yoichi received 1 likes!

ICollection<T>とList<T>の使い分け

List<T> はICollection<T>を実装していますので、多くの場合List<T>使っておけば 問題は少ないと思います。

This post made by @muuuuuu received 1 likes!

リモートデスクトップ越しのオーケストレーターからの実行について

Thank You！ ありがとうございます！ そちらの設定にて、画面が小さくならずにアプリを起動することができました。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

ICollection<T>とList<T>の使い分け

List<T> はICollection<T>を実装していますので、多くの場合List<T>使っておけば 問題は少ないと思います。

This solution provided by @Anil_G received 1 likes!

Get Activity Name for Get Row Item

@SIM_KAI_YI If the error occurs on that specific activity then it would give the name of that activity only Exception.Source would give the details cheers

This solution provided by @J0ska received 1 likes!

DataTable match only rows with 6 digits in Column0

Better like this: dt = dt.AsEnumerable().Where(Function (row) System.Text.RegularExpressions.Regex.IsMatch(row("Column0").ToString,"[0-9]{6}$")). CopyToDataTable() And alos check this post 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.

[system]

Daily Forum Report | 28 December 2022

Top 3 Topics with Most Views

Excel data row copy made by @purnima_mandan with 66 views.

Adding two new column at the end of the excel sheet dynamically made by @sshitol with 61 views.

One help from master i want made by @Shubham_Bidwai with 57 views.

Top 3 Topics with Most Replies

One help from master i want made by @Shubham_Bidwai with 19 replies.

Excel data row copy made by @purnima_mandan with 10 replies.

Filter Particular column made by @sharu_priya with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 46 posts!

@Yoichi made 27 posts!

@kirankumar.mahanthi1 made 13 posts!

Top 3 Most Liked Posts

This post made by @dokumentor received 1 likes!

Unable to display PDF in Task

Hi everybody I am testing Action Center functionality, more specifically displaying pdf files in tasks but I see the following message instead of PDF (Orchestrator is not enabled for this tenant …): [image] Then a loading circle icon is shown but no PDF is displayed [image] Steps followed are: Upload PDF using Upload Storage File Add argument to Form: pdf_storage HTML Content control in form with embed code to display pdf: [image] Has anyone experienced same issue?

This post made by @Vinoth_Kumar_N received 1 likes!

If the developer wants the selector to identify the Notepad by everything but the first character, how should title be replaced?

Thank you!

This post made by @Anil_G received 1 likes!

If the developer wants the selector to identify the Notepad by everything but the first character, how should title be replaced?

@Vinoth_Kumar_N Option C [image] Cheers

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Unable to get values after XML deserialization

Hi, Hope the following sample helps you. [image] Sample20221228-1L.zip (3.2 KB) Regards,

This solution provided by @Yoichi received 1 likes!

Previewing DataTables from Locals Panels

Hi, At this time, it seems no ways except manipulate and modify the string… I think it would be good to have a feature like DataSet/DataTable Visualizer of Visual Studio. [image] Regards,

This solution provided by @Anil_G received 1 likes!

여러개의 파일을 COPY할 수 있는 방법이 있을까요..?

@swkwon1 Change the type argument in for loop properties to string Directory.getfiles will give the complete path so you need not append the path again item is enough 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.

[system]

Daily Forum Report | 29 December 2022

Top 3 Topics with Most Views

Add DataTable to another DataTable made by @mateusz.wojcik with 77 views.

How to resolve this issue made by @brahmaiahgogula6677 with 53 views.

Error at updating activities package made by @amy93amanda with 45 views.

Top 3 Topics with Most Replies

How to remove special character from excel column made by @Sandhya_Gajare with 17 replies.

How to handle search result made by @Sandhya_Gajare with 17 replies.

UiPath is reading old value from config excel file made by @kashif.ansari417 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@sangeethaneelavannan1 made 29 posts!

@Sandhya_Gajare made 16 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Can i filter all types of dates formats in excel? using linq query

@MitheshBolla Yes you can arrFormats = {"MM/dd/yyyy","MM/d/yyyy","M/dd/yyyy","M/d/yyyy"} datevalue = DateTime.ParseExact(closeDate, arrFormats, System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat) You can use tryparseexact as well Cheers

This post made by @rathishseng received 2 likes!

How to write a variable string to particular header column

Hi Thankyou finally found the cell auto increment method. “C”+(linkedindata.Rows.IndexOf(Row)+2).ToString

This post made by @arivu96 received 1 likes!

"Python Scope: The specified Python path is not valid." Error

Hi @Trevor_Alexander , Welcome to UiPath Forum Please check the python installed file location from your machine. [image] like above image check in from your machine for python and update the path. Regards, Arivu

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Using dictionaries without Microsoft.Activities.Extensions package

@k.entwistle As a work around you can use dictionary directly Dict("key")= value New dictionary(of string,string) can be used for initializing Please check this for work around Cheers

This solution provided by @arivu96 received 1 likes!

How to check if zip file exists in folder or not?

Try below method @Muralikrishna_Surve Method 1 [image] Method 2 File.Exists("F:\Arivu\updatedfile.zip") [image] Regards, Arivu

This solution provided by @kirankumar.mahanthi1 received 1 likes!

Works perfectly when using breakpoint but not while debugging the process

Hi @Shanmathi , I assume you have three values in the excel and you are entering those values one by one using for each row loop in the web application and for each and every value enter your saving by clicking save button in the website am I right. If my understanding is correct then please follow the suggestion below Debugging with breakpoint will slow down your automation execution pace so your getting enough time to click save button so all the three values saving in the website. As sugg…

---

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.

[system]

Daily Forum Report | 30 December 2022

Top 3 Topics with Most Views

How to allows users add their own asset credentials in orchestrator made by @private_matter with 54 views.

How to add tag for item in queue made by @Anil_Potekar with 49 views.

The given key is not present in the dictionary made by @venkateshcheeni09 with 47 views.

Top 3 Topics with Most Replies

The given key is not present in the dictionary made by @venkateshcheeni09 with 33 replies.

Date time tadk made by @purnima_mandan with 14 replies.

Need Help to construct dynamic Document Object Model (DOM) made by @Prathap001 with 14 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 33 posts!

@Anil_G made 24 posts!

@arivu96 made 15 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 4 likes!

Merge multiple rows in one row on basis of rule

Hi @Umer_Shahid , Please refer below xaml file to achive your logic New Microsoft Excel Worksheet.xlsx (10.3 KB) Sequence.xaml (23.3 KB) Regards, Arivu

This post made by @Gokul_Jayakumar received 2 likes!

Excelfile

Hello @Surya_Pawar Kindly Refer to this XAML file, You may get some idea Excel_Column_Read_Dynamical.zip (346.8 KB)

This post made by @Anil_G received 1 likes!

How could I trigger 2 times in different hours?

@pprin001 You can create two triggers at two different times that you need and it should work as expected Instead you can give the control out to orchestrator as well by adding an input argument to the main.xaml file …the input argument can be a true or false value …so when the trigger is created at 4:30 send the value as true and when triggering at 5:30 send value as False…then you need not do any checks and also later if the time changes you need not change anything in the bot rather just ch…

Top 3 Most Liked Solutions

This solution provided by @arivu96 received 4 likes!

Merge multiple rows in one row on basis of rule

Hi @Umer_Shahid , Please refer below xaml file to achive your logic New Microsoft Excel Worksheet.xlsx (10.3 KB) Sequence.xaml (23.3 KB) Regards, Arivu

This solution provided by @Anil_G received 1 likes!

How to allows users add their own asset credentials in orchestrator

@private_matter Create a new role and give the asset edit and view permissions and assign the role to the users cheers

This solution provided by @Anil_G received 1 likes!

Trying to click a menu item on a popup menu that only shows on Hover

@benduong86 Good enough…so if you use selector in the above your tag would mostly be A 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.

[system]

Daily Forum Report | 31 December 2022

Top 3 Topics with Most Views

Transaction items not getting pick made by @pravin_bindage with 42 views.

Split string from text? made by @Tuannna1 with 39 views.

Question and answer don't make sense (debugging in studio module) made by @benduong86 with 34 views.

Top 3 Topics with Most Replies

Split string from text? made by @Tuannna1 with 14 replies.

Question and answer don't make sense (debugging in studio module) made by @benduong86 with 12 replies.

Transaction items not getting pick made by @pravin_bindage with 12 replies.

Top 3 Users Who Posted The Most

@arivu96 made 14 posts!

@Prabin_Chand made 11 posts!

@marian.platonov made 11 posts!

Top 3 Most Liked Posts

This post made by @arivu96 received 1 likes!

Happy New Year 2023

Hi Friends, ** Happy New Year 2023** [images (16)] Let us celebrate the dates on which we change the world.” “The object of a New Year is not that we should have a new year. It is that we should have a new soul. Cheers to a new year and another chance for us to get it right.” Regards, Arivu

This post made by @benduong86 received 1 likes!

Question and answer don't make sense (debugging in studio module)

Thank you for the documentation on Hit Count. The value in the column ‘First Name’ changes with every iteration through the loop, so if it’s not ‘Alex’ to start off with, then the condition is not satisfied and therefore Hit Count remains 0. The first time the value changed to ‘Alex’ (i.e. 1st hit), Hit Count is incremented to 1, and the second time First Name = ‘Alex’ (i.e. 2nd hit) Hit Count is incremented to 2. That’s why I picked answer D. Thank you so much for looking up the Hit Count docu…

This post made by @Anil_G received 1 likes!

Question and answer don't make sense (debugging in studio module)

@benduong86 May be I confused you a bit there…let me try like this The condition provided should be met for the breakpoint to be hit …i.e.,when first column is Alex the condition is met so that is when break point ahould be activated. Hit count is the value where the breakpoint starts counting how many times the condition is met…so when alex is there in firat column for the second time the condition with given hit count is net…so from the second time the breakpoint gets activated… only…

Top 3 Most Liked Solutions

This solution provided by @ashwin.ashok received 1 likes!

From dictionary value, get files in folder count

Hi @MikeC , Could you give this a try? Directory.GetFiles(Dict1("PdfFolderPath").ToString).Count() If that doesn’t work, then would you be so kind as to include snapshot of the error message please? Kind Regards, Ashwin A.K

This solution provided by @RajKumar_DC received 1 likes!

Split string from text?

Hi @Tuannna1, What about this Input [image] Output [image] get text Split the get text value like below [image] st.Split(Environment.NewLine.ToArray)(1).Trim.Split("TaxID: ")(1) Thanks,

[Previous Month] Top 3 Users with the most likes on their solutions

@Anil_G received 79 likes for their solutions!

@Yoichi received 56 likes for their solutions!

@Gokul001 received 20 likes for their solutions!

---

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.

[system]

Daily Forum Report | 01 January 2023

Top 3 Topics with Most Views

How to find the specific value count in excel made by @Raja.G with 40 views.

How to send API call to Azure Language studio made by @Prathap001 with 31 views.

How to get data from action center form and create new form using same data made by @vijayakumar.qed with 31 views.

Top 3 Topics with Most Replies

How to scrap more than 20 rows from a single webpage which does not contain next button made by @keerthana_E_elumalai_S with 11 replies.

How to find the specific value count in excel made by @Raja.G with 7 replies.

"view or change profile" in uipath studiox not visible made by @Ankush_Pandey with 5 replies.

Top 3 Users Who Posted The Most

@Rahul_Unnikrishnan made 4 posts!

@arivu96 made 2 posts!

@Santa_Krish made 2 posts!

Top 3 Most Liked Posts

This post made by @Umarawadee_R received 1 likes!

Not able to see recording option into UIPath studio. Please help me to enable that

This works! Thank you.

This post made by @Kaviyarasu_N received 1 likes!

Happy New Year 2023

Hi Friends, [image]

This post made by @arivu96 received 1 likes!

How to find the specific value count in excel

Hi @Raja.G Please follow below steps 1.use for each row 2.create intmatch count variable and assign value as zero 3. Inside for each row use for each and pass dt.Columns to loop the column 4. Use if condition to check date value match Convert.ToString(row(item)).Contains(“01.01.23”) the increate the count as intmatch=intmatch+1 5. Use if condition intmatch after for each to check the intmatch<4 then follow 6 step 6.use one more foreach to loop datacolumn to identify which column is empty …

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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.

[system]

Daily Forum Report | 02 January 2023

Top 3 Topics with Most Views

List down reasons to shift to RPA with Uipath made by @Vajrang with 72 views.

How to check if any columns are empty in each datatble at the same time made by @sagar.raval with 60 views.

How to get Windows screen size? made by @RVK with 48 views.

Top 3 Topics with Most Replies

List down reasons to shift to RPA with Uipath made by @Vajrang with 16 replies.

Change column value using LINQ made by @Kaviyarasu_N with 16 replies.

How to check if any columns are empty in each datatble at the same time made by @sagar.raval with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 22 posts!

@Kaviyarasu_N made 12 posts!

@marian.platonov made 12 posts!

Top 3 Most Liked Posts

This post made by @ashwin.ashok received 2 likes!

How to check if specific value contains in 'Select Item' or not?

Hi @Muralikrishna_Surve , You can use the Find Children Activity to fetch a UIElement List and then iterate through the items to check if the items you are looking for are present or not. If its not present then throw a Business Exception. If that is too much of a stretch for you, then you could also try encasing the Select Item Activity within a Try-Catch and handle the exception like so, but I wouldn’t recommend this. Its always best to handle known exceptions through conditional logic. K…

This post made by @karthikayini_P received 1 likes!

Happy New Year 2023

Happy New Year

This post made by @hari6 received 1 likes!

An item with the same key has already been added. Key: VisualBasicValue`1_1 error after upgrading to windows

@Yoichi Thank you it worked. Ideally we have to open the Main xaml in notepad and replace the VisualBasicValue 1_1 if there are multiple. Thanks, Harinath

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 1 likes!

Como funciona el orquestador

With the orchestrator, how many robots can I monitor or run? No limit. If it’s a single orchestrator with x number of tenants, how many robots can I run per tenant? No limit. You can run robots based on the allocated runtimes per tenant. How does the orchestrator license issue work? Should you have one orchestrator per robot? No, you can have multiple robots set in Orchestrator. For more details, read this documentation:

This solution provided by @Lahiru.Fernando received 1 likes!

How can I extract data from different invoice types?

Hi… Just like Anil mentioned, you will need to use AI models for these types of use cases. The UiPath AI Center offers a large number of pre-trained models that you could try using for Invoices. If that doesn’t work, you can also train your own model using AI Center. This link will also help:

This solution provided by @Sanjit_Pal received 1 likes!

The answer to this log level question looks wrong

Hey @benduong86 Your answer would be SrNo Log Level 6 Critical 5 Error 4 Warning 3 Information 2 Trace 1 Verbose Thanks, Sanjit

---

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.

[system]

Daily Forum Report | 03 January 2023

Top 3 Topics with Most Views

How to use multiple "Filter" in "For Each File in Folder" Activity? made by @wija with 60 views.

I have to update orchestrator from 2019.10 to 2022.4 made by @Vanitha_VS with 58 views.

How to extract different table data from scanned pdf made by @RAKESH_KUMAR_Tiwari with 56 views.

Top 3 Topics with Most Replies

How can i write the value in existing column made by @Sandhya_Gajare with 32 replies.

How to extract different table data from scanned pdf made by @RAKESH_KUMAR_Tiwari with 28 replies.

How to extract particular subjected mails from list of unread mails? made by @Vaishnav_Tej with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 67 posts!

@Vaishnav_Tej made 23 posts!

@Kaviyarasu_N made 19 posts!

Top 3 Most Liked Posts

This post made by @Kaviyarasu_N received 11 likes!

I have to update orchestrator from 2019.10 to 2022.4

Hi @Vanitha_VS To install AI Center on your on-premises system, you will need to follow these steps: Make sure you have a valid UiPath license that includes the AI Center component. Download the AI Center installer from the UiPath website or your account portal. Install the AI Center software on your on-premises system. This will require a machine with Windows 10 or Windows Server 2016 or later, and at least 8 GB of RAM and 8 CPU cores. You will also need to install .NET Framework 4.7.2 or l…

This post made by @Rahul_Unnikrishnan received 2 likes!

UiPath -Insert Chart & Get Chart activity | How to generate charts & send via email?

Hello All, As part of your automation , maybe you will be getting the requirements to make different charts with the data that you are getting and then to send it via email to respective team members. In UiPath there are activities that helps us to achieve this requirement. Sharing the docs and video demo for understanding the concept. [UiPath -Insert Chart & Get Chart activity | How to generate charts & send via email?| Practical Demo] Thanks

This post made by @ashwin.ashok received 2 likes!

Reframework question

Hi @Akbar_Badhusa , In layman terms, the process will stop only after it finishes processing the current transaction i.e. say you uploaded/dispatched 10 items to queue. If the bot is processing transaction number 5 and you hit stop, the bot will complete processing transaction number 5 before coming to a halt - it won’t stop abruptly unless you kill it. Kind Regards, Ashwin A.K

Top 3 Most Liked Solutions

This solution provided by @Kaviyarasu_N received 11 likes!

I have to update orchestrator from 2019.10 to 2022.4

Hi @Vanitha_VS To install AI Center on your on-premises system, you will need to follow these steps: Make sure you have a valid UiPath license that includes the AI Center component. Download the AI Center installer from the UiPath website or your account portal. Install the AI Center software on your on-premises system. This will require a machine with Windows 10 or Windows Server 2016 or later, and at least 8 GB of RAM and 8 CPU cores. You will also need to install .NET Framework 4.7.2 or l…

This solution provided by @ashwin.ashok received 2 likes!

Excel - Get Specific Range

Hi @esakki1612 , Could you give this workflow a try and let us know if it works out for you? [image] [image] //To find row which contains code dt.AsEnumerable().ToList().FindIndex(Function (x) x("Company Codes").toString.Equals("5000")) //Collects rows until next code dt.AsEnumerable(). Skip(int_rowIndex). TakeWhile(Function(tk,i) i=0 OrElse IsNothing(tk(1)) OrElse String.IsNullOrEmpty(tk(1).ToString.Trim)). CopyToDataTable() FetchRowsBasedonCode.xaml (8.3 KB) Book5.xlsx (8.8 KB) Kind…

This solution provided by @Anil_G received 1 likes!

Multiple selection click with key Control pressed

@Ladimir_Abdala Use Select multiple items activity Or You can do a ctrl down([d(ctrl)]) before the activity of click and then after activity do ctrl up([u(ctrl)]) using type into 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.

[system]

Daily Forum Report | 04 January 2023

Top 3 Topics with Most Views

Click Dynamic dropdown item made by @nagsai with 48 views.

How to iterate over all columns of an excel sheet and change colour of specific cells made by @nmjvk with 44 views.

Extract a number from string made by @pravin_bindage with 44 views.

Top 3 Topics with Most Replies

Selector stability made by @Mark_Rajkumar with 21 replies.

Send dynamic email attachement made by @rayz1503 with 21 replies.

Headers are not Shown when copy Table made by @firas with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 59 posts!

@Sudharsan_Ka made 45 posts!

@Yoichi made 33 posts!

Top 3 Most Liked Posts

This post made by @Gnanapriya_G received 4 likes!

How to merge two arrays - month and year

Hi @gischethans, What about this arrYer = {“2022”, “2023”} arrMon = {“Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”, “Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”} (From x in arrYer From y in arrMon Let z=x+"-"+y Select(z)).ToArray() Thanks,

This post made by @Anil_G received 2 likes!

Filtering Datatable Using Array of String

@benjiherb Please try with linq query as below dt.AsEnumerable.Where(function(x) arr.Any(function(y) x("ColumnA").ToString.Contains(y))).CopyToDatatable dt is the datatble arr is the array containing your strings cheers

This post made by @jeffsilva received 1 likes!

Database Connect Activity Broken when Migrating to Windows activity

Hi Maciej, Good guess on the driver, for me it was that the issue. Never thought of checking the version because we have been using the 32 bit with legacy and it was setup a long time ago. Did this just happen to be the case with this activity set (UiPath.Database) or are generally all newer activities Net5+ using 64 bits as a default? Just curious. @taxguy33 I have mine setup on the System, however I use the Oracle Client 19c at the machine level. Might not be your setup. Oracle Database 19c…

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

Filtering Datatable Using Array of String

@benjiherb Please try with linq query as below dt.AsEnumerable.Where(function(x) arr.Any(function(y) x("ColumnA").ToString.Contains(y))).CopyToDatatable dt is the datatble arr is the array containing your strings cheers

This solution provided by @mahmoud.zaky received 1 likes!

Reframework question

you welcome any time and the right choose is C and i added clarification in below screen hope its help you [image]

This solution provided by @allbran received 1 likes!

データテーブル上の値の変数による指定方法

@HANACCHI 使っている箇所とでスコープが違っている まさしくこれでした。まだUiPath歴が浅いもので何も考えずに宣言したスコープが間違っていたようです。

---

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.

[system]

Daily Forum Report | 05 January 2023

Top 3 Topics with Most Views

How to store variable value into array? made by @hjie30 with 55 views.

How to add 0000 digits in front of a PDF file name that doesnt contain 7 digits? made by @mce with 46 views.

UiPath Assistant connection issue made by @basiscbm with 44 views.

Top 3 Topics with Most Replies

Expression Activity type 'VisualBasicValue`1' requires compilation made by @Shanmathi with 25 replies.

RPA challenge problem made by @RAKESH_KUMAR_Tiwari with 18 replies.

Excel DateTime Data Insert into Database error made by @mavsp8 with 16 replies.

Top 3 Users Who Posted The Most

@Anil_G made 51 posts!

@Sudharsan_Ka made 44 posts!

@mahmoud.zaky made 22 posts!

Top 3 Most Liked Posts

This post made by @Vajrang received 6 likes!

How to use and Implement Reframe work in uipath?

In reframework we have multiple stages Make an input excel file with feedback details in one column and emails to next column in respective rows in first run add activity read range and read the excel sheet and output must be assigned to dtTransactiondata Add bulk queue items input is dttransaction Data Queuename to which items must be added in process workflow add send email activity to : inTransactionItem.SpecificContent(“emailKey”) Subject: Feedback Body: inTransactionItem.SpecificC…

This post made by @Vajrang received 4 likes!

UiPath Assistant connection issue

Make sure you are connected to the correct orchestrator where licenses are provided. In Licence management of orchestrator you can assign developer/ attended / unattended license Logout of assistant and login again

This post made by @alexandru.iordan received 2 likes!

Automation Ops - Source Control in Preview

Automation Ops aims to provide the tools you need to create more and better automations following automation development best practices. Source Control Source Control is the newest addition to your toolbox. It improves your productivity as it is designed to provide an overview of your automation source code right from within UiPath platform. You can now browse through all your automations source code, see the version history and what has changed from one commit to another. You no longer need t…

Top 3 Most Liked Solutions

This solution provided by @Vajrang received 6 likes!

How to use and Implement Reframe work in uipath?

In reframework we have multiple stages Make an input excel file with feedback details in one column and emails to next column in respective rows in first run add activity read range and read the excel sheet and output must be assigned to dtTransactiondata Add bulk queue items input is dttransaction Data Queuename to which items must be added in process workflow add send email activity to : inTransactionItem.SpecificContent(“emailKey”) Subject: Feedback Body: inTransactionItem.SpecificC…

This solution provided by @Vajrang received 4 likes!

UiPath Assistant connection issue

Make sure you are connected to the correct orchestrator where licenses are provided. In Licence management of orchestrator you can assign developer/ attended / unattended license Logout of assistant and login again

This solution provided by @Anil_G received 1 likes!

How to merge two arrays - month and year

@gischethans Just use .ToArray at the end 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.

[system]

Daily Forum Report | 06 January 2023

Top 3 Topics with Most Views

If row contains specifik value, then send that row, to an email made by @christian.bendtsen with 56 views.

Compare 2 datatables problem made by @sophiey with 48 views.

Regex Pattern - Help made by @Manikandasamy with 46 views.

Top 3 Topics with Most Replies

Not taking DataRow item using in_Transaction item made by @Rakesh_Tiwari with 17 replies.

If row contains specifik value, then send that row, to an email made by @christian.bendtsen with 14 replies.

Extract value from Queue using re-framework made by @Sandhya_Gajare with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 56 posts!

@sangeethaneelavannan1 made 25 posts!

@Gokul001 made 18 posts!

Top 3 Most Liked Posts

This post made by @kirankumar.mahanthi1 received 6 likes!

Monthly Forum rewards - December 2022

Congratulations all the winners. Great achievement @Anil_G. All the best for future awards.

This post made by @RajKumar_DC received 6 likes!

Monthly Forum rewards - December 2022

Congratulations to all of you who are a pillar of helping people and Thank you very much for your continued support @Anil_G | @Yoichi | @Gokul001 Special Thanks for your kind help without any encouragement @Yoichi san | @ppr | @postwick

This post made by @Gokul001 received 5 likes!

Monthly Forum rewards - December 2022

Congrats to all the winners Regards Gokul

Top 3 Most Liked Solutions

This solution provided by @Sudharsan_Ka received 1 likes!

How to split a 3 letter or a 2 letter city name from a string

Checkout this @bibinthomas City Name System.Text.RegularExpressions.Regex.Replace(System.Text.RegularExpressions.Regex.Match(ZipCode,"^\S.+(?<=\b.[A-Z])").ToString.Trim,".[A-Z]+$]","").Trim [image] State Name System.Text.RegularExpressions.Regex.Match(ZipCode,"[A-Z]+(?=.\b\d)").ToString.Trim [image] Zip Code System.Text.RegularExpressions.Regex.Match(ZipCode,"\d.*$").ToString.Trim [image]

This solution provided by @Gokul001 received 1 likes!

Regexhelp

Alternative method @Arya_Squares You can also try with Split expression split(split("Case : c123456 > flexible",":")(1),">")(0) [image] Regards Gokul

This solution provided by @Yoichi received 1 likes!

個人でのstudio（studio xではなく）の無料使用は今はできないのでしょうか？

こんにちは 可能てすが、恐らく現在Enterprise のFreeプランが適用されていると思われます。以下一連のトピック参照いただき、いったん組織削除後、コミュニティプランで組織を再作成するのが良いように思えます。

---

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.

[system]

Daily Forum Report | 07 January 2023

Top 3 Topics with Most Views

Add a data column made by @Manju_Reddy_Kanughula with 66 views.

Trying to find date time dynamically made by @Rakesh_Tiwari with 44 views.

CREATE FOLDER in studio made by @purnima_mandan with 36 views.

Top 3 Topics with Most Replies

Trying to find date time dynamically made by @Rakesh_Tiwari with 16 replies.

Issue in copying the excel sheet made by @Cuberoot with 12 replies.

How to filter outlook mail activity based on multiple parameters made by @rameezimtiaz with 10 replies.

Top 3 Users Who Posted The Most

@Anil_G made 42 posts!

@supermanPunch made 18 posts!

@Rakesh_Tiwari made 15 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 2 likes!

If the maximum number of retries is reached, how the io_RetryNumber and io_TransactionNumber will be set

Hi @Akbar_Badhusa , Could you Check the RetryCurrentTransaction workflow, the Flow Decision activities are used to Check if the Retry Number is reached the Maximum limit. If reached it is reset to 0. The Transaction Number will increase by 1, so that it will move on processing the next transaction. [image]

This post made by @rameezimtiaz received 2 likes!

How to filter outlook mail activity based on multiple parameters

This worked “[Subject] = '”+subjectTitle+“’ AND [SenderEmailAddress] = '”+sender+“'”

This post made by @rikulsilva received 1 likes!

Abandoned Queue Item in Long-running workflow

Hi all I have a process build in Document Understanding Template. I noticed that when we sent validation to Action Center and takes more than 24 hours to human validate it, the Queue Item status changes to Abandoned. Doc attached says If a long-running workflow is attached to queue processing and the workflow is in a suspended state, the queue item will remain in an in-progress state even beyond 24 hours until the workflow sets the transaction status upon resumption. Queue item identifiers wi…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

If the maximum number of retries is reached, how the io_RetryNumber and io_TransactionNumber will be set

Hi @Akbar_Badhusa , Could you Check the RetryCurrentTransaction workflow, the Flow Decision activities are used to Check if the Retry Number is reached the Maximum limit. If reached it is reset to 0. The Transaction Number will increase by 1, so that it will move on processing the next transaction. [image]

This solution provided by @rameezimtiaz received 2 likes!

How to filter outlook mail activity based on multiple parameters

This worked “[Subject] = '”+subjectTitle+“’ AND [SenderEmailAddress] = '”+sender+“'”

This solution provided by @allbran received 1 likes!

「テキストを取得」アクティビティで元のタブに戻りUI要素を検索してしまう

自分はモダンデザインを使用しているのでアドバイスいただいたとおりに、 「アプリケーションブラウザを使用」アクティビティを使用してタブをアタッチしたところ ばっちりテキスト取得できました。ありがとうございます！

---

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.

[system]

Daily Forum Report | 08 January 2023

Top 3 Topics with Most Views

How to add multiple txt content to excel made by @koolrc812 with 57 views.

Duplicated row in Append item to collection made by @Hisham_Alshareef with 45 views.

Decrpyt Credentials on Python code made by @2022learncode with 40 views.

Top 3 Topics with Most Replies

Duplicated row in Append item to collection made by @Hisham_Alshareef with 25 replies.

Reading XML files - Deserialize XML activity made by @RPA_Canada with 10 replies.

Is there any date converter which converts AD to BS? made by @Prabin_Chand with 9 replies.

Top 3 Users Who Posted The Most

@Anil_G made 19 posts!

@Rawan.md made 11 posts!

@koolrc812 made 8 posts!

Top 3 Most Liked Posts

This post made by @Irina_Butu received 3 likes!

Job stopped with an unexpected exit code: 0xE0434352 - WriteRangeActivity SOLVED

Hello, I have been facing this error when trying to create a 18 row excel file from a datatable. I had no problems creating another dummy excel using this activity but with a different format. Also, I digged deep in all the similar issues opened on this topic. Im using the latest stable ExcelActivity version : 2.16.1, and no downgrade did anything good. Also, my Event Viewer looked like this: [image] [SOLUTION] Pay attention to your column types - It seems that when converting Guid column…

This post made by @ppr received 3 likes!

Reading XML files - Deserialize XML activity

Find following starter help: [grafik] typeArguments of the different fore each are set to XElement: item = xDoc.Root.Descendants("node") item.Attribute("id").Value item2 = item.Elements("property") "Name: " & item2.Attribute("name").Value attrName = {"ref","value"}.Where(Function (x) item2.Attributes.Any(Function (a) a.Name.LocalName.Equals(x))).First() attrName + ": " + item2.Attribute(attrName).Value Log: [grafik]

This post made by @Yoichi received 2 likes!

Trying to find expression

Hi, In recent version (at least 2012.12), there is a case something wrong around UiPath.Excel or UiPath.Excel.Helpers namespace. For example, the following error occurs when use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex method. [1] I did some tries such as importing UiPath.Excel.Helpers manualy, replace new activity , restarting Studio etc, the problem is solved for some reason… (However when I create a new project, there is same issue.) [2] Regards,

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Reading XML files - Deserialize XML activity

Find following starter help: [grafik] typeArguments of the different fore each are set to XElement: item = xDoc.Root.Descendants("node") item.Attribute("id").Value item2 = item.Elements("property") "Name: " & item2.Attribute("name").Value attrName = {"ref","value"}.Where(Function (x) item2.Attributes.Any(Function (a) a.Name.LocalName.Equals(x))).First() attrName + ": " + item2.Attribute(attrName).Value Log: [grafik]

This solution provided by @Yoichi received 2 likes!

Trying to find expression

Hi, In recent version (at least 2012.12), there is a case something wrong around UiPath.Excel or UiPath.Excel.Helpers namespace. For example, the following error occurs when use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex method. [1] I did some tries such as importing UiPath.Excel.Helpers manualy, replace new activity , restarting Studio etc, the problem is solved for some reason… (However when I create a new project, there is same issue.) [2] Regards,

This solution provided by @Balaji_Murugan received 1 likes!

Append multiple Data Tables in to an existing Excel file starting from a specific column

Hi @Sidney_Vogel , If all the data tables follow the same data structure(at least same number of columns), I would suggest to merge the data tables first using Merge Data Table activity and then write to a specific cell using Write Range.

---

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.

[system]

Daily Forum Report | 09 January 2023

Top 3 Topics with Most Views

Invoke Python Method goes into errors! made by @Re_Walter with 60 views.

Add multiple datatable in for each loop made by @arina with 55 views.

How can I add to the collection? made by @rudgns99 with 48 views.

Top 3 Topics with Most Replies

Read excel content certain words and email made by @koolrc812 with 22 replies.

Erro Could not find a part of the path ...'\1.0.7\content\project.json' made by @guilherme.dias with 15 replies.

Project Notebookを最前面に出さない方法 made by @11159 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Kaviyarasu_N made 36 posts!

@supermanPunch made 18 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

How to Convert string 1234567890 to 123,45,67,890.00 this format

You want to use ToString(“#,#.##”) The 00 in your format will always explicitly put two 0s, not two decimal places.

This post made by @Anil_G received 2 likes!

Read excel content certain words and email

@koolrc812 Did you change the type argument in for loop properties to string? Change that and it should solve that issue…hope this helps Cheers

This post made by @Jacqui_M received 1 likes!

Copy Excel data with all colors and all format

Hey @Merlin_Joseph, welcome to the forum. I would highly suggest installing the BalaReva.Excel.Activities, as mentioned by @balupad14 further up: Copy Excel data with all colors and all format - #8 by balupad14 It works really well and I think it may solve your issue.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to Convert string 1234567890 to 123,45,67,890.00 this format

Hi @Anil_Potekar , Could you Check with the below Expression : CDbl("1234567890").ToString("#,###.00") or CDbl("1234567890").ToString("N",new CultureInfo("hi-IN")) Let us know if this doesn’t work

This solution provided by @supermanPunch received 1 likes!

How to format specific cell in Excel

Hi @nmjvk , Could you try changing the Cell to Range and Check if it works ? Excel.Sheet("Ark1").Range(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+252)+(i+1).ToString+":"+UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+252)+(i+1).ToString) If the above works, I would suggest to assign the value to a variable, so as to ease the repeated use of the same value.

This solution provided by @supermanPunch received 1 likes!

How can i convert dd/mm/yyyy to get the day name?

Hi @Rowley101 , Could you Check with the below Expression : DateTime.ParseExact("09/01/2023","dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).DayOfWeek.ToString

---

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.