Reading excel file using OLEDB Data Provider

Reading excel file using OLEDB Data Provider

I am using OLEDB Data Provider to read excel file, but the problem is that
in excel sheet some cloumn has an invalid value for example instead of
number string is there, When I read this invalid value I get an empty
string instead of actual value.

for above screenshot when read value john i get empty string.
So is there any way to read this invalid value?
Any help will be appreciated.