Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 March 2021

Top 3 Topics with Most Views

Email attachments are not saving to local folder made by @Deepika_Ajith with 25 views.

Pivot and write excel made by @fairymemay with 24 views.

Pause Automation on a slow website made by @shrayud with 22 views.

Top 3 Topics with Most Replies

Appending data into Data table made by @shekhawat.arjun1307 with 16 replies.

StudioX - Calculate using spreadsheet issue made by @Prinal_C with 15 replies.

I need to identify the value of text in text document but that text occur multiple time made by @Puneet_Singh1 with 9 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 11 posts!

@prasath17 made 11 posts!

@Srini84 made 10 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

I need to identify the value of text in text document but that text occur multiple time

@Puneet_Singh1 give a try with regex: [grafik]

This post made by @moenk received 2 likes!

Pause Automation on a slow website

Sounds as if you like to use this activity:

This post made by @Marius_Puscasu received 2 likes!

Map data excel

Hi @fairymemay , One simple solution is to use the Lookup Data Table activity (https://docs.uipath.com/activities/docs/lookup-data-table ) as within the following example: [Sol] This is the helper file: MapDataExcel.xaml (7.6 KB) Hope this helps! Best regards, Marius

Top 3 Most Liked Solutions

This solution provided by @Marius_Puscasu received 2 likes!

Map data excel

Hi @fairymemay , One simple solution is to use the Lookup Data Table activity (https://docs.uipath.com/activities/docs/lookup-data-table ) as within the following example: [Sol] This is the helper file: MapDataExcel.xaml (7.6 KB) Hope this helps! Best regards, Marius

This solution provided by @prasath17 received 2 likes!

StudioX - Calculate using spreadsheet issue

@Prinal_C - Here you go… [image] Idea I have used here is : First trying to find the last row of any columns…which gives me the output: 4 [image] Using this value, i can set my range for the column F… Say : F2: F4 Excel.Sheet(“Sheet1”).Range(“F2:F” + Saved.Values(Of Int32)(“Last Data Row”).ToString) Here: Saved.Values(Of Int32)(“Last Data Row”).ToString) ==> has the value of 4… In the what to write = I am giving the formula as E2*2.5 That’s it here is my output [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.