How To Upload An Excel File

I am trying to upload an excel file and my code reads the data of excel one by one. Unfortunately as we all know that excel doesn't restrict the data type for each cells, so there is a chance and possibility that my code can catch the exceptions.

How can I do this?

Code:

try
{
// do the statement
}
catch
{
// throw the exception, log it and then proceed to the next, don't stop.
// then prompt the users of all exceptions encountered.
}

I need to process more than 1,000 rows of data from excel. I don't want every time there is an exceptions the uploading process stops and fixed the problem then re-upload the data again. I want to consolidate first all the data with issues or exceptions then deal with it later after the uploading process done.