Is there any way you can do something like this without using the usual If syntax?
foreach (var cell in ws.Cells[header_row, 1, header_row, ws.Dimension.End.Column])
{
cell.Address == "SomeValue" ? break : continue;
}
Visual Studio doesn't seem to allow an inline If statement with this kind of results.
What am I doing wrong? Or is it actually not possible?
Thanks.
if(cell.Address == "SomeValue") break;
In your sample code, continue isn't needed.
What your are doing with the ? isn't an inline if-statement, this operator is called the conditional operator (it's sometimes also called the ternary operator, but don't confuse it with the elvis operator).
As you can read from the Microsoft documentation, you don't use it to control flow of your application, but as a shorthand to conditionally assign something. As such, the ternary operator must either return a value or throw an exception.
Rewrite your code as such:
if (cell.Address == "SomeValue")
break;
Notice how I omitted the continue; statement, as it is not needed in your case, as the continue statement jumps to the next iteration without completing this iteration (which I assume you don't want here)
Here is a short example of how to use the ternary:
// Instead of this:
if (foo)
bar = "Foo";
else
bar = "Not Foo";
// You can write this
bar = foo ? "Foo" : "Not Foo";
if. They're meant to evaluate to one of two values, andcontinueandbreakdon't evaluate to anything.breaknorcontinueare valuesif-else. It's short for anif-elsewhere both are assigning a value to the same variable.continuesince that's the default behavior when you reach the end of a loop. Note that you cannot have this break or continue logic in the middle of a loop as that would make the rest of the code that comes after it in the loop unreachable.