How to consolidate same excel file with exact rows each file

I have this excel files and files count are dynamic and what i want is every excel file will have the exact row count and remove file without datatable row.

you can use Directory.GetFiles(“Directory path”) to get all the files in the directory
use read csv activity to read each file , the out of this will be a datatable and use dt.rows.count to get the row count .If rowcount=0 use delete file activity and pass the file path