How to remove the empty rows ?

[Glennsingh44]

I am reading excel file and converting to list but I don't want to add empty rows to my list. Is there any extension which ignores empty rows ?

I am using this : excelPackage.GetWorksheet("Persons").ToList<PersonDto>(); // before adding to list empty rows should be ignored.

Thanks in advance.

[DarshitDrg]

@eraydin Can you please give an update on this? we need to delete the empty column and empty rows before processed further.