How to delete Blank/Empty rows in an Excel

[carmen]

this post could help you.

Remove Empty Rows From DataTable

Hello, I found an older post with about the same question and I wonder whether some new solution has risen. I basically have an excel sheet and I want to delete all empty rows. I tried reading it into a DataTable and removing every empty row but I just can’t find the right way. It seems strange to me that something so simple and useful is so hard to do. Maybe it would make sense to add it as a feature in the next UiPath version. Thanks!