How to count valid data and invalid data save in excel sheet

Question

How to count valid data and invalid data save in exel sheet when upload this excel in view of asp.net mvc.

And suppose that customer save address at place of name. how to filter that and show on view that valid data.

fatch only those data which is placed right column field.