检查ListObject值(Checking ListObject value)

检查ListObject值(Checking ListObject value)

我试图检查我的ListObject的范围，看它是否包含数字9.我不断得到一个“不能隐式转换类型'int'到'bool'”。

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

解决了答案：

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

在读完C＃的运算符后，我发现“==”用于比较，而“=”用于赋值。

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.

最满意答案

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

你的if应该是这样的。 在=和==之间有所不同

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

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