How to consolidate same excel file with exact rows each file

Help Activities
, ,
1

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.

image
image1110×439 25.4 KB

2

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