Forum Engagement Daily Reports

[system]

Daily Forum Report | 18 August 2026

Top 3 Topics with Most Views

UiPath Apps – Search by Name, DOB, or Invoice Number and Display Full Record made by @Rohith_Kumar2 with 67 views.

Need to download studio 2026 version made by @b.gajendran with 65 views.

Read Managed Metadata(taxonomy terms) using Office 365 SharePoint Get List Items made by @A_MD with 65 views.

Top 3 Topics with Most Replies

Need to download studio 2026 version made by @b.gajendran with 10 replies.

Read Managed Metadata(taxonomy terms) using Office 365 SharePoint Get List Items made by @A_MD with 10 replies.

How to remove blank rows in excel made by @Mathkar_kunal with 8 replies.

Top 3 Users Who Posted The Most

@MayureshOfficial_45 made 10 posts!

@Anil_G made 7 posts!

@DMar made 6 posts!

Top 3 Most Liked Posts

This post made by @Abhinay_Reddy1 received 2 likes!

Petrol Receipt Reconciliation Automation – Thank You UiPath Community!

Project Completed – Petrol Receipt Reconciliation Automation I’m happy to share that I’ve completed my Petrol Receipt Reconciliation Automation project using UiPath. Throughout this project, I faced several challenges while building and debugging the workflow, especially around queue transactions, OCR data extraction, reconciliation logic, handling multiple entries, and sending the final report through Gmail. A special thank you to everyone in the UiPath Community who shared their know…

This post made by @Nishantsharma176 received 2 likes!

How to remove blank rows in excel

1. Read Excel Use the Read Range Workbook or Read Range activity. Store the output into a variable named dt. Note: Ensure Add Headers is checked if your sheet has a header row. 2. Remove Blank Rows (Assign Activity) Use the Assign activity to overwrite your variable with the cleaned data: vbnet dt = dt.AsEnumerable().Where(Function(r) Not r.ItemArray.All(Function(c) String.IsNullOrWhiteSpace(c.ToString()))).CopyToDataTable() Use code with caution. How it works: It checks every …

This post made by @MayureshOfficial_45 received 2 likes!

How to remove blank rows in excel

Hi, Yes, you can handle this using LINQ. I would recommend reading the Excel data into a DataTable first, removing the completely blank rows, and then writing the cleaned DataTable back to Excel. You can use this LINQ expression: dtClean = dt.AsEnumerable(). Where(Function(row) Not row.ItemArray.All(Function(x) String.IsNullOrWhiteSpace(x.ToString()))). CopyToDataTable() This will remove rows where all columns are blank. In UiPath, the flow can be: Use Excel File → Read Range → LI…

Top 3 Most Liked Solutions

This solution provided by @ashokkarale received 1 likes!

How to remove blank rows in excel

@Mathkar_kunal I think it’s the formatting which is acting as placeholder for the blank rows. If you are reading the excel and want to remove the empty rows from datatable, follow this: If you want to remove empty rows directly from excel, VBA could be the better option Try this.

---

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.