Brandon Brandon - 1 month ago 6
C# Question

Checking ListObject value

I am trying to check a range within my

ListObject
to see if it contains the number 9. I keep getting a "Cannot implicitly convert type 'int' to 'bool'".

if (xlWorkBook.Worksheets["Sheet1"].ListObjects["table1"].Range[1, 1].value2 = 9)
{
xlSheet.Cells[5, 5] = "YES!";
}
else { xlSheet.Cells[5, 5] = "NO!";
}


Resolved answer:

if (xlWorkBook.Worksheets["Sheet1"].ListObjects["table1"].Range[1, 1].value2 = 9)
{
xlSheet.Cells[5, 5] = "YES!";
}
else { xlSheet.Cells[5, 5] = "NO!";
}


After reading up on operators for C#, I found out that "==" is used for comparison, while "=" is used for assignment.

Answer
if (xlWorkBook.Worksheets["Sheet1"].ListObjects["table1"].Range[1, 1].value2 == 9)

Your if should look like this. Make a difference between = and ==