Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 May 2024

Top 3 Topics with Most Views

I want to extract image from Excel made by @vineelag with 76 views.

Chromeでページの一番最下部へ一瞬で移動したい made by @tan_tan with 60 views.

PDF that has multiple pages but same structure to Excel made by @bidfood_IT with 54 views.

Top 3 Topics with Most Replies

Column not finding from excel DB made by @Pal_Patel with 25 replies.

I want to extract image from Excel made by @vineelag with 17 replies.

Uipath mouse scroll able to identify element even it is not fully. visible made by @BHUSHAN_NAGAONKAR1 with 17 replies.

Top 3 Users Who Posted The Most

@postwick made 37 posts!

@ppr made 22 posts!

@ashokkarale made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Adding Data Tables to Queues

Lets assume a simple GroupBy LINQ returning a list of DataTables, representing each the grouped data Assign Activity: TableList | List(Of DataTable) = (From d in dtData.AsEnumerable Group d by k=d(0).toString.trim into grp=Group Select t = grp.CopyToDataTable).toList with: Select t = grp.CopyToDataTable the DataTable from the group is prepared for the projection Output DataTable Activity OR Write CSV File Activity - read resulting CSV as Text OR Custom CSV conversion OR Generate Data…

This post made by @bidfood_IT received 1 likes!

PDF that has multiple pages but same structure to Excel

Hi all, Can any of you help me by giving me a solution? I have been trying for 3 days right now, but i can’t seem to find a solution. I tried almost all method from Text to documents learning, but i am still failing. So the real question here is: How can i extract the tables from the pdf files? From page 1 - page 10 (same format), and then how can i transfer them over to excel? Few things i would like to point out, that each page representing a place, so i was thinking to create a different t…

This post made by @J0ska received 1 likes!

I want to extract image from Excel

Try attached workflow. XlsSaveImages.xaml (20.2 KB) Cheers

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Adding Data Tables to Queues

Lets assume a simple GroupBy LINQ returning a list of DataTables, representing each the grouped data Assign Activity: TableList | List(Of DataTable) = (From d in dtData.AsEnumerable Group d by k=d(0).toString.trim into grp=Group Select t = grp.CopyToDataTable).toList with: Select t = grp.CopyToDataTable the DataTable from the group is prepared for the projection Output DataTable Activity OR Write CSV File Activity - read resulting CSV as Text OR Custom CSV conversion OR Generate Data…

This solution provided by @Krishna_Raj received 1 likes!

Question regarding DataTables

@karsten_delfino Add Excel Application Scope: Drag and drop the Excel Application Scope activity. Set the WorkbookPath to your Excel file path. Write the DataTable to Excel: Inside the Excel Application Scope, drag and drop the Write Range activity. Set the SheetName to the desired sheet (e.g., “Sheet1”). Set the StartingCell to the starting cell where you want to write (e.g., “A2”). Set the DataTable to dt_Extracted. Set AddHeaders to False if your DataTable does not include headers ch…

This solution provided by @postwick received 1 likes!

Grouped By Data table

And I’m not saying don’t use a queue. I’m saying don’t bother putting the datatable into the queue, write it to an Excel file then create a queue item that points to the file.

---

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.