I import some values from Excel sheets in C# application. One column is a text basically but can contain any values. I used the following:
Range range = ... // getting this from Excel, works fine
string myString = (string)range.Value2;
I found the solution which may be not so nice but works:
myString = range.Value2 == null ? "" : range.Value2.ToString();
May be something better exists.