Excel Automation process

You can do it all within uipath, no need for external database. First you must use the read rows activity to select all rows and add to a datatable variable.

Then you can use LINQ or other methods to remove rows based on criteria (in this case, empty rows). See this post for a helpful method: DataTable filtering with expressions

Here is another method that I’ve used, but I’d go with the first link I posted because it is more succinct. Remove empty row in the excel - #16 by Dave