How to remove Blank Rows using EPPlus Excel Package Plus

Question

I want to transform my Excel sheet into a datatable using EPPlus 4.1.0.0. The final few rows of the excel file are empty. I am therefore adding the empty rows to the datatable when I convert it. Prior to converting it to a datatable, how can I get rid of the empty rows?

Answer 1

Check this answer here: https://stackoverflow.com/a/49232456/1114531. 

It is checking the last row if it is empty and if yes it deletes it and does this until finds a non-empty row. (non-empty means here: all columns in this row have some value).