-
Notifications
You must be signed in to change notification settings - Fork 0
Logic
Essentially for evaluating expressions EasyExcelFramework uses basic C# syntax in order to keep things concise.
Evaluate an expression and call a worksheet if the result is true
e.g.
| Action | ||
|---|---|---|
| Set Local Int | MyVal | 3 |
| If | MyVal==3 | AnotherWorksheet |
1st Row sets Myval to the value 3
2nd Row Evaluates if MyVal equals 3 and if so will call "AnotherWorksheet"
When an If statement or a Switch doesn't result in an outcome then an alternative worksheet is called
e.g.
| Action | ||
|---|---|---|
| Set Local Int | MyVal | 3 |
| If | MyVal==456 | MainSheet |
| Else | AlternativeSheet |
1st Row sets Myval to the value 3
2nd Row Evaluates if MyVal equals 456 and if so will call "MainSheet"
3rd Row calls "AlternativeSheet" if MyVal doesn't equal 456
Evaluate a value for predefined outcomes
e.g.
| Action | ||
|---|---|---|
| Set Local Int | MyVal | 3 |
| Switch | MyVal | |
| Case | 1 | Worksheet1 |
| Case | 2 | Worksheet2 |
| Case | 3 | Worksheet3 |
| Else | Worksheet4 |
1st Row sets Myval to the value 3
2nd Row sets the switch to look at MyVal
Rows 3 - 5 evaluate MyVal and if it matches the specified value calls the specified worksheet
Row 6 calls Worksheet4 if non of the other options matched