How do I fix :Cannot convert null to double?

Richard Smith

6y9.8k

hello,

Do I am reading an Excel spredsheet and puting the data into arrays like so:

string col1[] = new string[rowCount]; //This is fine

double col2[] = new double[rowCount];

for(int i -= 1, i <= rowCount - 1 ; i++)

{

col1[i] = myWorkBook.Cells[i + 1, 1].Value;

col2[i] = myWorkBook.Cells[i + 1, 2].Value; //Throws Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: 'Cannot convert null to 'double' because it is a non-nullable value type

I tried doing my array as Nullable but that an 8.0 feature and still in 7.3 and cannot upgrade is there a fix to this?

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ashutosh Gupta6y ago
try with double.parse or tryparse
0
Murali Tandabany6y ago
You can convert string to double value using double.TryParse(string value) method. This will handle null values internally and set it to 0 if input value is null or cannot convert to double.
double.TryParse(myWorkBook.Cells[i + 1, 2].Value, out double result);
col2[i] = result;
0