I am loading an excel file that by default have 500 line (with certain structure).
The customer is downloading the file and then adding how many lines that he wants.
Then he upload it to my server and i need to count the non empty lines - remember the file contain 500 lines by default, but the customer not always fill all the 500 lines..
This is the "data table", how can i count the filled lines and not the empty lines.
dtInvalidCustomers = SessionManager.GetSessionValue<DataTable>(Constants.IMPORT_DATATABLE_INVALIDS);