Forum Engagement Daily Reports

[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.