Fun with Excel
Frankly, this is starting to look like a bug but I didn't want to jump the gun. I'm using a spreadsheet that has input and expected outputs in their respective columns. I'm taking the results ...
Forum Discussion
I've found that an "empty" cell in an Excel sheet does not test as "Null".
Have you tried using a test similar to what Jared posted in that thread I mentioned? That might be a better test for "empty" contents than testing for "Null".
See, your "empty" cells are not Null... but they are also not strings, so they pass your previous "if" statement but "blow up" when trying to convert that "empty" value to a float...
Not sure if the above code will do what you want it to do, but I think that's where you're going to want to aim...
Have you tried using a test similar to what Jared posted in that thread I mentioned? That might be a better test for "empty" contents than testing for "Null".
if((aqObject.GetVarType(Excel.Cells(i, j+24)) < 2) || (Excel.Cslls(i,j+24) == "Null"))
{
Log.Message("Accecptable Error, test passed");
}
else
{
var numOne = (aqConvert.StrToFloat(Excel.Cells(i, j+24))) ;
}
See, your "empty" cells are not Null... but they are also not strings, so they pass your previous "if" statement but "blow up" when trying to convert that "empty" value to a float...
Not sure if the above code will do what you want it to do, but I think that's where you're going to want to aim...
